{"id":20899,"date":"2025-03-10T16:29:42","date_gmt":"2025-03-10T08:29:42","guid":{"rendered":"https:\/\/blog.pmail.idv.tw\/?p=20899"},"modified":"2025-03-10T16:29:57","modified_gmt":"2025-03-10T08:29:57","slug":"oracle-db-import-%e5%95%8f%e9%a1%8c%e8%99%95%e7%90%86%e7%b4%80%e9%8c%84","status":"publish","type":"post","link":"https:\/\/blog.pmail.idv.tw\/?p=20899","title":{"rendered":"oracle DB import \u554f\u984c\u8655\u7406\u7d00\u9304"},"content":{"rendered":"

\u56e0\u5728oracle db \u6e2c\u8a66\u6a5f\uff0cERP \u540c\u4ec1\u9700\u8981\u9084\u539f\u67d0\u4e00\u5929\u8cc7\u6599\u9032\u884c\u6e2c\u8a66<\/p>\n

\u5c07\u8cc7\u6599\u5eabDMP\u6a94\u6848\u4e0a\u50b3\u5f8c\u57f7\u884cimport \u4f5c\u696d\u64cd\u4f5c<\/p>\n

<\/p>\n

\u6703\u5361\u5728\u5982\u4e0b\u8a0a\u606f\u4e0d\u52d5<\/p>\n

processing object type schema_export\/table\/index\/index<\/p>\n

\u67e5\u8a62log<\/p>\n

\/u01\/app\/oracle\/diag\/rdbms\/db2\/db2\/alert\/log.xml<\/p>\n

\u767c\u73fe\u6709\u4e0b\u5217\u8a0a\u606f\uff0c\u8acb\u6559\u6bd4\u8f03\u719f\u6089oracle DB\u540c\u4ec1\u5f8c\uff0c\u53ef\u80fd\u662ftempfile \u6eff\u4e86\uff0c\u6240\u4ee5import \u8cc7\u6599\u5361\u4f4f<\/p>\n

<msg time='2025-03-08T23:36:55.267+08:00' org_id='oracle' comp_id='rdbms'\n type='UNKNOWN' level='16' host_id='db10.abc.com'\n host_addr='X.X.X.X' module='DBMS_SCHEDULER' pid='1941267'>\n <txt>ORA-1652: unable to extend temp segment by 128 in tablespace TEMP\n <\/txt>\n<\/msg><\/p><\/pre>\n
\u53e6\u5916<\/p>\n
\u4f7f\u7528sql\u6307\u4ee4<\/p>\n
SQL>SELECT TABLESPACE_NAME, TABLESPACE_SIZE\/1024\/1024 AS “TOTAL_MB”, 
        ALLOCATED_SPACE\/1024\/1024 AS “USED_MB”, 
        FREE_SPACE\/1024\/1024 AS “FREE_MB” 
\nFROM DBA_TEMP_FREE_SPACE;<\/p>\n
\u767c\u73feTEMP \u679c\u7136\u5df2\u7d93\u7206\u4e86<\/p>\n
\"TMP\"<\/a><\/p>\n
\u53e6\u5916\u518d\u67e5\u4e00\u4e0btemp\u662f\u5426\u6709\u8a2d\u5b9a\u81ea\u52d5extend \uff0c\u767c\u73fe\u6c92\u6709<\/p>\n
SQL> SELECT tablespace_name, file_name, bytes\/1024\/1024 AS size_MB,
        maxbytes\/1024\/1024 AS max_size_MB, autoextensible
\nFROM dba_temp_files;<\/p>\n
FROM dba_temp_files;
   2    3
\nTABLESPACE_NAME
\n——————————
\nFILE_NAME
\n——————————————————————————–
    SIZE_MB MAX_SIZE_MB AUT
\n———- ———– —
\nTEMP
\n\/u01\/app\/oracle\/oradata\/DB2\/temp01.dbf
        433           0 NO\n<\/p>\n
\u89e3\u6c7a\u65b9\u5f0f<\/p>\n
\u5148\u5c07temp.dbf \u653e\u5927\uff0c\u7136\u5f8c\u8a2d\u5b9a\u81ea\u52d5\u9577\u5927<\/p>\n
ALTER DATABASE TEMPFILE ‘\/u01\/app\/oracle\/oradata\/DB2\/temp01.dbf’ RESIZE 1024M;<\/font><\/p>\n
ALTER DATABASE TEMPFILE ‘\/u01\/app\/oracle\/oradata\/DB2\/temp01.dbf’ AUTOEXTEND ON NEXT 100M;<\/font><\/p>\n
\n