Oracle ORA_ROWSCN
½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØʽéÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓмǼµÄORA_ROWSCN¶¼»á±ä»¯Îª×îÐÂÖµ£¬ORA_ROWSCNµÄ×îСÁ£¶ÈÊÇ¿é¡£
µ±ÎÒÃÇʹÓÃcreate table …… rowdependencies;½¨±íµÄʱºò£¬Ã¿Ìõ¼Ç¼»áÓÐ×Ô¼ºµÄORA_ROWSCN¶Î£¬ÔÚÕâÖÖÇé¿öÏ¿éÄÚµÄÒ»Ìõ¼Ç¼µÄ¸ü¸Ä½ö½ö»áÓ°Ïì¸Ã¼Ç¼µÄORA_ROWSCN£¬²»»á¶Ô¿éÄÚÆäËû¼Ç¼µÄORA_ROWSCN²úÉúÓ°Ïì¡£Õâ¸öʱºò£¬ORA_ROWSCNµÄ×îСÁ£¶ÈÊǼǼ¡£
Õâ¸ö¹¦ÄܱȽÏÊʺÏÄÇЩÐèÒª×öÔöÁ¿Ë¢ÐµIJÙ×÷£¬Í¨¹ýORA_ROWSCNÀ´Ñ¸ËÙµÄÕÒµ½ÄÇЩ·¢Éú±ä»¯µÄ¿é£¬ºöÂÔÄÇЩûÓз¢Éú±ä»¯µÄ¿é£¬Ìá¸ßÁËˢеÄЧÂÊ¡£
дµ½ÕâµÄʱºò£¬²»ÖªµÀ´ó¼ÒÓÐûÓÐÏëÁíÍâµÄÒ»¸öÎÊÌ⣬ÄǾÍÊÇORA_ROWSCNÊÇÔõôʵÏֵģ¬Ê¹ÓÃORA_ROWSCNÓÐʲôעÒâµÄÊÂÏîô£¿ÕâÊÇÎÒÃÇ´ó¼Ò¹²Í¬µÄÒ»¸öÎÊÌ⣬½ö½ö×¢Òâµ½Ò»¸ö¹¦ÄÜ»ý¼«µÄ²¿·Ö£¬ºÜÉÙÏëÕâ¸ö¹¦ÄÜÊÇ·ñÊʺÏÎÒ£¬Ê¹ÓÃÕâ¸ö¹¦ÄÜ»á¸øϵͳ´øÀ´Ê²Ã´Ñù×ӵķçÏÕ£¬¶øÍùÍù·çÏÕ²ÅÊÇÎÒÃÇÐèÒª¸ü¶à¿¼Âǵĵط½¡£ÔÚÊý¾Ý¿â·½ÃæÓÐÒ»¾ä»°»¹ÊDZȽÏʵÔڵģ¬“ÎÞ¹ý±ãÊǹ¦”¡£ÓëϵͳµÄÓÅ»¯Ïà±È£¬ÏµÍ³µÄÎȶ¨Ôò¸ü¼ÓÖØҪһЩ¡£
»¹Êǻص½ORA_ROWSCNÉÏÀ´°É¡£
µ±ÎÒÃÇûÓпªÆôrowdependenciesµÄʱºò£¬¿éÄÚµÄËùÓмǼµÄORA_ROWSCN¶¼ÊÇÒ»ÑùµÄ£¬¿ÉÒÔ²ÂÏëoracle»áÖ±½Ó¶ÁÈ¡block headÀ´»ñµÃORA_ROWSCN£¬ÒòΪÕâÑù×öµÄ»°Ð§ÂÊ»á¸ßһЩ£¬Ò²¸ü¼ÓµÄ·½±ãÖ±½Ó¡£ÊÂʵÉÏ£¬oracleÒ²ÊÇÕâÑù×öµÄ¡£ËùÒÔÔÚÕâÖÖÇé¿öÏ£¬¶ÔÓÚDML²Ù×÷À´Ëµ£¬²¢Ã»ÓÐÔö¼ÓÈκεĿªÏú£¬block headµÄscnÊǿ϶¨Òª¼Ç¼µÄ¡£Òò´Ë£¬ÔÚĬÈÏÇé¿öÏ£¬Ê¹ÓÃORA_ROWSCN²¢²»»á´øÀ´ÈκεÄÓ°ÏìµÄ¡£
Äǵ±ÎÒÃÇ¿ªÆôÁËrowdependenciesÄØ£¿Õâ¸öʱºò¿éÖеÄÿÌõ¼Ç¼¶¼»áÓÐ×Ô¼ºµÄORA_ROWSCNÁË£¬Äǿ϶¨ÊÇÔÚ¿éÖÐÍêÕûµÄ¼Ç¼ÏÂÿÌõ¼Ç¼µÄscnºÅ¡£ÕâÑù¾Í´øÁËÁ½¸öÐèÒª¿¼ÂǵÄÎÊÌ⣬¿Õ¼äÉÏ»á´æÔÚÀË·Ñ£¬Õⲿ·Ö¿Õ¼äÓÃÀ´¼Ç¼ÿÌõ¼Ç¼µÄscn¡£µ±¼Ç¼µÄ×ֶαȽ϶࣬¼Ç¼µÄ³¤¶È±È½Ï³¤µÄʱºò¿ÉÄÜÓ°ÏìµÄ°Ù·Ö±È»áСһЩ£¬¿ÉÊǶÔÓÚÄÇЩ×ֶαȽÏÉٵģ¬¼Ç¼µÄ³¤¶È±È½Ï¶ÌµÄ±íÓ°Ï콫»áÊǾ޴óµÄ£¬¿Õ¼äµÄÕ¼ÓÃÍêÈ«ÓпÉÄÜÔö´ó100%ÒÔÉÏ¡£¶Ôʱ¼äÉϵÄÀË·ÑÒ²ºÜºÃÀí½â£¬ÔÚ±íÉϵÄDML²Ù×÷»á¸üÐÂÒ»¸ö×ֶΣ¬Ê±¼äµÄÀË·ÑÒ²¾ÍÊDZØÈ»µÄÁË¡£
ÉÏÃæµÄ·ÖÎö½ö½öÊdzéÏóµÄ£¬»¹ÐèҪһЩ²âÊÔÊý¾Ýµ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
×÷Õß Haidong Ji ·Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñѹØϵÊý¾Ý¿âÄ£ÐÍÔÀí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)(SID_DESC =
&nb ......
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to&nb ......
http://hi.baidu.com/fyears/blog/item/5ef68ac3feb9a45db219a836.html
select object_id,session_id,locked_mode from v$locked_object;
¡¡¡¡select t2.username,t2.sid,t2.serial#,t2.logon_time
¡¡¡¡from v$locked_object t1,v$session t2
¡¡¡¡where t1.session_id=t2.sid order by t2.logon_time;
alter system ki ......