I think your looking for DBMS_METADATA.GET_DDL which was introduced in 9i HTH
Jim Oracle Certified Professional "Build your reputation by helping other people build theirs." "Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website!
Forum Rules
Reply With Quote