Does anyone have any scripts to capture a database schema? Thanks
Have a look at this tool. It's pretty neat and useful. http://www.databee.com/dt_home.htm Sanjay
Thanks Sanjay
cool that been something on my wants list for a while (just never got round to sorting it out). cheers
Thanks a lot
1. www.dbasupport.com 2. www.dbforums.com 3. www.itpub.net 4. www.csdn.net 5. www.umlchina.com 6. www.tek-tips.com 7. www.cnforyou.com 8. fm365.federal.com.cn 9. www.programmersheaven.com 10.http://msdn.microsoft.com/library/default.asp ligang1000@hotmail.com
If you're using Oracle9i you can get the information using the DBMS_METADATA package: http://www.oracle-base.com/Articles/9i/MetadataAPI.asp You could do something like: SET PAGESIZE 0 SET LONG 10000 SPOOL c:\MY_SCHEMA.sql SELECT dbms_meatdata(object_type, object_name, owner) FROM dba_objects WHERE owner = 'MY_SCHEMA' ORDER BY object_type; SPOOL OFF SET PAGESIZE 18 Cheers
Tim... 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
Forum Rules