Does anyone have any scripts to capture a database schema?
Have a look at this tool. It's pretty neat and useful.
cool that been something on my wants list for a while (just never got round to sorting it out).
Thanks a lot
If you're using Oracle9i you can get the information using the DBMS_METADATA package:
You could do something like:
SET PAGESIZE 0
SET LONG 10000
SELECT dbms_meatdata(object_type, object_name, owner)
WHERE owner = 'MY_SCHEMA'
ORDER BY object_type;
SET PAGESIZE 18
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCA PL/SQL Developer
Oracle ACE Director
My website: oracle-base.com
My blog: oracle-base.com/blog