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: Sashi <smalladi_at_gmail.com>
Date: Fri, 10 Aug 2007 07:43:33 -0700
Message-ID: <1186757013.253959.203410@q4g2000prc.googlegroups.com>


On Aug 10, 10:40 am, Helma <bad_elef..._at_hotmail.com> wrote:
> it does on mine

Er, did I mention that I'm a newbie?



SQL> create table NED_REGION_CAMPUS_BACKUP   2 as
  3 select NED_REGION_CAMPUS.* from NED_REGION_CAMPUS; select NED_REGION_CAMPUS.* from NED_REGION_CAMPUS
                         *

ERROR at line 3:
ORA-01723: zero-length columns are not allowed

It so happens that this object is a view and not a table. Thanks,
Sashi Received on Fri Aug 10 2007 - 09:43:33 CDT

Original text of this message

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