Re: Copy or move a talble

Hi,
You can use the exp / imp facility to export and import a table. eg.
exp user/pwd buffer=1024000 file=mytable.dmp log=mytable.log \

    tables=mytable

Once the dmp file is created, drop the table and recreate it in a new tablespace and use IMP to import it.

imp user/pwd buffer=1024000 commit=y ignore=y file=mytable.dmp \ log=mytable.log full=Y

PS:
experiment with a test table before using the above on a production table.

G. Kakisina wrote in message <75b9aa$pms$1_at_freyja.bart.nl>...
>Hello,
>
>How can i copy or move a table from one tablespace to another?
>
>G. Kakisina
>
>
Received on Thu Dec 17 1998 - 10:29:08 CST