Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    4

    Unanswered: ORA-00372 inserting from a read only tablespace

    11.1.0.7 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.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    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.

  3. #3
    Join Date
    Sep 2011
    Posts
    4
    Quote Originally Posted by Littlefoot View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •