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

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Èý)

 1.¶à°æ±¾£º¶ÁÒ»Ö²éѯ  ·Ç×èÈû²éѯ
Oracle ²ÉÓÃÁËÒ»ÖÖ
¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7 Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£
²»¹ý£¬ÊµÖÊÉϽ²£¬Oracle ÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽá¹û¡£
·Ç×èÈû²éѯ£º²éѯ²»»á±»Ð´ÈëÆ÷×èÈû£¬µ«ÔÚÆäËûÊý¾Ý¿âÖпÉÄܲ»ÊÇÕâÑù¡£
Oracle Êý¾Ý¿âÖÐÓÐÁ½¸ö·Ç³£ÖØÒªµÄ¸ÅÄî¡£¶à°æ±¾£¨multi-versioning£©Ò»´ÊʵÖÊÉÏÖ¸Oracle Äܹ»´Ó
Êý¾Ý¿âͬʱÎﻯ¶à¸ö°æ±¾µÄÊý¾Ý¡£Èç¹ûÄãÀí½âÁË¶à°æ±¾ÈçºÎ¹¤×÷£¬¾Í»áÖªµÀÄÜ´ÓÊý¾Ý¿âµÃµ½Ê²Ã´¡£ÔÚ½øÒ»
²½ÉîÈëÌÖÂÛOracle ÈçºÎʵÏÖ¶à°æ±¾Ö®Ç°£¬ÏÂÃæÓÃÎÒÈÏΪ×î¼òµ¥µÄÒ»¸ö·½·¨À´ÑÝʾOracle ÖÐµÄ¶à°æ±¾£º
( p_resource_name, p_start_time, p_end_time );
end schedule_resources;
ops$tkyte@ORA10G> create table t
2 as
3 select *
4 from all_users;
Table created.
ops$tkyte@ORA10G> variable x refcursor
ops$tkyte@ORA10G> begin
2 open :x for select * from t;
3 end;
4 /
PL/SQL procedure successfully completed.
ops$tkyte@ORA10G> delete from t;
28 rows deleted.
ops$tkyte@ORA10G> commit;
Commit complete.
ops$tkyte@ORA10G> print x
USERNAME USER_ID CREATED
------------------------------ -------------- ---------------
BIG_TABLE 411 14-NOV-04
OPS$TKYTE 410 14-NOV-04
DIY 69 26-SEP-04
...
OUTLN 11 21-JAN-04
SYSTEM 5 21-JAN-04
ÔÚÇ°ÃæµÄÀý×ÓÖУ¬ÎÒ´´½¨ÁËÒ»¸ö²âÊÔ±íT£¬²¢°ÑALL_USERS ±íµÄһЩÊý¾Ý¼ÓÔØµ½Õâ¸ö±íÖС£È»ºóÔÚÕâ
¸ö±íÉÏ´ò¿ªÒ»¸öÓαꡣÔÚ´ËûÓдӸÃÓαê»ñÈ¡Êý¾Ý£¬Ö»ÊÇ´ò¿ªÓÎ±ê¶øÒÑ¡£
×¢ÒâÒª¼Çס£¬Oracle ²¢²»“»Ø´ð”Õâ¸ö²éѯ¡£´ò¿ªÓαêʱ£¬Oracle ²»¸´ÖÆÈκÎÊý¾Ý£¬Äã¿ÉÒÔÏëÏë¿´£¬
¼´Ê¹Ò»¸ö±íÓÐÊ®ÒÚÌõ¼Ç¼£¬ÊDz»ÊÇÒ²Äܺܿì¾Í´ò¿ªÓαꣿû´í£¬Óαê»áÁ¢¼´´ò¿ª£¬Ëü»á±ßÐнø±ß
»Ø´ð²éѯ¡£»»¾ä»°Ëµ£¬Ö»ÊÇÔÚÄã»ñÈ¡Êý¾ÝʱËü²Å´Ó±íÖжÁÊý¾Ý¡£
ÔÚͬһ¸ö»á»°ÖУ¨»òÕßÒ²¿ÉÒÔÔÚÁíÒ»¸ö»á»°ÖУ»ÕâͬÑùÄܺܺõع¤×÷£©£¬ÔٴӸñíɾ³ýËùÓÐÊý¾Ý¡£Éõ
ÖÁÓÃCOMMIT Ìá½»ÁËɾ³ýËù×öµÄ¹¤×÷¡£¼Ç¼Ðж¼Ã»ÓÐÁË£¬µ«ÊÇÕæµÄûÓÐÁËÂð£¿Êµ¼ÊÉÏ£¬»¹ÊÇ¿ÉÒÔͨ¹ýÓαê»ñ
È¡µ½Êý¾Ý¡£OPEN ÃüÁî·µ»ØµÄ½á¹û¼¯ÔÚ´ò¿ªµÄÄÇÒ»¿Ì£¨Ê±¼äµã£©¾ÍÒѾ­È·¶¨¡£´ò¿ªÊ±£¬ÎÒÃǸù±¾Ã»ÓÐÅö¹ý±í
ÖеÄÈκÎÊý¾Ý¿é£¬µ«´ð°¸ÒѾ­ÊÇÌú°å¶¤¶¤µÄÁË


Ïà¹ØÎĵµ£º

PostgreSQL/Oracle Table

ͨ³£ÎÒ們ÔÚ½¨Á¢ PostgreSQL/Oracle 資ÁÏ庫µÄ時ºò, Èç¹ûҪʹÓà MySQL/MS-SQL identity À×ͬµÄ¹¦ÄÜ, ¾ÍÊÇÒª採Óà Sequence 來½¨Á¢, ¶ø為ÁËÿһ個 Table ¶¼ÓÐ獨Á¢µÄÐò號產ÉúÆ÷, ÎÒ們會½¨Á¢個別µÄ sequence.
ÀýÈç (PostgreSQL samp ......

oracle ASM ÅäÖ㨰²×°dbʱ´´½¨Ñ¡Ôñasm£©

 
oracle ASM ÅäÖà ת
2008-04-30 11:14
oracle ASM ÅäÖÃ
2006Äê12ÔÂ11ÈÕ ÐÇÆÚÒ» 11:09
×Ô¶¯´æ´¢¹ÜÀí (ASM)

   ASM ÊÇ Oracle Êý¾Ý¿â 10g
ÖÐÒ»¸ö·Ç³£³öÉ«µÄÐÂÌØÐÔ£¬ËüÒÔÆ½Ì¨Î޹صķ½Ê½ÌṩÁËÎļþϵͳ¡¢Âß¼­¾í¹ÜÀíÆ÷ÒÔ¼°Èí¼þ RAID µÈ·þÎñ¡£ASM
¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬´Ó¶øÊµÏÖÁËÔÚÊý¾Ý¿â±»¼ÓÔØµ ......

oracleÖµµÃ̽ÌÖµÄÎÊÌâ

¾­³£×öһЩÊý¾Ý¿â²Ù×÷£¬ÔÚ½¨Á¢±íµÄʱºò£¬Ñ¡Ôñ×Ö¶ÎÀàÐÍʱ£¬ÓйØ×Ö·û´®ÀàÐ͵ÄÑ¡Ôñ×ÜÊÇÓÐЩģºý¡£
¡£char
¡£varchar2
¡£nvarchar2
¡£nchar
¹ØÓÚÉÏÃæÁ½¸öÎÒÓеãÓ¡Ïó¡£CHARµÄ³¤¶ÈÊǹ̶¨µÄ£¬¶øVARCHAR2µÄ³¤¶ÈÊÇ¿ÉÒԱ仯µÄ£¬±ÈÈ磬´æ´¢×Ö·û´®“abc"£¬¶ÔÓÚCHAR (20)£¬±íʾÄã´æ´¢µÄ×Ö·û½«Õ¼20¸ö×Ö½Ú(°üÀ¨17¸ö¿Õ×Ö·û)£ ......

Oracle SQL*LoaderÊý¾Ý×°ÔØ

SQL*Loader ÓÃÓÚ½«´óÁ¿Êý¾Ý×°ÈëÊý¾Ý¿â¡£
¢Å¡¢¶¨¿íÊý¾Ý
´´½¨Êý¾ÝÎļþcontrol.txt£º
aaa,bbb
ccc,ddd
eee,fff
´´½¨¿ØÖÆÎļþcontrol.ctl£º
load data
infile 'c:\loader.txt'
append
into table tester.mm(
m1 position(1:3) char,
m2 position(5:7) char)
ÅúÁ¿¼ÓÔØÊý¾Ý£º
sqlldr tester/test control=c:\loade ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ