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

        You can do this in five steps:

1. Create a DDL file using import with INDEXFILE=Y
2. Edit the file to reflect your new tablespace assignments
3. Create the new tablespaces
4. Create the tables and indexes using the file from step 2
5. Import the export file with IGNORE=Y

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/13/00, 6:14:24 PM, "ShengThlick" <mrthlick_at_hotmail.com> wrote regarding How do you change a table's tablespace through Import.:

> Hello,
 

> I want to move an existing schema to another database.
> However, I want to use different tablespaces for the existing tables
 rather
> than the original ones.
 

> How do I do this?
 

> Wouldn't an Import attempt to place the tables in the same tablespace

as the
> original database?
 

> I thought I would change the tablespace of the original DBs table, but
 

I
> don't think you can change tablespaces and furthermore, wouldn't the
> existing data still reside on the former tablespace?
 

> Help.
 

> Thank you
Received on Fri Apr 14 2000 - 00:00:00 CDT