Oracle offers no parameter to specify a different tablespace to import data into. Objects will be re-created in the tablespace they were originally exported from. One can alter this behaviour by following one of these procedures:
Pre-create the table(s) in the correct tablespace: . Import the dump file using the INDEXFILE= option . Edit the indexfile. Remove remarks and specify the correct tablespaces. . Run this indexfile against your database, this will create the required tables in the appropriate tablespaces . Import the table(s) with the IGNORE=Y option.
Change the default tablespace for the user: . Revoke the "UNLIMITED TABLESPACE" privilege from the user . Revoke the user's quota from the tablespace from where the object was exported. This forces the import utility to create tables in the user's default tablespace. . Make the tablespace to which you want to import the default tablespace for the user . Import the table
answered Jan 25, 2010 at 09:05 AM
ALTER TABLE tablename MOVE TABLESPACE tablespace_name
answered Jan 22, 2010 at 06:30 PM