Re: Moving a table to another tablespace

From: giridhar <tgiridhar_at_yahoo.com>
Date: 4 Sep 2002 06:33:35 -0700
Message-ID: <c7b5ba55.0209040533.18b14b4b@posting.google.com>

Create a new table with a new name with same column names in the required tablespace .Now use copy from command to copy.

 SQL> create table le2

     (c1 number, 
      c2 long);

 SQL> copy from scott/tiger_at_otcsol1_v734 to scott/tiger_at_otcsol1_v734 -


      > append le2 -

      > using select * from le;

where le is the original table and le2 is the new table. Received on Wed Sep 04 2002 - 08:33:35 CDT