We often need to find the definition of the table ,index ,views etc to replicate the structure in another database Oracle has a very useful command to find the metadata definition of the various structure .This command is very useful in extracting the metadata of any objects like table, index, views, Materialized views select dbms_metadata.get_ddl (‘<OBJECT_TYPE>’,'<OBJECT_NAME>’,'<OBJECT_OWNER>’) from dual; The output of the query is of … Continue reading how to find the metadata of any object in Oracle »