Home » RDBMS Server » Server Utilities » Export/Import
Export/Import [message #368301] Tue, 07 November 2000 02:03 Go to next message
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 Go to previous message
Adan Lopez
Messages: 2
Registered: November 2000
Junior Member

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.


Previous Topic: Date format
Next Topic: sqlldr error message
Goto Forum:

Current Time: Tue Jun 06 23:54:29 CDT 2023