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 = '某用户'
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 = '某用户'