Well, I do have the exp_full_database and imp_full_database roles.
But running the below script, would basically give me metadata for all
the objects in the DB.
I only need to get the DB_links and the constraints from the old
database.

expdp [Email address protected]
directory=ORA_2YR_BKP
CONTENT=METADATA_ONLY
DUMPFILE=EXPDAT_DB_LINKS_20070905.DMP
LOGFILE=EXPDAT_DB_LINKS_20070905.LOG


Thanx
vick

-----Original Message-----
From: David Chiu [mailto:[Email address protected]
Sent: Wednesday, September 05, 2007 11:13 AM
To: Sawant Mithun (GHB8DSR)
Subject: RE: Error when trying to EXPDP db_link




IN that case, make sure the user who do the export via data pump is the
user who create the db link. (Must have create database link privilege)
Try the expdp without he include statement.

expdp [Email address protected]
directory=ORA_2YR_BKP
CONTENT=METADATA_ONLY
DUMPFILE=EXPDAT_DB_LINKS_20070905.DMP
LOGFILE=EXPDAT_DB_LINKS_20070905.LOG

Give it a try..


------------------------------------------------------------------------
----
David Chiu

-----Original Message-----
From: [Email address protected] [mailto:[Email address protected]
Sent: Wednesday, September 05, 2007 11:04 AM
To: David Chiu
Subject: RE: Error when trying to EXPDP db_link

Hi David,

Sounds pretty good.
But, I do not have the passwords saved for the various db_links
on the old database.
To top it off, some of the db_links are HS, which is another
issue.


Thanx
vick

-----Original Message-----
From: David Chiu [mailto:[Email address protected]
Sent: Wednesday, September 05, 2007 11:01 AM
To: Sawant Mithun (GHB8DSR)
Subject: RE: Error when trying to EXPDP db_link


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret **from
this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text




It might be easier to just create the db link in the other instance.
First look at the detail of the db link in the old instance... Select *
from user_db_links Then use the information to recreate the link at the
new instance. create database link sid.domain connect to schemaowner
identified by pwd using 'sid';


------------------------------------------------------------------------
----
David Chiu


-----Original Message-----
From: msawant
[Email address protected]
Sent: Wednesday, September 05, 2007 10:26 AM
To: LazyDBA Discussion
Subject: Error when trying to EXPDP db_link

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 [Email address protected]
directory=ORA_2YR_BKP
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 [Email address protected]
directory=ORA_2YR_BKP
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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







Oracle LazyDBA home page