Re: howto: Copy tablespace in same db

From: PdJ <petercdejong_at_hotmail.com>
Date: Tue, 15 Jan 2002 11:32:37 +0100
Message-ID: <a210dg$t7ev7$1@ID-86232.news.dfncis.de>

Thanks Mark, I will give it a go.

Greetings,
Peter

"Mark D Powell" <mark.powell_at_eds.com> wrote in message
> 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 --
Received on Tue Jan 15 2002 - 04:32:37 CST