Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: Can't update table with RI back to read-only tablespace

    When I execute the following SQL, I get an error

    Code:
     UPDATE col_activity_log 
     SET CSHO_ID='Y6318',REPID=93 
     WHERE TK=5
    
    ORA-00372: file 16 cannot be modified at this time
    ORA-01110: data file 16: '/u02/oradata/test/eds_data01.dbf'
    COL_ACTIVITY_LOG does not reside in the tablespace which uses the datafile eds_data_01.dbf.

    The tables that exist in the read-only tablespace are parent tables to COL_ACTIVITY_LOG. When I disable the foreign key constraints for the two fields the update proceeds without problem.

    This one definitely has me stumped.

    ---=Chuck

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

Posting Permissions

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