Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [8.1.7.4] Duplicate tablespace
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:8dydndo7Iu8erR7fRVn-vA_at_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
>\
OOPS! you said COPY, not MOVE....
just use exp and imp utilities -- generate a list of tables for the exp TABLES parameter
++ mcs Received on Thu May 12 2005 - 05:33:55 CDT