I need to generate the DDL for an Oracle database, including other owners’ schemas, to recreate the database structure on another server. I understand this is usually done through Export Data or the DBMS_METADATA.GET_DDL
function. However, I don’t have the SELECT_CATALOG_ROLE
role, which is required for those. Can I manually generate the DDL using data dictionary views such as ALL_TAB_COLUMNS
?
You need to sign in to view this answers