Home » RDBMS Server » Server Utilities » datapump imp full with network_link (w2k8 oracle 11G r2)
datapump imp full with network_link [message #521017] Thu, 25 August 2011 16:01 Go to next message
alcalina
Messages: 3
Registered: August 2011
Junior Member
Hi.

I want do this
connected in windows 2008 r2 with oracle 11G R2
execute an import, that will do a full import, from a linux with oracle 10g called "SUPORTE1"

I´m trying this in the windows2008 machine
impdp system/manager@w2k811r2 full=y DIRECTORY=dpump NETWORK_LINK=SUPORTE1;
and I get the follow errors

ORA-39001: valor de argumento invßlido ( argument valor invalid)
ORA-39200: O nome do link "SUPORTE1;" Ú invßlido. ( link name invliad)
ORA-44004: nome SQL qualificado invßlido ( sql name invalid)

I tested the connection, db-link and created the directory.

I hope is a silly mistake mine.
tks for the help

Re: datapump imp full with network_link [message #521018 is a reply to message #521017] Thu, 25 August 2011 16:40 Go to previous messageGo to next message
ThomasG
Messages: 3113
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Is there really a semicolon ( ; ) at the end of the TNS Name?
Re: datapump imp full with network_link [message #521050 is a reply to message #521017] Fri, 26 August 2011 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 59754
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From NETWORK_LINK documentation:

Quote:
The source_database_link provided must be the name of a valid link to a source database. If the database does not already have a database link, you or your DBA must create one. For more information about the CREATE DATABASE LINK statement, see Oracle Database SQL Reference.


Regards
Michel
Re: datapump imp full with network_link [message #521119 is a reply to message #521050] Fri, 26 August 2011 08:14 Go to previous message
alcalina
Messages: 3
Registered: August 2011
Junior Member
tks ThomasG
I was putting ; shame on me
tks again.
Previous Topic: SQL Loader Number Format
Next Topic: query to check data pump
Goto Forum:
  


Current Time: Mon Nov 24 06:31:30 CST 2014

Total time taken to generate the page: 0.09030 seconds