Home » RDBMS Server » Server Utilities » export of one database and import into other database
export of one database and import into other database [message #225954] Thu, 22 March 2007 01:46 Go to next message
kamragulshan
Messages: 63
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
Re: export of one database and import into other database [message #225960 is a reply to message #225954] Thu, 22 March 2007 02:02 Go to previous messageGo to next message
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
Re: export of one database and import into other database [message #226029 is a reply to message #225960] Thu, 22 March 2007 06:16 Go to previous messageGo to next message
kamragulshan
Messages: 63
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
Re: export of one database and import into other database [message #226043 is a reply to message #226029] Thu, 22 March 2007 07:09 Go to previous messageGo to next message
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
Re: export of one database and import into other database [message #226062 is a reply to message #225954] Thu, 22 March 2007 07:48 Go to previous message
joy_division
Messages: 4640
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
Previous Topic: How can the SQL loader handle self referential tables?
Next Topic: IMP-00003 - ORA-06550 - PLS-00103
Goto Forum:
  


Current Time: Sun Dec 04 04:33:33 CST 2016

Total time taken to generate the page: 0.05844 seconds