Re: howto: Copy tablespace in same db

On 14 Jan 2002 13:29:40 -0800, mark.powell_at_eds.com (Mark D Powell) wrote:

>"PdJ" <petercdejong_at_hotmail.com> wrote in message news:<a1ubth$t8aqv$1_at_ID-86232.news.dfncis.de>...
>> Hi cdom, (comp.databases.oracle.misc)
>>
>> I want to copy a complete tablespace into another tablespace with another
>> owner taking all permissions, indexes, triggers, etc to the other
>> tablespace. The source tablespace contains RAM and LONG types. As far I have
>> investigated such a move is therefore not possible with SQ*plus. Beleeve me
>> I have spend over a week on this but I still do not have a method which can
>> do this.
>>
>> I am a experienced ICT person but not in the Oracle DBA stuff so I need your
>> help.
>>
>> Please answer if possible by email, I read that more frequently as I do
>> newsgroups.
>>
>> Thanks!
>> Peter
>
>Peter, you can use export/import to do this. Just export the objects
>and do a fromuser, touser import. Pull your Utilities manual and look
>at the fromuser and touser parameters on import. If all the objects
>belong to one owner and the owner has no other physical objects you
>can use a user export otherwise you can extract the tables by name
>(tables= parameter). Be sure to check for the presence of public
>synonyms on the tables. You would need to re-create these. Synonyms
>are very easy to re-generate using SQL to create executible DDL (see
>dba_synonyms or user_synonyms).

Peter, grab the DataBee DBATool to make the extract and recreate of the DDL easy for yourself. It is designed exactly for this purpose. Its freeware: http://www.databee.com/dt_home.htm

Cheers
Dale Edgar
Net 2000 Ltd.
DataBee_at_DataBee.com Received on Tue Jan 15 2002 - 08:19:37 CST