This discussion is archived
1 Reply Latest reply: Oct 22, 2009 9:05 AM by 543302 RSS

Error ORA-20067 when simulation partitioning

user603925 Newbie
Currently Being Moderated
Tests with based on OBE sample (ilm_data.sql)

Selected Lifecycle Table : TTL.SALES
"Preview Simulation" then error: ORA-20067: No valid read-only tablespace found on tier 111

Any ideas?
  • 1. Re: Error ORA-20067 when simulation partitioning
    543302 Newbie
    Currently Being Moderated

    I believe it indicates that you need to define a read-only tablespace for the referenced storage tier. When a lifecycle stage specifies the data to be read-only when it enters, ILMA will lookup the associated storage tier for the stage. Then, it must find a read-only tablespace on that tier. When you attempted to preview your simulation, the rule engine detected the missing tablespace.

    To resolve this, go back to the storage tier setup and choose a tablespace for read-only data. Note, it can be a read-write tablespace as ILMA will pretend to clone the selected tablespace during simulation.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points