| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete from a view
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?
![]() |
![]() |