Last updated on March 22nd, 2019 at 04:05 amWe often need to find the definition of the table ,index ,views etc to replicate the structure in another oracle 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>’) … Continue reading how to find the metadata of any object in Oracle »