Alter a table with user-defined object to upgrade including data
SQL> SQL> create or replace 2 type person as object( 3 first_name varchar2(100), 4 last_name varchar2(100) ) 5 / Type created. SQL> SQL> SQL> create table person_table( 2 name person, 3 age number ) 4 / Table created. SQL> SQL> SQL> SQL> alter table person_table upgrade including data; Table altered. SQL> SQL> SQL> drop table person_table; Table dropped. SQL> SQL> SQL> drop type person; Type dropped. SQL> SQL>