Re: copy table and its contents into different account in oracle.

You also ned to give the correct grant to users as well. eg olduser.oldtable
then grant select on oldtable to newuser login as newuser
> create table newuser.newtable as select * from olduser.oldtable;
Tom

Paul Druker <pdruker_at_metaway.com> wrote in message news:QEsK4.25257$042.111915_at_typhoon.southeast.rr.com...
> You can write something like:
>
> create table newuser.newtable as select * from olduser.oldtable;
>
> If table is quite big you may need to use "set transaction use rollback
> segment..."
>
> Paul
> "yoon" <yoonjung_at_cs.tamu.edu> wrote in message
> news:8ddije$oeb$1_at_news.tamu.edu...
> > I would like to copy the table and its contents(data) into different
> account
> > (different user id) because I need to keep the original data and want to
> > work with database with different account. It takes a long time to
create
> > same table and insert the row into each table.
> > How can I do this ?
> >
> > Thanks!
> >
> >
> >
> >
>
>
Received on Mon Apr 17 2000 - 03:31:35 CEST