Home » RDBMS Server » Server Utilities » Import data using Oracle Data Pump (Oracle 10.2)
Import data using Oracle Data Pump [message #336696] Mon, 28 July 2008 13:31 Go to next message
masasam
Messages: 5
Registered: July 2008
Location: Pleasanton, CA
Junior Member
Hello experts,

Problem:
I wish to import an entire schema from a remote database (call it remote_db) into my local database (call it local_db). I have a fresh oracle install on local_db. Please provide the steps to accomplish this (leaving nothing out). Please provide all the steps required.

I wish to make a direct connection to remote_db using IMPDP (which I heard does not require a dump file).

Thanks in advance.

Masasam
Re: Import data using Oracle Data Pump [message #336698 is a reply to message #336696] Mon, 28 July 2008 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm#sthref321

are you incapable or unwilling to Read The Fine Manual in URL above?

[Updated on: Mon, 28 July 2008 13:41] by Moderator

Report message to a moderator

Re: Import data using Oracle Data Pump [message #336699 is a reply to message #336696] Mon, 28 July 2008 13:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All the steps without any omssion are there:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Regards
Michel
Re: Import data using Oracle Data Pump [message #336726 is a reply to message #336699] Mon, 28 July 2008 15:44 Go to previous messageGo to next message
masasam
Messages: 5
Registered: July 2008
Location: Pleasanton, CA
Junior Member
Michael,
Thanks for you response, but I have seen the oracle documentation and it doesn't scratch the surface.

Oracle documentation is good at explaining features but not actual implementation. Their examples are mainly generic.

I am moving data from a remote instance to a local instance. What I need to know is what specific elements must exist on the remote instance and local instance for the migration to be successful??

masasam
Re: Import data using Oracle Data Pump [message #336729 is a reply to message #336696] Mon, 28 July 2008 15:48 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
masasam,
Have you ever setup & used SQL*Net between 2 different DB servers?

[Updated on: Mon, 28 July 2008 15:52] by Moderator

Report message to a moderator

Re: Import data using Oracle Data Pump [message #336730 is a reply to message #336698] Mon, 28 July 2008 15:49 Go to previous messageGo to next message
masasam
Messages: 5
Registered: July 2008
Location: Pleasanton, CA
Junior Member
Thank you so much.

However, if you understand the problem and have done this in the past, wouldn't it be easier if you just show me how YOU did it???

Oracle documentation is feature rich but toolbox poor. I mean the examples are too generic, not specific enough.

masasam
Re: Import data using Oracle Data Pump [message #336731 is a reply to message #336729] Mon, 28 July 2008 15:50 Go to previous messageGo to next message
masasam
Messages: 5
Registered: July 2008
Location: Pleasanton, CA
Junior Member
No, I haven't. I am new to Oracle. This is my first time moving data.

masasam
Re: Import data using Oracle Data Pump [message #336733 is a reply to message #336696] Mon, 28 July 2008 15:54 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>wouldn't it be easier if you just show me how YOU did it???
Easier for you? yes. Easier for me? No.

I am not be paid enough to do your job for you.

You're On Your Own (YOYO)!
Re: Import data using Oracle Data Pump [message #336739 is a reply to message #336733] Mon, 28 July 2008 16:07 Go to previous messageGo to next message
masasam
Messages: 5
Registered: July 2008
Location: Pleasanton, CA
Junior Member
Anacedent,

The purpose of the forum is for people to post problems. If you DO NOT know the answer to a problem why bother to respond??

It would be better for you to keep quiet rather than take up processing time with you ignorance.

masasam

Re: Import data using Oracle Data Pump [message #336746 is a reply to message #336696] Mon, 28 July 2008 16:44 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You don't know, what you don't know.
Re: Import data using Oracle Data Pump [message #337202 is a reply to message #336696] Wed, 30 July 2008 02:38 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Possibly you are talking about import without dump file. Here is the procedure to help you,
http://arjudba.blogspot.com/2008/04/how-to-import-data-without-dumpfile.html
Previous Topic: Control Files in Oracle
Next Topic: Help with sql loader
Goto Forum:
  


Current Time: Sat Dec 03 01:10:26 CST 2016

Total time taken to generate the page: 0.08375 seconds