Re: howto: Copy tablespace in same db

"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).

There are other options but this is the easiest for people who are not yet proficient with Oracle.

• Mark D Powell --