Re: Newbie table backup question

On Aug 10, 4:43 pm, 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

create table NED_REGION_CAMPUS_BACKUP

   as select * from NED_REGION_CAMPUS; Received on Fri Aug 10 2007 - 09:46:20 CDT