ddl gathering oracle

dblinks structure.sql

Set long 1000
set pages 500
set lines 200
SELECT DBMS_METADATA.GET_DDL('DB_LINK',db.db_link,db.owner) from dba_db_links db;

schema structure.sql

set long 2000000 pagesize 0 head off verify off feedback off linesize 132

select name, password from sys.user$ where name like 'SCOTT';

SELECT dbms_metadata.get_ddl('USER','SCOTT') FROM dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','SCOTT') from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','SCOTT') from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','SCOTT') from dual;

SELECT dbms_metadata.get_ddl('ROLE','RESOURCE') from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','RESOURCE') from dual;



set long 2000000 pagesize 0 head off verify off feedback off linesize 132

select name, password from sys.user$ where name like 'SCOTT';

SELECT dbms_metadata.get_ddl('USER','SCOTT') FROM dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','SCOTT') from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','SCOTT') from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','SCOTT') from dual;

SELECT dbms_metadata.get_ddl('ROLE','RESOURCE') from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','RESOURCE') from dual;

table structure.sql

SELECT DBMS_METADATA.get_ddl ('TABLE', 'TABLE_NAME', 'USER_NAME') FROM DUAL;