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

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?
>
> Thank you,
> Eric
Received on Fri Jan 17 2003 - 16:25:16 CST