Home » RDBMS Server » Server Utilities » Importing a full export - creating tablespaces first? (10.2.0.4)
Importing a full export - creating tablespaces first? [message #349716] Mon, 22 September 2008 19:01 Go to next message
jfdba
Messages: 1
Registered: September 2008
Junior Member
I am planning to do a full export from a 9.2.0.7 database onto a new server with 10.2.0.4 installed. I have two questions:
1. Should I precreate the tablespaces in 10g?

2. Does Oracle export from the 9i system and sys tablespaces and import those into 10g? This doesn't make sense to me. Why would it do this, or is there a way for me to prevent that?
I prefer not to use the fromuser and touser on this database.

Thanks for your help.
Re: Importing a full export - creating tablespaces first? [message #349758 is a reply to message #349716] Tue, 23 September 2008 00:56 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
1. Should I precreate the tablespaces in 10g?

Yes or no, depending if you have the same directory structure, if you want to change tablespace parameters, and so on.

2. Oracle does never export SYS but it exports SYSTEM (alas).

Regards
Michel
Previous Topic: Running CATALOG.SQL and Catexp.sql
Next Topic: SQL LOADER
Goto Forum:
  


Current Time: Sat Dec 03 13:43:40 CST 2016

Total time taken to generate the page: 0.28392 seconds