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

oracle 600´íÎ󣬼±£¬¼±£¬¼±£¡

¼´½«µ¼³öÖ¸¶¨µÄÓû§...
. ÕýÔÚµ¼³ö pre-schema ¹ý³Ì¶ÔÏóºÍ²Ù×÷
. ÕýÔÚµ¼³öÓû§ CTMSOWNER µÄÍⲿº¯Êý¿âÃû
. ÕýÔÚµ¼³öÓû§ SMASOWNER µÄÍⲿº¯Êý¿âÃû
. µ¼³ö PUBLIC ÀàÐÍͬÒå´Ê
. ÕýÔÚµ¼³öרÓÃÀàÐÍͬÒå´Ê
. µ¼³ö PUBLIC ÀàÐÍͬÒå´Ê
. ÕýÔÚµ¼³öרÓÃÀàÐÍͬÒå´Ê
. ÕýÔÚµ¼³öÓû§ CTMSOWNER µÄ¶ÔÏóÀàÐͶ¨Òå
. ÕýÔÚµ¼³öÓû§ SMASOWNER µÄ¶ÔÏóÀàÐͶ¨Òå
¼´½«µ¼³ö CTMSOWNER µÄ¶ÔÏó...
. ÕýÔÚµ¼³öÊý¾Ý¿âÁ´½Ó
. ÕýÔÚµ¼³öÐòºÅ
. ÕýÔÚµ¼³ö´Ø¶¨Òå
EXP-00056: Óöµ½ ORACLE ´íÎó 600
ORA-00600: ÄÚ²¿´íÎó´úÂë, ²ÎÊý: [qmxtrScalarIsRewritable:dft], [], [], [], [], [], [], []
EXP-00000: µ¼³öÖÕֹʧ°Ü


ÒýÓÃ
²Î¿¼Ò»Ï£º

http://space.itpub.net/235507/viewspace-611946


¾­³£»áÌáʾ½ø³¡ÄÚ´æ²»×ã°¡£¬Õâ¸öÎÊÌâÔõô½â¾ö°¡£¿
µ½µ×ÒªÔõô·ÖÅäSGAµÄ´óС°¡£¿£¿£¿£¿


ÎÊÌâ½â¾öÁË£¬ÖØÆôÊý¾Ý¿â¾ÍûÊÂÁË£¡


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

ÀÏÎÊÌ⣺OracleÐÐתÁУ¨×Ö·û´®²ð·Ö£©

ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......

ÇóÒ»Ìõoracle¶à±í²éѯµÄsql£¬Çó¸ßÊÖÃDz»ÁߴͽÌ~

table1:
uID    uName
1      СÀî 
2      СÕÅ

table2:
pID  uID  type
1    1    H1
2    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ