Re: Moving tables from tablespace

From: Tracie Thomas <tracie_at_aosi.com>
Date: 1996/10/17
Message-ID: <3266ECD4.7280_at_aosi.com>#1/1


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 create table user2.tablename as select * from user1.tablename. Ensure that user2 has a default tablespace of TS2. However, you will not copy constraints/indexes with this method. To copy constraints and indexes on the tables, an easy way is to export/import. Received on Thu Oct 17 1996 - 00:00:00 CEST

Original text of this message