Re: Copy or move a talble

Alternatively, Just use CREATE TABLE AS SELECT syntax. You'll have to do a RENAME in there as well. And don't forget to move you indexes over and check privileges, etc.

MotoX.

On Thu, 17 Dec 1998 16:29:08 -0000, "Vinay Joshi" <vjoshi_at_pinnacle.co.uk> wrote:

>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 - 14:43:24 CST