View backup
==========
Select dbms_metadata.get_ddl(‘’,’’,’OWNER’) from dual;
set long 100000
spool MTL_SYS_ITEMS_VL.lst
select text from dba_views where VIEW_NAME='MTL_SYS_ITEMS_VL';
spool off
==========
Select dbms_metadata.get_ddl(‘’,’’,’OWNER’) from dual;
set long 100000
spool MTL_SYS_ITEMS_VL.lst
select text from dba_views where VIEW_NAME='MTL_SYS_ITEMS_VL';
spool off
No comments:
Post a Comment