Turkbear <john.g_at_dot.spamfree.com> wrote:
>"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:
>
>>
>>"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
>>
>
>And be sure to use the FROMUSER=user2/TOUSER=user1 options with Exp( assumes you have sufficient rights and that the default
>tablespace is set for user2 and that user2 has 0 quota on user1's tablespace)
>
OOPs...That should be
FromUser=User1 ToUser=User2
Received on Thu May 12 2005 - 12:48:28 CDT
