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

[Quoted] You can write something like:

[Quoted] 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 - 02:11:28 CEST