Re: How do you change a table's tablespace through Import.

You can do this one of two ways.

1. if all of the schema's tables will move to another tablespace, then do the following:
2. create the schema ii) assign the schema to a default tablespace where you want the tables to be reside. iii) revoke UNLIMITED TABLESPACE from the schema iv) alter the schema to have QUOTA UNLIMITED on the default tablespace
3. import the data.
4. If you want the schema's tables in mulitiple tablespaces, then do the following:
5. create the schema ii) For the tables you are importing, create the tables in the correct tablespace. iii) Import the data with the IGNORE=Y option. The create table statments in the import will fail cuz the tables are already created, but this error will be ignored. The import will then import the data into the tables.

> Wouldn't an Import attempt to place the tables in the same tablespace as the
> original database?

It will unless you've taken steps like above.  

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================