| Precreating tablespaces for Import [message #62676] |
Mon, 09 August 2004 02:07  |
Pratap Zope
Messages: 23
Registered: July 2004
|
Junior Member |
|
|
Hi,
while migrating database from one machine to another
I exported full database with rows=y,indexes=y,grants=y etc.
and then want to import the dump, thus created.
In this case do we need to create tablespaces as source database before importing?
since we have 'full database' export file will it not create all these tablespaces?
Please help.
Sincerely,
Pratap
|
|
|
|
| Re: Precreating tablespaces for Import [message #62682 is a reply to message #62676] |
Mon, 09 August 2004 04:40  |
Gorjan Todorovski
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
If you import with the FULL=Y option, the imp utility will try to create
the tablespaces from the source DB with the same datafiles (same
locations). If you already have the tablespaces it will import in those
tablespaces.
-----
www.oracleclinic.com
|
|
|
|
| Re: Precreating tablespaces for Import [message #62683 is a reply to message #62676] |
Mon, 09 August 2004 04:40 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Yes, Oracle will try to create the tablespaces if you import with FULL=YES. However, it is almost always better to create them manually, as it will give you more control over file sizing and placement.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
