DB version: 19c
OS : RHEL 7.9
Using expdp, I want to export only DB Links in my PDB. But, I want to skip a DB Link named SYS_HUB owned by SYS user.
When I try the below par file, I get the below error which basically says I cannot user INCLUDE and EXCLUDE parameters together.
Any workaround for this ?
$ cat expdp_test.par
directory=DB_DIR2
exclude=db_link:"IN('SYS.SYS_HUB')"
include=DB_LINK
full=yes
dumpfile=dblinks-PDB_SALES.dmp
logfile=export_dblinks.log
$ expdp "'/ as sysdba'" parfile=expdp_test.par
Export: Release 19.0.0.0.0 - Production on Mon Jan 9 12:40:52 2023
Version 19.11.0.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
UDE-00011: parameter include is incompatible with parameter exclude
$