ORACLE ROWID
Ò».rowid¼ò½é
rowid¾ÍÊÇΨһ±êÖ¾¼Ç¼ÎïÀíλÖõÄÒ»¸öid£¬ÔÚoracle 8°æ±¾ÒÔǰ£¬rowidÓÉfile#+block#+row#×é³É£¬Õ¼ÓÃ6¸öbytesµÄ¿Õ¼ä£¬10 bit µÄ file# £¬22bit µÄ block# £¬16 bit µÄ row#¡£
´Óoracle 8¿ªÊ¼rowid±ä³ÉÁËextend rowid£¬ÓÉdata_object_id#+rfile#+block#+row#×é³É£¬Õ¼ÓÃ10¸öbytesµÄ¿Õ¼ä£¬ 32bitµÄ data_object_id#,10 bit µÄ rfile#,22bit µÄ block#,16 bit µÄ row#.ÓÉÓÚrowidµÄ×é³É´Ófile#±ä³ÉÁËrfile#£¬ËùÒÔÊý¾ÝÎļþÊýµÄÏÞÖÆÒ²´ÓÕû¸ö¿â²»Äܳ¬¹ý1023¸ö±ä³ÉÁËÿ¸ö±í¿Õ¼ä²»Äܳ¬¹ý1023¸ö Êý¾ÝÎļþ¡£
˵ÁËrowidµÄ×é³É£¬ÄÇôÎÒÃÇÔÙÀ´¿´¿´rowidÔÚË÷ÒýÀïÃæÕ¼ÓõÄ×Ö½ÚÊýÓÖÊÇʲôÑù×ӵġ£ÔÚoracle 8ÒÔǰË÷ÒýÖд洢µÄrowidÕ¼ÓÃ×Ö½ÚÊýÒ²ÊÇ6bytes,ÔÚoracle8Ö®ºó£¬ËäÈ»oracleʹÓÃÁËextend rowid£¬µ«ÊÇÔÚÆÕͨË÷ÒýÀïÃæÒÀÈ»´æ´¢ÁËbytesµÄrowid£¬Ö»ÓÐÔÚglobal indexÖд洢µÄÊÇ10bytesµÄextend rowid£¬¶øextend rowidÒ²ÊÇglobal index³öÏÖµÄÒ»¸ö±ØÒªÌõ¼þ£¬ÏÂÃæÎÒÃÇ»á½âÊÍÔÒò¡£
Ϊʲôgolbal indexÐèÒª°Ñdata_object_id#Ò²°üº¬ÔÚindex rowid entryÖÐÄØ£¿Èç¹û²»°üº¬»áÕâôÑù£¿Ê×ÏÈÎÒÃÇÐèÒªÖªµÀindexµÄrowid entryµÄ´æÔÚÊÇΪÁËÄܸù¾ÝËüÕÒµ½±íµÄÕâÌõ¼Ç¼´æÔÚÄĸö¾ßÌåµÄÎïÀíλÖã¬ÎÒÃÇÐèÒªÖªµÀËüÔÚÄĸöÊý¾ÝÎļþ£¬ÔÚÄĸöblock£¬ÔÚÄÇÒ»ÐУ¬ÆÕͨµÄË÷Òý oracle¸ù¾Ýrfile#,block#,row#¾Í¿ÉÒÔÖªµÀÁË£¬µ«ÊÇpartition table¿ÉÒÔ·Ö²¼ÔÚ¶à¸ö±í¿Õ¼ä£¬Ò²¾ÍÊÇ¿ÉÒÔ·Ö²¼ÔÚ¶à¸öÊý¾ÝÎļþ£¬µ±ÎÒÃǽ¨Á¢local indexʱ£¬index rowid entry²¢²»°üº¬data_object_id#£¬ÒòΪoracle¿ÉÒÔÖªµÀÕâ¸öindex¶ÔÓ¦µÄÊÇÄÄÒ»¸ötable·ÖÇø£¬²¢¿ÉÒԵõ½table·ÖÇøµÄ ts#(tablespaceºÅ)£¬ÄÇôoracle¸ù¾Ýts#ºÍrfile#¾Í¿ÉÒÔÕÒµ½¾ßÌåµÄÊý¾ÝÎļþ¡£µ«ÊÇÈç¹û»»³ÉÊÇgolbal index£¬Èç¹û²»°üº¬data_object_id#£¬ÄÇôÎÒÃDz¢²»ÄÜÖªµÀÕâ¸öË÷Òý¶ÔÓ¦×ÅÄĸö±í·ÖÇø£¬Ò²×ÔÈ»²»ÄÜÖªµÀËüµÄrfile#ºÍfile#µÄת »»¹ØÏµ£¬ËùÒÔËü½«ÕÒ²»µ½Ëù¶ÔÓ¦µÄ¼Ç¼¡£°üº¬data_object_id#ºó,oracle¿ÉÒÔ¸ù¾Ýdata_object_id#ʵÏÖrfile#ºÍ file#µÄת»»È»ºóÕÒµ½¼Ç¼¶ÔÓ¦µÄÎïÀíλÖá£ÐèҪעÒâµÄÊÇÒªÀí½âÒÔÉϸÅÄîÎÒÃÇ»¹ÊÇÐèÒªÁ˽âfile#ºÍrfile#µÄÇø±ð¡£
¶þ.±È½Ïfile#ºÍrfile#
oracleÊý¾ÝÎļþΪʲô´æÔÚfile#ºÍrfile#?
¹é¸ù½áµ×µÄÔÒòÊÇÒòΪ ROWID µÄ´æ´¢¸ñʽÔì³ÉµÄ£¬ÒòΪ rowid ÖÐÎļþ±àºÅ±êÖ¾Ö»ÓÐ10bit,×î´óÊý¾ÝÈÝÁ¿1024£¬ÓÉÓÚ²»´æÔÚ0±àºÅÎļþ£¬ËùÒÔʵ¼ÊÉÏÖ»ÔÊÐí1023¸öÎļþ±àºÅ¡£ÔÚoracle8 ֮ǰµÄ°æ±¾µÄÊý¾Ý¿âÖУ¬rowidÊÇÊÜÏ޵ģ¬Ö»°üÀ¨ file# /bl
Ïà¹ØÎĵµ£º
ϵͳ»¹Ô¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½ ......
ÎÒÏÈÅ×שÒýÓñ:
1. ¿ª·¢ÐÔ: SQLSERVER²»ÄÜ,ORACLEÄÜ×°ÔÚUNIXÉÏ
2. ·ÖÇø±í: SQLSERVER²»Ä ......
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
sysdate+5/24 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
sysdate+5 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
add_months(sysdate,-5) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
add_months(sysdate,-5*12) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
ÉÏÔÂÄ©µÄÈÕÆÚ£ºselect last_day(add_mon ......
×÷Õß:Ñî´óÓÑ,Óà´¨ ²âÊÔÔ±:Íõ½¡
¿ª·¢¹¤¾ß:Oracle Jdeveloper 10131
ÈíÓ²¼þ»·¾³:
²Ù×÷ϵͳlinux redhat 3.0 Êý¾Ý¿âΪOracle 10G 10.0.2
Ó¦Ó÷þÎñÆ÷ΪSOA Application Server 10131
¿ª·¢ÓïÑÔ:java
¹ØÓÚÌåϵ½á¹¹,˵¶àÁËÒ²ÈÃÈ˾õµÃÔÎ.ÎÒÖ±½ÓʾÀýÒ»¸ö×ö·¨,ÖÁÓÚÀí½â,¾ÍÂýÂý¿´Êé°É!
²½Öè:
1.
´´ ......
Ò»:oracle°æ±¾½éÉÜ:
oracle8
oracle8i ±íʾ´Ëʱoracle¹«Ë¾½ø¾ü»¥ÁªÍø,i´ú±íInternet
oracle9iºÍoracle8iÀàËÆ
oracle10g°üÀ¨ÏÖÔÚµÄ11gʹÓÃÁËÍø¸ñ¼ÆËã,g´ú±ígrid.
¶þ:oracle10g·þÎñ½éÉÜ:
OracleDBConsoleorcl Õâ¸öÊDzÉÓÃä¯ÀÀÆ÷ʹÓõÄoracleÆóÒµ¹ÜÀíÆ÷ (Ò²¾ÍÊÇÄã°²×°µ¯³öµÄÄǸöÍøÒ³)
OracleOraDb10g_home1iSQ ......