| Export/Import [message #368301] |
Tue, 07 November 2000 02:03  |
Dhawal Shah
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
|
Please tell me that wether it is possible at the time of import to specify the tablespace to which the tables have to be imported.If so how?
|
|
|
|
| Re: Export/Import [message #368302 is a reply to message #368301] |
Tue, 07 November 2000 10:07  |
Adan Lopez
Messages: 2
Registered: November 2000
|
Junior Member |
|
|
Hi:
Objects imported will be created at their original location, that is, at the tablespace from the objects were exported. If you want to change this, you have two options:
A. Change the tablespace for the user.
1. Revoke quota to user from the tablespace where table will be imported, this force import utility to create the table in the default tablespace of the user.
2. put the tablespace where you want to import the table as the default tablespace for that user.
3. import the table.
B. Pre-create the table
1. Create the table with the same structure as the original table, but in the new tablespace.
2. Import the table with IGNORE=Y option.
I hope this help you.
Regards,
Adan.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
