Re: Parent table RO -- can't write to child?

Howard --

Thank you for responding. I've tried to answer some of your questions below...

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<_h%V9.26711$jM5.69888_at_newsfeeds.bigpond.com>...
>
> :
>
> Yet you have a problem... so what could it be? Well, since no version of
> Oracle was mentioned (nor a platform) it is conceivable that what I've just
> done is only true in 9i, and that earlier releases suffered from this
> problem. But I doubt it (especially since I remember demonstrating this in
> 8.0). It might be O/S specific (another thing you didn't mention), and so my
> test could work in Windows (which I use) but fail on some other platform.
> But I doubt it, since the 8.0 demo was done on Solaris.

Oracle 8.0.6 on AIX

> You might not be using SQL*Plus. Quite often, when I write Access front-ends
> to applications, I can't be bothered working out which field has been
> modified on a form. So I just iterate through all the fields, and update the
> entire record. You *think* you've just updated a 'QUANTITY' field, but my
> form issues a SQL statement along the lines of 'update SALES set
> col1=field1, col2=field2, col3=field4,QUANTITY=field5;' etc). Possibly your
> application (which again you didn't provide details of) is doing that. So
> even though you *think* you're only inserting values in fields X, Y and Z,
> actually the application is saving fields A, B and C in a different table.
> Possible, but I can't tell from the information you provided.

The original app was PowerBuilder. However, I turned the tracing on, cut and pasted the SQL sent from PowerBuilder into SQL*Plus, replaced the host variables with literals, and got the same result.

>
> Are you sure that you simply made the parent table's tablespace read only,
> and that it hasn't been taken offline in any way, shape or form? For
> example:
>

I can do a SELECT from the parent table...

>
> :
>

One other thing I should mention: when I asked my DBA what the problem was, she told me the parent table was Read Only; she made the tablespace Read/Write and I was able to update the child table. But she was unable to explain to me why the parent table had to be Read/Write. I would like to keep the parent table Read Only, so if there is something I can do I'd appreciate knowing it.

I have also asked my DBA for a copy of the Metalink 1076310.6 article Thomas suggested.

Thank you,
Eric Received on Mon Jan 20 2003 - 07:39:52 CST