Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to use a full export to move a database

Status
Not open for further replies.

bookouri

IS-IT--Management
Feb 23, 2000
1,464
US
I have a 9i database on a Win2000 server. I want to move that database to a new 10g database on a Win2003 Server. The database is not that large but there are a large number of public synonyms, roles and grants that would have to be recreated if i do a schema export and import. What really happens when you do a FULL database import? Would a FULL import risk causing problems with my new database? or does the FULL database simply skip objects when it encounters existing objects, etc?

thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top