Oracle entire schema's scripts via dbms_metadata.get_ddl

dbms_metadata.get_ddl for entire schema's scripts



select distinct object_type from dba_objects where owner='ANUJ';

OBJECT_TYPE
---------------------------------------------------------
INDEX
PROCEDURE
TABLE
VIEW
FUNCTION
TRIGGER
PACKAGE BODY
PACKAGE
SEQUENCE
LOB


so there is space between PACKAGE BODY.


we can try this


Example .....

set long 3000
select dbms_metadata.get_ddl (REGEXP_replace(OBJECT_TYPE,'[[:space:]]','_'),object_name,owner)
from DBA_objects where owner='ANUJ' and OBJECT_TYPE like '%PACKAGE%';