Option 5. Similar to option 1 mentioned earlier except you don't drop the
original TS.
Set the default TS(temporarily) of the table owner to the desired TS. Alter
the user so it has no permission on the old TS (alter user xyz quota 0 on
old_TS {can't remeber syntax exactly} ). Import with INDEXES=N. Table will
go in new default TS.
Option 6. For indexes, run import separately with INDEXFILE=filename. Edit
filename with text editor, do a global replace of old index TS name(s) with
new one(s). Run script from Sql*Plus, etc.
Marc wrote in message ...
>It sort of can be done. First off indexes should not be in the same
>tablespace with tables.
>
>The easiest way to move indexes it to use the rebuild index command with
the
>unrecoverable command. With this command you can specify the new storage
>parameters.
>
>As for the table.
>Option 1. You can export it then drop the tablespace that you do not want
it
>in. You will lose anything else in that tablespace. Then when you do the
>import it will put the table in the default tablespace of the user. This
of
>course has some obvious drawbacks.
>
>Option 2. Export table. Use schema manager, Toad or some other utility to
>create a create table script. Edit the script to change the storage
>parameters. Drop table. use your script to recreate the table where you
want
>it. Then use import to bring the data back in. There is a option that
will
>ignore the error that is thrown when the table is found.
>
>Option 3. One of my programmers has had some sucess opening the dumpfile
in
>a text editor and changing the tablespace parameters. It was a pain
though.
>
>Option 4. Always pick a good spot for tables before you start putting
stuff
>in them. Also make sure they are sized properly and do not throw to many
>extents.
>
>
>
Received on Thu Jan 27 2000 - 22:20:23 CST
