use below sql to get the DDL of a specific object:
set long 32000
set long 90000
set heading off;
set echo off;
set pages 1000;
SQL> spool object_name.sql
SQL> select
dbms_metadata.get_ddl('object_type','object_name','Owner of the object') from dual;
SQL> spool off
Thanks...
No comments:
Post a Comment