cre_all.sql

DECLARE
LS_SID varchar2(10);
BEGIN
SELECT name
  INTO  LS_SID
  FROM V$DATABASE;
 pkg_support.sp_get_objects('TABLE',NULL,LS_SID,NULL);
 pkg_support.sp_get_objects('TRIGGER',NULL,LS_SID,NULL);
 pkg_support.sp_get_objects('PACKAGE',NULL,LS_SID,NULL);
 pkg_support.sp_get_objects('PACKAGE BODY',NULL,LS_SID,NULL);
 pkg_support.sp_get_objects('VIEW',NULL,LS_SID,NULL);

END;
/