Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie table backup question

Re: Newbie table backup question

From: Helma <bad_elefant_at_hotmail.com>
Date: Fri, 10 Aug 2007 07:40:26 -0700
Message-ID: <1186756826.671977.222990@i13g2000prf.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US