title: Modify a nested table in Oracle
body: <p>I have the below Nested table created :</p>
  
  <pre><code>create or replace TYPE access_t AS OBJECT (
     AccessID        VARCHAR2(50),
     Eligibility       char(1)
     );
  /
  
  create or replace TYPE Access_tab IS TABLE OF access_t;
  /
  
  create or replace TYPE add_t AS OBJECT (
     city    VARCHAR2(100),
     state   VARCHAR2(100),
     zip     VARCHAR2(10),
     APOINTSARRAY Access_tab )
  ;
  /
  
  create or replace TYPE add_tab IS TABLE OF add_t;
  /
  
  CREATE TABLE RQST_STATUS
     (    RQST_ID NUMBER, 
          ADDRESS add_tab
     ) 
   NESTED TABLE ADDRESS STORE AS RQST_STATUS_ADDRESS
   ( NESTED TABLE APOINTSARRAY STORE AS RQST_STATUS_AP)
  ;
  </code></pre>
  
  <p>If i need to change ADDRESS type to new_add_tab with some additional columns instead of add_tab , Can i just use ALTER TABLE .. MODIFY .. command ?
  I am getting ORA-00922 or ORA-22913 errors . I cannot change the type directly because it is used somewhere else too. Also, the table is already loaded with data. 
  Please suggest.</p>