Re: Creating duplicate Tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 24 Mar 2000 18:43:43 +0800
Message-ID: <38DB46DF.6E@yahoo.com>

Brandon Duncan wrote:
>
> To any ORACLE experts:
>
> Would someone please tell me how to backup Tables along with their indexes
> and other associated objects and then restore them under a different
> User/TableSpace resulting in Two Different Users, each in a seperate table
> space, with instances of the tables backed up?
>
> I would greatly appreciate any insight.
>
> Brandon

export and import will do the job

exp owner=user1

imp fromuser=user1 touser=user2

HTH
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Fri Mar 24 2000 - 04:43:43 CST