Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Parent table RO -- can't write to child?
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:04:48 CST