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

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
--------


Ïà¹ØÎĵµ£º

OracleѹËõ±í±í¿Õ¼ä

´ÓOracle 9iR2 ¿ªÊ¼,ORACLEÌṩÁ˱í/±í¿Õ¼äѹËõ¼¼Êõ,ÒÔ¼õÉÙ´ÅÅÌ¿ªÏú,½ÚÊ¡¿Õ¼ä,²¢ÔÚijЩÇé¿öÏÂÌá¸ß²éѯÐÔÄÜ¡£
 
±íѹËõÊÇÈçºÎ¹¤×÷µÄ
ÔÚOrcle9iµÚ2°æÖУ¬±íѹËõÌØÐÔͨ¹ýɾ³ýÔÚÊý¾Ý¿â±íÖз¢ÏÖµÄÖØ¸´Êý¾ÝÖµÀ´½ÚÊ¡¿Õ¼ä¡£Ñ¹ËõÊÇÔÚÊý¾Ý¿âµÄÊý¾Ý¿é¼¶±ðÉϽøÐеġ£µ±È·¶¨Ò»¸ö±íÒª±»Ñ¹Ëõºó£¬Êý¾Ý¿â±ãÔÚÿһ¸öÊý¾Ý¿âÊý¾Ý¿éÖб£ ......

OracleÈ«ÎÄË÷ÒýÉèÖò½Öè

ÒÑÓм¸¸öÏîÄ¿×鿪ʼʹÓÃoracleµÄÈ«ÎÄË÷Òý¡£OracleµÄ´Ê·¨·ÖÎöÆ÷Õë¶ÔZHS16GBK×Ö·û¼¯µÄ´Ê·¨·ÖÎöÉв»¹»ÖÇÄÜ£¬Ö»ÄÜ»úеµØÒÔ×ÖΪµ¥Ôª
½øÐÐÆ¥Åä¡£¶ÔÓÚutf8×Ö·û¼¯µÄÊý¾Ý¿âÓÐÒ»¸öеĺºÓï·ÖÎöÆ÷chinese_lexer£¬Ð§ÂÊÓÐÁ˺ܴó¸ÄÉÆ¡£ÏÖ½«ÑéÖ¤²¢ÕûÀí¹ýµÄÈçºÎ½øÐÐoracleÈ«ÎÄ
Ë÷ÒýÉèÖõÄÎĵµ·¢¸ø´ó¼Ò£¬ÊÊÓÃÓÚ8i¡¢9i¸÷ƽ̨°æ±¾¡£
¡¡¡¡¶ÔÓ ......

ORACLEÈ«±¸·ÝºÍ0¼¶ÔöÁ¿±¸·ÝµÄÇø±ð

±È½Ï¹Ù·½µÄ˵·¨
Full
A backup of a datafile that includes every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data block is backed up. It can also be stored in a backup set, in which case datafile blocks not in use may be skipped, ......

½ñÌì×°ORACLE µÄµãµãµÎµÎ£¡

ËäÈ»ÒÔǰÓÃÁ˼¸ÄêµÄORACLE µÄpl/sql  µ«°²×°½ñÌ컹ÊǵÚÒ»´Î£º
1£º »¹ÊÇÏȲο¼Ò»ÏÂÍøÕ¾£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
  1. Oracle 10g windows ƽ̨ϰ²×°
¡¡¡¡ÏÂÔØµØÖ·£º  http://download.csdn.net/source/1850497¡¡¡¡
¡¡¡¡ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com ......

ORACLE directory Ŀ¼

Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';
±¾°¸Àý¾ßÌå´´½¨ÈçÏÂ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬¾ßÌåÓï·¨ÈçÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ