Home » RDBMS Server » Server Utilities » To Export schema from one DB to Another DB at different Location
To Export schema from one DB to Another DB at different Location [message #154309] Fri, 06 January 2006 12:55 Go to next message
saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad
Junior Member


Hi,

I am very much new to Oracle. I have created 2 same version(8i) of DB in two different machines. Both are having same OS winXP. But the difference is RAM one has 2 GB RAM and the Other has 512 MB RAM.
I want to export the complete schema(its got lots of Data arount2 to 3 millions records) from system where it has 2 GB RAM and then import the same schema into another system where it has 512 MB RAM.
How can i do this, can some one please help me in explaining in details.

Thanks,
Saritha.
Re: To Export schema from one DB to Another DB at different Location [message #154311 is a reply to message #154309] Fri, 06 January 2006 13:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Start here
http://www.orafaq.com/faq/import_export
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm
and search the the board.
Re: To Export schema from one DB to Another DB at different Location [message #154373 is a reply to message #154309] Sat, 07 January 2006 10:45 Go to previous message
saritha_says
Messages: 12
Registered: October 2005
Location: Hydrabad
Junior Member

Thanks a lot Mahesh ..
Previous Topic: Difference between exp and expdp
Next Topic: Difference between exp and expdp
Goto Forum:
  


Current Time: Tue Jul 02 03:58:26 CDT 2024