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

Thomas Gaines <Thomas.Gaines_at_noaa.gov> wrote in message news:<3E2882CB.E8A7E5CE_at_noaa.gov>...

Thomas --

You were right; the note hits the nail on the head. Since it is described as working-as-designed, apparently there is nothing to be done for it.

Unless... does anyone know if putting the parent table's indexes in a Read/Write tablespace while keeping the parent table's data in a Read Only tablespace would allow Oracle to lock the parent's index, and thus allow the update of the child table? Or am I chasing my tail?

Thank you,
Eric

> Eric -
>
> Take a look at note 1076310.6 in Metalink. It addresses
> exactly what you're seeing...
>
> Nobody Important wrote:
>
> > I don't quite understand what's happening....
> >
> > I have two tables, foo and bar. Foo is in a read only tablespace, as
> > are his indexes. Bar is in a read write tablespace, as are his
> > indexes. Bar has a foreign key to foo.
> >
> > When I try to insert a record into bar, I get the messages:
> >
> > ORA-00372: file 73 cannot be modified at this time.
> > ORA-01110: data file 73: '/u13/oradata/foobar/foo_idx.dbf'
> >
> > But I'm not modifying foo -- or if I am, I don't see how. Oracle
> > should check to see that the value I'm trying to insert into bar
> > actually exists in foo, and I can even see how it would use the index
> > and not the table to do that. But I'm not modifying foo's index, just
> > reading it.
> >
> > Can someone explain what I'm doing wrong? And perhaps a suggestion on
> > how to do it right?
Received on Mon Jan 20 2003 - 08:59:14 CST