- Joined
- Oct 28, 2006
- Messages
- 36,581
- Likes received
- 3,172
- Thanks received
- 1,186
Any object's DDL:
SET SERVEROUT ON SIZE 1000000 LONG 1000000 PAGES 9999 LINES 200
execute dbms_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true);
SELECT DBMS_METADATA.GET_DDL('<object_type>','<object_name>','<owner>')
FROM DUAL;
The DBA may well dob you in.
Typical DBA, overcomplicating things!
What's wrong with SELECT text FROM all_views WHERE view_name = '<blah>'?
but still made me 