by 수달 [2022.10.04 12:36:49]
안녕하세요.
Data Pump 공부 중 Error가 생겨 질문 올립니다.
SQL> select * from dba_db_links order by owner, db_link;
OWNER DB_LINK USERNAME HOST CREATED HID SHA VAL INT
---------- ---------- ---------- ---------- ---------- --- --- --- ---
SYS RHEL19C DUMPUSER oralink 30-SEP-22 NO NO YES NO
SYS SYS_HUB HWEE 19-AUG-22 NO NO YES NO
expdp system/ directory=DUMP dumpfile=test5_exp.dmp logfile=test5_exp.log full=y include=DB_LINK,PUBLIC_SYNONYM
Export: Release 19.0.0.0.0 - Production on Tue Oct 4 11:27:06 2022
Version 19.14.1.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** directory=DUMP dumpfile=test5_exp.dmp logfile=test5_exp.log full=y include=DB_LINK,PUBLIC_SYNONYM
ORA-31655: no data or metadata objects selected for job
Job "SYSTEM"."SYS_EXPORT_FULL_01" completed with 1 error(s) at Tue Oct 4 11:27:10 2022 elapsed 0 00:00:03
다음과 같이 DB_link가 분명 존재하는데, ORA Error 가 발생하는 이유가 무엇일까요?
명령어를 조금 변경해서
- version=12.2 를 넣어 보거나,,,
- content=metadata_only 추가하고 include=DB_LINK,PUBLIC_SYNONYM 를 제외하고 수행해 database_link 가 추출 되는지 보거나
범위를 좀 좁혀봐야 할 것 같습니다.