Hi all,
11.2.0.1 64bit
on DELL R610
It seemed oracle has failed me
I am inserting a big table with LOB pictures with 300,000 rows. I expect it to occupy disk of 40G. So I created 3 datafiles on USERS tablespace where my schema
defaulted. Since Oracle or the server or whichever of them is the culprit has limit of 32G per datafile even if they are both 64bit. This I dont understand why? I thought
only 32bit OS and 32bin Oracle has 32G limit max size on each datafile? But I found out now that it failed on both platform.
So what I did is to create another 2 datafiles in USERS tablespace. Then I insert again, but again I hit ORA-1691 . I can see that
/oradata/users1.dbf has 32G size meaning it hits the limit, But I dont understand why it did not switch to the next 2 dbfs? which were untouched of
/oradata/users2.dbf has 2G (initial untouched)
/oradata/users3.dbf has 2G (initial untouched)
Is oracle not intelligent enough to see that there are other datafiles available?
Please help me shed light on this confusions
Thanks a lot,
zxy