var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORA-00372 inserting from a read only tablespace
18.104.22.168 getting 00372 when trying to update or insert when selecting from a table with a LOB thats stored in a read only tablespace
-- image_arc is table with LOBs stored in readonly tablespace
create table test_readonly as
(select * from image_arc
where pid = 12345;
ORA-00372: file 50 cannot be modified at this time
ORA-01110: data file 50: '+APP/localdb/datafile/ts_lob_ro.dbf'
-- image_arc1 is table with LOBs stored in readwrite tablespace
-- and try from the RW table
create table test_readwrite as
(select * from image_arc1
where pid = 56789;
table creates fine.
same error occurs if i try an insert as select. very puzzled.
In which tablespace are you trying to create the TEST_READONLY table? Is it, perhaps, the same read-only tablespace? If so, it is self-explainable.
it is not. default tablespace is users and is RW. first thing I thought of really so I forced it to test that.
Originally Posted by Littlefoot