Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Parent table RO -- can't write to child?

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

From: Nobody Important <CanTheMongoose_at_hotmail.com>
Date: 17 Jan 2003 14:04:48 -0800
Message-ID: <6d951625.0301171404.4d58126e@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US