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

oracleɾ³ý±íÊý¾Ýʱ ORA-00907: ȱÉÙÓÒÀ¨ºÅ

sqlÓï¾ä£ºdelete from test.tableA;
¾ÍÌáʾ£ºORA-00907: ȱÉÙÓÒÀ¨ºÅ
ÎÒ²»¶®£¬ÎÒÄÄд´íÁË£¿~~
select * from test.tableA;
ÊÇʲô½á¹û£¿
testÊÇÄãµÄschema?

°ÑÄãµÄsqlÓï¾äÑ¡ÖÐÖ´ÐÐ

+1
ÒýÓÃ
select * from test.tableA;
ÊÇʲô½á¹û£¿
testÊÇÄãµÄschema?


Ñ¡ÖÐÕâÌõÓï¾äÖ´ÐÐ..¿´»¹³ö²»³öÏÖ´íÎó

ÒýÓÃ
sqlÓï¾ä£ºdelete from test.tableA;
¾ÍÌáʾ£ºORA-00907: ȱÉÙÓÒÀ¨ºÅ

¿´²»³ö´íÎ󣡵ȴý´óϺÁË£¡

";"È¥ÁËÊÔÊÔ

ûÓÐ´í¡£¡£¡£

ÒýÓÃ
sqlÓï¾ä£ºdelete from test.tableA;
¾ÍÌáʾ£ºORA-00907: ȱÉÙÓÒÀ¨ºÅ
ÎÒ²»¶®£¬ÎÒÄÄд´íÁË£¿~~


µ¥Õâ¸öÓï¾äºÃÏñûÓÐÓï·¨´íÎó£¬
ÊDz»ÊÇÏà¹ØµÄÓï¾äÓÐ´í£¬±ÈÈçÕâ¸ö±íÉÏÃæÓÐûÓÐdeleteµÄtriggerѽ¡£Õâ¸ötriggerÀïÓÐÕâÑùµÄ´í¡£

deleteµÄtrigger£¿ºÃÏñûÓÐ
·ÖºÅÊÇÐèÒªµÄ...
select µÄʱºòÓÉÓÚÀïÃæÓÐblob×Ö¶ÎʲôµÄ£¬ËüÌáʾ˵ÓÐЩ×Ö¶ÎÎÞ·¨ÏÔʾ£¬Ò²¾ÍÊÇÕâÕűíÊÇ´æÔÚµÄ
¶øÇ񼆮æ¹ÖµÄÊÇ£¬ÎÒǰÁ½Ì컹Óõĺúõ쬽ñÌì¾Í³öÏÖÕâ¸öÎÊÌ⣬ʵÔÚÊÇûÕÞÁË

¶ÔÁË£¬Õâ¸öoracleÊÇoracle9i°æ±¾

ÒýÓÃ
¶ÔÁË£¬Õâ¸öoracleÊÇoracle9i°æ±¾


Ö»Äܹé½áÓÚ°æ±¾ÎÊÌâÁË¡£

ÒýÓÃ
ÒýÓà 10 Â¥ casilin µÄ»Ø¸´:
¶ÔÁË£¬Õâ¸öoracleÊÇoracle9i°æ±¾


Ö»Äܹé½áÓÚ°æ±¾ÎÊÌâÁË¡£


¿ÉÎÊÌâÊÇ£¬ÎÒǰÁ½ÌìÅÜ´úÂ붼û³öÏÖÕ


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ