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

Home -> Community -> Usenet -> c.d.o.server -> Re: delete from a view

Re: delete from a view

From: Frederic Houbie <frederic.houbie_at_NOSPAM_easynet.be>
Date: Wed, 28 Apr 2004 21:21:22 +0200
Message-ID: <40900432$0$8990$6c56d894@feed0.news.be.easynet.net>

"Patrick Connors" <pmc_at_finger-rock.com> a écrit dans le message de news:c0f4d322.0404281108.67c59cc6_at_posting.google.com...
> Frederic Houbie <fh_at_ionicsoft.comNOSPAAAAM> wrote in message
news:<pan.2004.04.28.14.18.37.460759_at_ionicsoft.comNOSPAAAAM>...
> > Hi
> >
> > I have a view that is a union all of several select. If I try to delete
a
> > row, I get ora 01752 error.
> >
> > I'm sure that I can delete the row directly, there is no constraint of
FK
> > on it.
> >
> > Any idea ?
> >
> >
> > Thanks
> >
> > Frederic
>
> Not enough information. At a minimum, I'd need to know the following in
> order to answer this:
> - Is the view over more than one table?
> - What version of Oracle?
>
> - Patrick Connors

The view is a union all of several table, each table type inheriting from one object type.

so :
type t1
which contains a column UUID build with varchar2(64) UUID (so unique in the world)

type t11 inherit from t1
type t12 inherit from t1
type t13 inherit from t1
type t14 inherit from t1
type t15 inherit from t1

table1 is of type t11
table2 is of type t12
table3 is of type t13
table4 is of type t14
table5 is of type t15

create view myview of t1 as
select value(o1) from t11 o1
union all
select value(o2) from t12 o2
union all
select value(o3) from t13 o3
union all
select value(o4) from t14 o4
union all
select value(o5) from t15 o5;

I'm using Oracle Enterprise 10g

Thanks

Fred Received on Wed Apr 28 2004 - 14:21:22 CDT

Original text of this message

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