OracleÊý¾Ý¿âÎÊÌâ
OracleÊý¾Ý¿âÎÊÌ⣺
ÎÒÓÐÒ»ÕűíÀïÃæÓÐ120ÍòÌõ¼Ç¼£¬ÒÑÎÞ·¨ÏòÀïÃæ²åÈëÊý¾ÝÁË£¬Ôõô°ì£¿
µ±Ç°Óû§ÏÂµÄÆäËû±íÊÇ¿ÉÒÔ²åÈëÊý¾ÝµÄ
ÎÊ£ºÊDz»ÊÇÿ¸öÊý¾Ý±íµÄ×î´ó´æ´¢ÊÇÓÐÒ»¶¨µÄÏÞÖÆµÄ£¿
Èç¹ûÓУ¬¿É²»¿ÉÒÔ½«ÆäÈÝÁ¿Ôö´ó£¿
oracle°ï¶¥....
Ó¦¸Ã¿ÉÒÔÉèÖᣡ£
120ÍòÌõ¼Ç¼ Ó¦¸Ã»¹µ½²»ÁËÉÏÏÞ¡£´íÎóÐÅÏ¢ÊÇʲô£¿
ÄãÒªÌṩ錯誤ÐÅÏ¢£¬ÎҵıíÒÑ經1000w條記錄£¬還¿ÉÒÔ繼續²åÈëµÄ¡£
¿´Ò»ÏÂÄãµÄÕâÕűíËùÊô±í¿Õ¼äÂúÁËûÓУ¬
×¢Òâ²é¿´Alert.log Îļþ£¬¿´ÀïÃæÌáʾʲô´íÎóÐÅÏ¢¡£
³öÏÖÈçÏ´íÎó£º
ORA-01653: ±íCASE38.SC_STU_SCORE_ALLÎÞ·¨Í¨¹ý18206£¨ÔÚ±í¿Õ¼äSYSTEMÖУ©À©Õ¹
ÄãµÄ±í¿Õ¼äÉèÖõÄÎÊÌ⣬¼ì²éÒ»ÏÂÄãÕâ¸ö±íËùÔڵıí¿Õ¼äµÄ¿ÕÓàÈÝÁ¿£¬
ûÊÔ¹ý£¬Ó¦¸ÃÊÇ¿ÉÒԵģ¡£¡
²é¿´ÄãµÄ±íËùÔÚ±í¿Õ¼äµÄÈÝÁ¿¿´ÊDz»ÊÇÂúÁË
¿´Ò»ÏÂÈÕÖ¾£¬ÔÙ¿´Ò»ÏÂÄãÎļþËùÔÚµÄÓ²ÅÌ
ÊÇϵͳ±í¿Õ¼ä²»×㣬Ҫ¼Ó´óSYSTEM±í¿Õ¼ä
µÈ´ý¸ßÊֵȴý¸ßÊÖÖеȴý¸ßÊֵȴý¸ßÊÖÖÐ
alter tablespace system add datafile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM02.DBF' size 100M reuse
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM02.DBF'
--F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL ·¾¶ ÊÇÄã×Ô¼º±¾»úoracleµÄ·¾¶
Ïà¹ØÎÊ´ð£º
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 ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......