| Export/import full database query [message #185054] |
Sun, 30 July 2006 14:52  |
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  |
Frank Naude
Messages: 4587
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 #354196 is a reply to message #185062] |
Thu, 16 October 2008 23:15 |
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?/
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
