Re: Copy Command in SQL for Oracle 8 and up obsolete?

drsmartz_at_yahoo.com (Andy) writes:

> I have looked everywhere after reading in an Oracle 7 manual that the
> copy command in version 8 and up of oracle will become obsolete.
>
> Is this a fact?
> And if it is, is there another similar command I can use to copy all
> fields from one table to another table?
>

Could you just use

create table foo
as select * from bar

or

insert into foo
select * from bar

?

Tim Received on Wed Jun 19 2002 - 17:54:30 CDT