Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to ignore/hide IMP-00017 for database link?

How to ignore/hide IMP-00017 for database link?

From: J.A. Cooper <julius.cooper_at_gmail.com>
Date: 4 Jan 2006 09:56:39 -0800
Message-ID: <1136397398.986656.221300@z14g2000cwz.googlegroups.com>


Hello all,

I am running Oracle 9.2.0.5 Personal Edition on Windows2000 (client), and following the steps for "Adding New Master Sites Without Quiescing the Master Group," (Chapter 7, Replication Management Guide) which include the following EXP command:

EXP system/manager_at_SiteA
FILE=c:\admin_schema.dmp
OWNER=admin
DIRECT=n
GRANTS=y
ROWS=y
COMPRESS=y
INDEXES=y
CONSTRAINTS=y
STATISTICS=compute
FLASHBACK_SCN=someNum

The IMP command looks like this:
IMP system/manager_at_SiteB
FILE=c:\admin_schema.dmp
FROMUSER=ADMIN
BUFFER=30720
IGNORE=Y
DESTROY=y
COMMIT=y

So, when I run this, I get ALL of ADMIN'S objects, including its database links. On SITE A, I obviously need to have a db_link to SITE B, which does not need a connection qualifier. However, when that link is imported, I get an IMP-00017, stating that I need a connection qualifier for a loopback connection. IMP returns "Import completed successfully with warnings." My manager is saying that he doesn't want to see the warnings, or doesn't want them to occur--basically, he wants the end user to OK this IMP only if they see the message "Import completed successfully without warnings."

Is it possible to selectively tell EXP/IMP not to get the dblink for SITE B? Or do I have to basically do an IMP SHOW=Y and remove the line for creating that DBLINK (and how do I do that behind the scenes, again?!), then run IMP "normally"?

Thanks in advance,

Julius Received on Wed Jan 04 2006 - 11:56:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US