Re: Creating duplicate Tables

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: 2000/03/25
Message-ID: <8bir6t$m3c$1@soap.pipex.net>#1/1

or if the 2nd user is granted select on the first users table

create table t2 as select * from user1.t1 storage clause

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Abbate Carmine" <ca.notizie_at_infinito.it> wrote in message
news:8bg39d$e89$1_at_news.mclink.it...


> With the Import utility.

>

> Step1)  exp tables=(owner1.tab1,owner1.tab2etc)

> Step 2)  imp fromuser=<user1> touser=<user2> tables=tab1,tab2,etc

>

>

> Brandon Duncan <bduncan_at_pietechnet.com> wrote in message

> 8bg1br$bt0$1_at_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

> >

> >

>

>

Received on Sat Mar 25 2000 - 00:00:00 CST