SELECT o.OBJECT_NAME, DBMS_METADATA.GET_DDL(O.OBJECT_TYPE, O.object_name, O.OWNER)
FROM DBA_OBJECTS O where O.OBJECT_TYPE IN( 'INDEX' ,'TABLE') and O.OWNER = '某用户'
查询ORACLE DDL语句(创建表,创建索引)
最新推荐文章于 2023-12-18 15:47:46 发布
SELECT o.OBJECT_NAME, DBMS_METADATA.GET_DDL(O.OBJECT_TYPE, O.object_name, O.OWNER)
FROM DBA_OBJECTS O where O.OBJECT_TYPE IN( 'INDEX' ,'TABLE') and O.OWNER = '某用户'