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µÄ´óС°¡£¿£¿£¿£¿ ÎÊÌâ½â¾öÁË£¬ÖØÆôÊý¾Ý¿â¾ÍûÊÂÁË£¡
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
abnormal end of export file IMP-00028: partial import of previous table rolled back: 3828 rows rolled back ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿ ignore=y Äã² ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º 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²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......
table1: uID uName 1 СÀî 2 СÕÅ table2: pID uID type 1 1 H1 2   ......