Re: Moving tables from tablespace

Patrick Coulier wrote:
>
> Dear Oracle-newsgroupreaders,
>
> As an Oracle-newbee,
>
> this seems to be the place to ask my simple question:
>
> What's the easiest way to move a table from user USER1 and tablespace TS1 to
> another user USER2 and tablespace TS2 ???
>
> Any help is very appreciated.
>
> Pat

Try this.

  Make sure the default tablespace of USER2 is TS2.   Make sure USER2 has SELECT access to TS1 tables owned by USER1

  Log on as USER2

     Create table table_name
     as
       (select * from TS1.table_name);

  Good luck,
  Radhakrishnan Received on Thu Oct 17 1996 - 00:00:00 CEST