Re: [8.1.7.4] Duplicate tablespace

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 12 May 2005 06:31:30 -0400
Message-ID: <8dydndo7Iu8erR7fRVn-vA@comcast.com>

"Yannick ROGER" <yroger_at_sqli.com> wrote in message news:d5v4ut$dn9$1_at_reader1.imaginet.fr...
> Hi,
>
> In the same instance, on Oracle 8.1.7.4, I want to copy all data owned by
> user user1 in a tablespace tbs1 to another tablespace tb2 owned by user2.
> Is
> it possible? How can I do?
>
> Regards,
>
> Yannick
>
>

query DBA_TABLES to get a list of tables in that tablespace, and use that list to generate ALTER TABLE MOVE commands:

ALTER TABLE scooter.department MOVE TABLESPACE lusers;

You will then need to rebuild all indexes on the moved tables

++ mcs Received on Thu May 12 2005 - 05:31:30 CDT