OraFAQ Forum: Server Utilities » expdp with network

Home » RDBMS Server » Server Utilities » expdp with network_link (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

expdp with network_link [message #392014]

Mon, 16 March 2009 00:45

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

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: expdp with network_link [message #392026 is a reply to message #392022]

Mon, 16 March 2009 01:31

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

Report message to a moderator

Re: expdp with network_link [message #392126 is a reply to message #392014]

Mon, 16 March 2009 09:30

BlackSwan
Messages: 26766
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

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

Report message to a moderator

Previous Topic:	Exporting data from 11g using 10g XE client
Next Topic:	Statistics gathered during import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 09:52:48 CDT 2024