Home » RDBMS Server » Server Utilities » how to move an entire schema
how to move an entire schema [message #69834] Tue, 12 March 2002 22:21 Go to next message
MarcoC
Messages: 10
Registered: February 2002
Junior Member
hi,

how can I export an entire schema from Oracle7.3 to Oracle 8i? Thanks

Marco
Re: how to move an entire schema [message #69846 is a reply to message #69834] Wed, 13 March 2002 08:29 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Export (using ver 7) from the version 7 database move the dump in binary mode and import (using ver 8i) to 8i. It is upward compatible.

See article "Compatibility Matrix for Export & Import Between Different Oracle Versions" in MetaLink.
Re: how to move an entire schema [message #69871 is a reply to message #69834] Fri, 15 March 2002 00:09 Go to previous messageGo to next message
MarcoC
Messages: 10
Registered: February 2002
Junior Member
how do you exactely move the dump in binary mode and how do you import? Can you elaborate more on this?
If it's possible I'd like to do this with sqlplus.
Thanks Marco
Re: how to move an entire schema [message #69876 is a reply to message #69834] Fri, 15 March 2002 06:26 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Make sure your environment variables are set. Open a DOS window if you are using windows or open a terminal session if using unix.

On the Oracle7 database enter:

exp73 system/manager file=ora7.dmp log=exp.log full=y buffer=64000

Move the file to the Oracle8 server via ftp in binary mode. If the databases are on the same server you will not need to move it.

On the Oracle8 database enter:

imp system/manager file=ora7.dmp log=imp.log full=y buffer=64000 ignore=y commit=y

You may want to do a full export on the Oracle8 database before you do the Oracle7 import so you can restore in case you are not happy with the results.

For more information read the backup and recovery documentation from Oracle.
Previous Topic: Import/Export with UTF8
Next Topic: import
Goto Forum:
  


Current Time: Thu Mar 28 21:03:37 CDT 2024