OraFAQ Forum: Server Utilities » export of one database and import into other database

Home » RDBMS Server » Server Utilities » export of one database and import into other database

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

export of one database and import into other database [message #225954]

Thu, 22 March 2007 01:46

kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi

Member

Hi..

Can anybody please tell me whether export of say "ABC" databse can be imported into "XYZ" database.

It is very urgent!!!!!Please let me know.

Thanks

Gulshan

Report message to a moderator

Re: export of one database and import into other database [message #225960 is a reply to message #225954]

Thu, 22 March 2007 02:02

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Can anybody please tell me whether export of say "ABC" databse can be imported into "XYZ" database.

Yes you can ... but you should give more detail what actually you want.

regards
Taj

Report message to a moderator

Re: export of one database and import into other database [message #226029 is a reply to message #225960]

Thu, 22 March 2007 06:16

kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi

Member

i have one user say "scott" in one database and i want same user with tables, data and other objects into another database. can i take user level backup from one tablespace and then import it into the another database.

Thanks

Gulshan

Report message to a moderator

Re: export of one database and import into other database [message #226043 is a reply to message #226029]

Thu, 22 March 2007 07:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Yes,you can...

1.database A

exp system/oracle FILE=c:\oracle.dmp OWNER=SCOTT

2. database B

imp system/oracle file=c:\oracle.dmp FROMUSER=SCOTT TOUSER=HR

regards
Taj

Report message to a moderator

Re: export of one database and import into other database [message #226062 is a reply to message #225954]

Thu, 22 March 2007 07:48

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You have already asked this question 3 months ago. Have you already forgotten?

http://www.orafaq.com/forum/m/211758/66800/#msg_211758

Report message to a moderator

Previous Topic:	How can the SQL loader handle self referential tables?
Next Topic:	IMP-00003 - ORA-06550 - PLS-00103

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:15:01 CST 2024