oracle µ¼Èëºó ÔÚÄIJ鿴 - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒ´ÓÁíÍâһ̨»ú×ÓÉϵÄoracleÉϵ¼³öÁËÒ»¸öÓû§A£¬µÃµ½A.DMP£¬µ¼³öÊdzɹ¦µÄ¡£ È»ºó£¬ÔÚÎҵĻú×ÓÉϵ¼ÈëÁËoracleÖУ¬ÎÒÔÚÓû§BϽøÐеÄIMPµ¼È룬ÏÔʾ³É¹¦ÖÕÖ¹µ¼È룬ûÓгöÏÖ¾¯¸æ£¬¿ÉÎҵǼµ½BÒÔºó£¬È´Ã»Óз¢ÏÖÓÐÈκε¼ÈëµÄ¶«Î÷£¬ÓÃPL/SQLÒ²¿´²»¼û¡£Çë¸÷λ°ïæָ½Ìһϣ¬Èç¹û²é¿´µ¼ÈëµÄÓû§¡£¼±£¡
exp/imp Óï¾äÔõôдµÄ£¿¡¡Ìù³öÀ´¿´¿´..
ÄãÊDz»Êǵ¼ÈëÁ˱ðµÄÓû§ÖÐÈ¥ÁË
лл¥ÉϵÄÌáÐÑ£¬ÎÒ¸Õ²ÅÊÇ°´×ÅimpµÄÌáʾÃüÁî½øÐеĵ¼È룬½á¹ûÒ²²»ÖªµÀµ¼Èëµ½ÄÄÁË£¬ÏÖÔÚ°´×ÅÄã˵µÄÎÒµ¼Èë½øÈ¥ÁË¡£ÔÙ´Îлл£¡
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB
Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí
ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......