/* Get original create statement for table or view */ 

select text from user_views where view_name = 'V_STUDENT_ROSTER';

select DBMS_METADATA.get_ddl('VIEW',  'V_STUDENT_ROSTER') from DUAL;

select DBMS_METADATA.get_ddl('TABLE', 'STUDENT') from DUAL;