Hi,
I am trying to expdp db_links from one db to another. For
readability, I have wrapped my script in this email.

Below is my expdp script, which gives the error:
expdp username/[Email Address Removed]
CONTENT=METADATA_ONLY
DUMPFILE=EXPDAT_DB_LINKS_20070905.DMP
LOGFILE=EXPDAT_DB_LINKS_20070905.LOG
INCLUDE=DB_LINK

ORA-31655: no data or metadata objects selected for job




Then I tried:
expdp username/[Email Address Removed]
CONTENT=METADATA_ONLY
DUMPFILE=EXPDAT_DB_LINKS_20070905.DMP
LOGFILE=EXPDAT_DB_LINKS_20070905.LOG
schemas=csrt
INCLUDE=DB_LINK:"IN (select db_link from all_db_links where db_link <>
'CAM3PROD.CORP.UPS.COM' order by db_link)"


which gives the error:
ORA-39071: Value for NAME_EXPR filter is badly formed.
ORA-00921: unexpected end of SQL command



What am I doing wrong?


Thanks,
vick

Oracle LazyDBA home page