Home » RDBMS Server » Server Utilities » Export/import full database query
Export/import full database query [message #185054] Sun, 30 July 2006 14:52 Go to next message
james_briar
Messages: 39
Registered: April 2005
Location: Morden (South London)
Member
Hi all, I have to move a small Oracle database from an old Windows NT server to a new Windows 2ooo one. The database is Oracle8i. I plan to do a full database export of the database thats on the old server, install Oracle8i on the new server, install the 8.1.7.4 patchset (and the latest security alerts) on the new server and create an exact copy of the database on the new server, then FTP the export file across to the new server. My question is do i need to create all the users on the new database before doing the full database import. I'm not sure if the import creates all the users? Also do i still need to run $ORACLE_HOME/rdbms/admin/catalog.sql and $ORACLE_HOME/rdbms/admin/catproc.sql on the new database before running the full import or does the full import create these catalog and catproc views?
Thanks.
Re: Export/import full database query [message #185055 is a reply to message #185054] Sun, 30 July 2006 15:05 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Quote:

I'm not sure if the import creates all the users?


Yes, it will.

Quote:

Also do i still need to run $ORACLE_HOME/rdbms/admin/catalog.sql and $ORACLE_HOME/rdbms/admin/catproc.sql on the new database


Yes, you do - SYS's objects are not exported.
Re: Export/import full database query [message #185062 is a reply to message #185055] Sun, 30 July 2006 16:53 Go to previous messageGo to next message
james_briar
Messages: 39
Registered: April 2005
Location: Morden (South London)
Member
Hello Frank. Thanks for your quick reply in answering my questions.
Re: Export/import full database query [message #354196 is a reply to message #185062] Thu, 16 October 2008 23:15 Go to previous messageGo to next message
sureshm.ora
Messages: 17
Registered: August 2008
Location: BANGLORE
Junior Member
hello hai

i want to do migration of oracle 10g R1 server from windows 2000- 2003 server by using exp and imp utilities can i do exp /imp by sytem user . is there any problems when importng into new database
as a system user , it may damage the existed sys schema objects?/
Re: Export/import full database query [message #354200 is a reply to message #354196] Thu, 16 October 2008 23:37 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See answer in your other topic:
http://www.orafaq.com/forum/m/354187/102589/#msg_354187

Regards
Michel
Previous Topic: External tables Fixed Format Data
Next Topic: import .dmp file using IMP utility for tablespaces
Goto Forum:
  


Current Time: Sat Dec 03 12:08:29 CST 2016

Total time taken to generate the page: 0.10654 seconds