Scrip to take backup of View and Trigger

 Below is the script to take View Backup:

set pagesize 0
set long 2000000000
set feedback off
set echo off 
set trimspool on
begin
  dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'SQLTERMINATOR', true);
  dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'PRETTY', true);
 DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);
end;
/
select dbms_metadata.get_ddl('VIEW','AP_UNDO_INVOICES#','OWNER') from dual;


Below is the script to take Trigger Backup:

set heading off;
set echo off;
Set pages 999;
set long 90000;
spool on 
spool name.trg
select dbms_metadata.get_ddl('SYNONYM','name','OWNER') from dual;


You can validate the status by using below script:


select OBJECT_NAME,OWNER,OBJECT_TYPE,LAST_DDL_TIME,STATUS from dba_objects
where OBJECT_NAME='&Object_name';