Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie table backup question
On Aug 10, 3:49 pm, Sashi <small..._at_gmail.com> wrote:
> Hi All,
> Isn't it possible to backup an existing table using the following
> syntax?
>
> create table mytable_backup
> as
> select * from mytable?
>
> This isn't working on my 10g. mytable has like 40 columns and I don't
> want to go thru the effort of first running a create table and then
> use an "insert into select".
>
> What is a self-respecting lazy developer to do?
>
> Thanks,
> Sashi
> create table mytable_backup
> as
> select * from mytable?
>
> This isn't working on my 10g.
it does on mine Received on Fri Aug 10 2007 - 09:40:26 CDT