Home » RDBMS Server » Server Utilities » expdp with network_link (10g)
expdp with network_link [message #392014] Mon, 16 March 2009 00:45 Go to next message
ora_baby
Messages: 89
Registered: May 2008
Member
hi

i want make dump on my machine from another.
i have ORCL(local) and DB1(on another machine)

order:
1. sqlplus my/my@orcl
2. create database link db1.net using 'db1';
3. select count(*) from user_tables@db1.net
COUNT(*)
--------
6
4. expdp my/my@orcl directory=dtpump schemas=myuser dumpfile=dump_from_db1.dmp LOGFILE=dump_from_db1.log network_link=db1.net
But the export is interrupted and i haven't the dump and log

whats wrong?


usefull http://arjudba.blogspot.com/2009/02/how-to-take-data-pump-export-on-another.html

[Updated on: Mon, 16 March 2009 01:06]

Report message to a moderator

Re: expdp with network_link [message #392022 is a reply to message #392014] Mon, 16 March 2009 01:24 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
But the export is interrupted and i haven't the dump and log

It would help if you had copied your screen output; now we can only guess what you've done.

Where did you run the following statement:
Quote:
4. expdp my/my@orcl ...

Was it at the SQL*Plus prompt? If so, you'll need to prefix it with a dollar ($) sign (at least, if on MS Windows or OpenVMS operating system - just as the article shows), or the HOST command (at the SQL*Plus prompt), or exit SQL*Plus and run EXPDP utility at the operating system command prompt.
Re: expdp with network_link [message #392026 is a reply to message #392022] Mon, 16 March 2009 01:31 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
i started up
C:\oracle\db_1\BIN\expdp.exe my/my@orcl directory=dtpump schemas=myuser dumpfile=dump_from_db1.dmp LOGFILE=dump_from_db1.log network_link=db1.net
Re: expdp with network_link [message #392126 is a reply to message #392014] Mon, 16 March 2009 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
It is not clear, at least to this reader, who is doing what to whom & where.
Which schema in which database/instance do you want to export?

>i want make dump on my machine from another.
Why "from another" & what do you mean by this statement?

>i have ORCL(local) and DB1(on another machine)
If/when you are logged directly onto the system containing ORCL,
then no need for SQL*Net access to operate against ORCL.


>C:\oracle\db_1\BIN\expdp.exe my/my@orcl directory=dtpump schemas=myuser
Does schema "my" have necessary privs to operate against "myuser"?

>network_link=db1.net
Exactly what you do hope/intend/desire for this parameter to do?

[Updated on: Mon, 16 March 2009 09:31]

Report message to a moderator

Re: expdp with network_link [message #392234 is a reply to message #392126] Tue, 17 March 2009 02:11 Go to previous message
ora_baby
Messages: 89
Registered: May 2008
Member
to BlackSwan, please read http://arjudba.blogspot.com/2009/02/how-to-take-data-pump-export-on-another.html

i solved this problem.
if it's interesting i will talk about this problem
Previous Topic: Exporting data from 11g using 10g XE client
Next Topic: Statistics gathered during import
Goto Forum:
  


Current Time: Fri Dec 02 16:57:53 CST 2016

Total time taken to generate the page: 0.28962 seconds