Re: Copy table data from one schema to another scheman

(also mailed to L1)
L1 wrote:
> Hello All,
>
> wonder if you know a simple way (sql, or plsql) to copy table data
> from one schema to another schema for temporary achival purpose.
>
> thanks,
> l1

Create table archive_xyz as
select * from otherschema.xyz;

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost