ORACLEʹÓÃEXCEPTIONS±í²éѯ³ö±íÖÐÖØ¸´¼Ç¼
SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
2 status,deferrable,deferred,validated
3 from dba_constraints
4 where owner='SCOTT' and table_name='T1';
CONSTRAINT_NAME TABLE_NAME C STATUS
------------------------------ ------------------------------ - --------
DEFERRABLE DEFERRED VALIDATED
-------------- --------- -------------
SYS_C0023319 T1 P ENABLED
NOT DEFERRABLE IMMEDIATE VALIDATED
SQL> insert into scott.t1 values(1,'tt');
1 row created.
SQL> insert into scott.t1 values(1,'hh'); --²åÈëidÁÐÖØ¸´µÄ¼Ç¼ʧ°Ü
insert into scott.t1 values(1,'hh')
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.SYS_C0023319) violated
SQL> alter table scott.t1 disable novalidate constraint SYS_C0023319; --ÐÞ¸ÄÔ¼Êø×´Ì¬
Table altered.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
2 status,deferrable,deferred,validated
3 from dba_constraints
4 where owner='SCOTT' and table_name='T1';
CONSTRAINT_NAME TABLE_NAME C STATUS
--------
Ïà¹ØÎĵµ£º
ÎÒÏÈÅ×שÒýÓñ:
1. ¿ª·¢ÐÔ: SQLSERVER²»ÄÜ,ORACLEÄÜ×°ÔÚUNIXÉÏ
2. ·ÖÇø±í: SQLSERVER²»Ä ......
1¡¢ÓÃpl/sql developerÖ»µ¼³ö±í½á¹¹£¬²»µ¼³öÊý¾ÝµÄsqlÎļþ
´ð£º TOOLS-> Export Tables È»ºóÑ¡ÔñÖмäµÄ sqlInserts
ËüÓÐÒ»¸ö where clause ¿ÉÒÔÉèÖõÄ, ¿´µ½Ã»ÓÐ. ÌîÈë rownum < 0 ¾ÍOKÁË.
»ò ......
Ëæ×Ų»Í¬Ó¦ÓÃÄ£¿é¼äµÄÏûÏ¢½»»¥ºÍͨÐųÉΪһ¸ö¹Ø¼üµÄ¹¦ÄÜ£¬²¢ÇÒ±äµÃÔ½À´Ô½ÖØÒª¡£OracleÒýÈëÁËÒ»ÖÖÇ¿´óµÄ¶ÓÁлúÖÆ£¬Í¨¹ýËü³ÌÐò¼ä¿ÉÒÔʵÏÖÐÅÏ¢µÄ½»»¥£¬oracle°ÑËü³Æ×÷ΪAQ - Advanced Queuing. ʹÓÃOracle AQ£¬ÎÒÃDz»ÐèÒª°²×°¶îÍâµÄÖмä¼þ£¬ËüÊÇOracleÊý¾Ý¿âµÄÒ»¸ö¹¦ÄÜ×é¼þ£¬Ö»ÒªÄã°²×°ÁËOracle Êý¾Ý¿â¾Í¿ÉÒÔʹÓÃAQÁË¡£½ ......
ÔÚÎÒÃÇÏêϸ½éÉÜ֮ǰ£¬ÎÒÃDZØÐë˵Çå³þÒ»µã£ºOracle²»ÌṩÈçɾ³ý±í¡¢ÊÓͼһÑùɾ³ýÊý¾ÝÎļþµÄ·½·¨£¬Êý¾ÝÎļþÊDZí¿Õ¼äµÄÒ»²¿·Ö£¬ËùÒÔ²»ÄÜ“ÒÆ×ß”±í¿Õ¼ä¡£
Ò»¡¢Ê¹ÓÃofflineÊý¾ÝÎļþµÄ·½·¨
·Ç¹éµµÄ£Ê½Ê¹Óãºalter database datafile '...' offline drop;
¹éµµÄ£Ê½Ê¹Ó㺠alter database datafile '.. ......
Ò»¡¢Ê¹ÓÃsrvctl¹ÜÀíRACÊý¾Ý¿â
[root@NODE01 bin]# pwd
/orac/crs/bin # srvctlÔÚ$CRS_HOME/binĿ¼Ï£¬Ëü¿ÉÒÔÔÚÈκνڵãÉÏά»¤¡£
[root@NODE01 bin]# ./srvctl
Usage: srvctl <command> <object> [<options>]
command: enable|disable|start|stop|relocate|status| ......