[SQL] Generate Oracle database DDL without SELECT_CATALOG_ROLE

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?

Continue reading...