| Importing a full export - creating tablespaces first? [message #349716] |
Mon, 22 September 2008 19:01  |
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  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
