Oracle:²éÕÒ±íµÄÖ÷¼ü£¬Íâ¼ü£¬Î¨Ò»ÐÔÔ¼Êø£¬Ë÷Òý
1¡¢²éÕÒ±íµÄËùÓÐË÷Òý£¨°üÀ¨Ë÷ÒýÃû£¬ÀàÐÍ£¬¹¹³ÉÁУ©£º
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = Òª²éѯµÄ±í
2¡¢²éÕÒ±íµÄÖ÷¼ü£¨°üÀ¨Ãû³Æ£¬¹¹³ÉÁУ©£º
select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name = Òª²éѯµÄ±í
3¡¢²éÕÒ±íµÄΨһÐÔÔ¼Êø£¨°üÀ¨Ãû³Æ£¬¹¹³ÉÁУ©£º
select column_name from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'U' and au.table_name = Òª²éѯµÄ±í
4¡¢²éÕÒ±íµÄÍâ¼ü£¨°üÀ¨Ãû³Æ£¬ÒýÓñíµÄ±íÃûºÍ¶ÔÓ¦µÄ¼üÃû£¬ÏÂÃæÊǷֳɶಽ²éѯ£©£º
select * from user_constraints c where c.constraint_type = 'R' and c.table_name = Òª²éѯµÄ±í
²éѯÍâ¼üÔ¼ÊøµÄÁÐÃû£º
select * from user_cons_columns cl where cl.constraint_name = Íâ¼üÃû³Æ
²éѯÒýÓñíµÄ¼üµÄÁÐÃû£º
select * from user_cons_columns cl where cl.constraint_name = Íâ¼üÒýÓñíµÄ¼üÃû
5¡¢²éѯ±íµÄËùÓÐÁм°ÆäÊôÐÔ
select t.*,c.COMMENTS from user_tab_columns t,user_col_comments c where t.table_name = c.table_name and t.column_name = c.column_name and t.table_name = Òª²éѯµÄ±í
Ïà¹ØÎĵµ£º
ÒÔÏÂÊÇÔÚºǫ́¸üÐÂÒ×ÍØERPÊý¾Ý¿âʱÓöµ½µÄÒ»¸öÎÊÌâ:
1.ÔÚDB14Êý¾Ý¿âÖн«ÁϼþºÅP44¿ªÍ·,²¢ÇÒÆ·ÃûΪ"ËÜÁÏ´ü"µÄÁϼþ¸ÄΪÏûºÄÐÔÁϼþ.
Õâ¸ö¼òµ¥: UPDATE DB14.ima_file SET ima70 = ‘Y’ WHERE ima01 like ‘P44%’ AND ima0 ......
½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØʽéÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......
1. ¼ì²éOracleµÄ½ø³Ì
$ ps -ef|grep "ora_"|grep -v grep
oracle 5998 1 0 11:15:59 ? 0:01 ora_j000_PPRD10
oracle 2968 1  ......
ÒÔÏÂÁгöµÄÊÇOracle
Óû§¹ÜÀí¹ý³ÌÖг£ÓõÄһЩָÁÒÔ¹©´ó¼Ò²Î¿¼¡£
Oracle
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£
1.
SQL>Create
profile
ÎļþÃû limit
2.
  ......