Xref: alice comp.databases.oracle.tools:41685
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!feeder.via.net!newshub1.home.com!news.home.com!news1.rdc1.mb.home.com.POSTED!not-for-mail
From: "Brian W. Chester" <bwchester@home.com>
Newsgroups: comp.databases.oracle.tools
References: <8bg1g1$crb$1@bob.news.rcn.net>
Subject: Re: Creating duplicate Tables
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <kL6D4.21760$a27.309436@news1.rdc1.mb.home.com>
Date: Sat, 25 Mar 2000 17:33:04 GMT
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc1.mb.home.com 954005584 24.66.37.186 (Sat, 25 Mar 2000 09:33:04 PST)
NNTP-Posting-Date: Sat, 25 Mar 2000 09:33:04 PST
Organization: @Home Network Canada

Brandon,

What you want to do is a user export then use import  from user1 to user2.

See the Oracle Utilities manual for full details.
HTH

Brian

"Brandon Duncan" <bduncan@pietechnet.com> wrote in message
news:8bg1g1$crb$1@bob.news.rcn.net...
>
> 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
>
>