Re: Newbie table backup question

From: <fitzjarrell_at_cox.net>
Date: Fri, 10 Aug 2007 08:15:34 -0700
Message-ID: <1186758934.600360.112230@z24g2000prh.googlegroups.com>

On Aug 10, 9:43 am, Sashi <small..._at_gmail.com> wrote:
> 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

If it's a view, not a table, why are you 'backing it up'? Besides, the error message says it all. Had you provided this information before, and a description of this view, possibly another 'solution' could present itself.

David Fitzjarrell Received on Fri Aug 10 2007 - 10:15:34 CDT