Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÊý¾Ý¿âµ¼Èëµ½sql server2005

ÒýÓÃ:http://blog.csdn.net/wizardlun/archive/2009/09/08/4531576.aspx
½ñÌ죬ÖÕÓÚ°ÑoracleÖеÄÊý¾Ý¿âµ¼Èëµ½sql serverÖÐÁË£¬·½·¨ÈçÏ£º
  Ò»¡¢ÔÚsql serverÖн¨¸öͬÃûÊý¾Ý¿â£¬ÀýÈçssdb¡£
  ¶þ¡¢ÓÒ¼üµã»÷ssdb,Ñ¡Ôñ“ËùÓÐÈÎÎñ”——>“µ¼ÈëÊý¾Ý”£¬¾Í»áµ¯³öÒ»¸ö“DTSµ¼Èë\µ¼³öÏòµ¼”£¬
µã»÷ÏÂÒ»²½¡£
  ¶þ¡¢ÈçÏÂͼ£º
ÔÚ“Êý¾ÝÔ´”ÏÂÀ­Áбí¿òÖÐÑ¡Ôñ£º“Microsoft OLE DB Provider Oracle”,ÈçÉÏͼ£¬µã»÷“ÊôÐÔ”°´Å¥£¬µ¯³öÈçÏÂͼ£º
ÔÚ“ÊäÈë·þÎñÆ÷Ãû³Æ”Îı¾¿òÀïÊäÈë“SID_Ö÷»úÃû”£¬SID,Ä㽨µÄÊý¾Ý¿âµÄsid,Ö÷»úÃû£¬ÒªÁ¬½ÓµÄoracle·þÎñÆ÷¡£
ÔÙÊäÈëµÇ½Êý¾Ý¿âµÄÓû§Ãû³ÆºÍÃÜÂ룬µã»÷“²âÊÔÁ¬½Ó”£¬µ¯³ö“²âÊÔÁ¬½Ó³É¹¦”£¬ÈçÏÂͼ£º
  Èý¡¢µã»÷È·¶¨£¬µã»÷ÏÂÒ»²½£¬½øÈë“Ñ¡ÔñÄ¿µÄ”´°¿Ú£¬ÈçÏÂͼ
"Ä¿µÄ",ĬÈϾͿɡ£“·þÎñÆ÷”£¬¸ù¾Ý×Ô¼ºÐèÒª£¬Ñ¡Ôñ¡£¸ù¾Ý×Ô¼ºÉèÖõÄÇé¿öÑ¡Ôñ“ʹÓÃWindowsÉí·ÝÑéÖ¤”»¹ÊǓʹÓÃSql ServerÉí·ÝÑéÖ¤”¡£Ìرð×¢ÒâµÄÊÇ£¬“Êý¾Ý¿â”ҪѡÔñÒªµ¼ÈëÊý¾ÝµÄÊý¾Ý¿â¡£µã»÷ÏÂÒ»²½¡£
  ËÄ¡¢½øÈë“Ö¸¶¨±í¸´ÖÆ»ò²éѯ”´°¿Ú£¬ÈçÏÂͼ£º
ĬÈÏ£¬µã»÷ÏÂÒ»²½¡£
  Îå¡¢½øÈë“Ñ¡ÔñÔ´±íºÍÊÓͼ”´°¿Ú£¬ÈçÏÂͼ£º
Ñ¡ÔñÄãÒªµ¼ÈëµÄ±í£¬“ת»»”Ò»À¸Óиö“ ”°´Å¥£¬µã»÷£¬½øÈë“ÁÐÓ³ÉäºÍת»»”´°¿Ú£¬ÈçÏÂͼ£º
¸ù¾Ý×Ô¼ºÐèÒªÉ趨¡£ÉèÖÃÍêºó£¬µã»÷ÏÂÒ»²½¡£
  Áù¡¢½øÈ등£´æ¡¢µ÷¶ÈºÍ¸´ÖÆ°ü”´°¿Ú£¬ÈçÏÂͼ£º
¸ù¾Ý×Ô¼ºµÄÐèÒª£¬ÉèÖ㬵ã»÷ÏÂÒ»²½¡£
  Æß¡¢½øÈë“ÕýÔÚÍê³ÉDTSµ¼Èë\µ¼³öÏòµ¼”´°¿Ú£¬µã»÷“Íê³É”°´Å¥¡£
ÕâÑù£¬¾Í°ÑoacleÊý¾Ý¿âµ¼Èëµ½ÁËsql serverÊý¾Ý¿â¡£


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿â½µµÍHWMµÄ¼¸ÖÖ·½·¨

HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øϽµ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......

ORACLE Êý¾Ý¿âÂß¼­±¸·Ý ¼òµ¥ EXP/IMP

 ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý¿â±ØÐëÔËÐÐÔڹ鵲ģʽÏ£¨ÒµÎñÊý¾Ý¿âÔڷǹ鵲ģʽÏÂÔËÐУ©£¬ÇÒÐèÒª¼«´óµÄÍⲿ´æ´¢É豸£¬ÀýÈç´Å´ø¿â£»µÚ¶þÀ౸·Ý·½Ê½ÎªÂß¼­±¸·Ý£¬ÒµÎñÊý¾Ý¿â²ÉÓôËÖÖ·½Ê½£¬´Ë·½·¨²»ÐèÒªÊý¾Ý¿âÔËÐÐÔڹ鵲ģʽÏ£¬²»µ«±¸·Ý¼òµ¥£¬¶øÇÒ¿ÉÒÔ²»ÐèÒªÍⲿ´æ ......

Oracle USERENVºÍsys_context

1.USEREVN()
·µ»Øµ±Ç°Óû§»·¾³µÄÐÅÏ¢,opt¿ÉÒÔÊÇ:
ENTRYID,SESSIONID,TERMINAL,ISDBA,LABLE,LANGUAGE,CLIENT_INFO,LANG,VSIZE
1.ISDBA   ²é¿´µ±Ç°Óû§ÊÇ·ñÊÇDBAÈç¹ûÊÇÔò·µ»Øtrue
SQL> select userenv('isdba') from dual;
USEREN
------
FALSE
2.SESSION ·µ»Ø»á»°±êÖ¾
SQL> select userenv('sessio ......

oracle±í¿Õ¼ä²Ù×÷

-½¨Á¢±í¿Õ¼ä(oracleÖеÄtablespace(±í¿Õ¼ä)¾ÍÏ൱ÓÚsqlserverµÄdatabase)
CREATE TABLESPACE data01
DATAFILE 'D:\oracle\ora92\oradata\db\DATA01.dbf' SIZE 200M
UNIFORM SIZE 128k;
#Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏΪ64k
--½¨Á¢ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE temp_data
TEMPFILE 'D:\TEMP_DA ......

oracle CursorʹÓôóÈ«

ʹÓÃCursor:
--²âÊÔһϣ¬½ñÌì²ÅÉêÇëʹÓÃitpub.net µÄblog
declare
RoomID Room.RoomID%Type;
RoomName Room.RoomName%Type;
cursor crRoom is
select RoomID,RoomName
from Room;
begin
open crRoom;loop;
fetch crRoom into RoomID,RoomName;
exit when crRoom%notFound;
end loop;
close crRoom;
end;
& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ