![Oracle資料庫匯出錯誤](https://rvso.com/image/782628/Oracle%E8%B3%87%E6%96%99%E5%BA%AB%E5%8C%AF%E5%87%BA%E9%8C%AF%E8%AA%A4.png)
我正在嘗試匯出 Oracle 資料庫,但出現錯誤。該錯誤與這個問題類似Oracle 資料庫架構匯出,但是如果我執行查詢SELECT o.status, o.object_id, o.object_type, o.owner||'.'||object_name "OWNER.OBJECT" FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;
我會得到no rows selected
expdp oracle/oracle123@oracle-db-1:1521/oracle dumpfile=oracle_dump_121522.dmp exclude=STATISTICS DIRECTORY=dumps compression=all logfile=oracle_dump_121522.log PARALLEL=4
我收到錯誤
Export: Release 12.2.0.1.0 - Production on Thu Dec 15 18:18:32 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "oracle.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1161
ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'
ORA-06512: at "SYS.KUPV$FT", line 1054
ORA-06512: at "SYS.KUPV$FT", line 1042