Oracle Data Dictionary
I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this information in [...]

Answer Question   |  February 18, 2009  3:59 PM
Oracle 10g, Oracle 10g Database, Oracle Data Dictionary, Oracle development

Oracle Data Dictionary location
Hi, I am trying to use this query to get the names of all tables in DD that begins with ‘TEMP%’ (say) I am a user and have select privileges to the main schema that has all these tables.[SQL> select table_name from main_schema.user_tables where table_name like 'TMP%';] It does not fetch any results. How can [...]

Answer Question   |  September 6, 2011  7:06 PM
Oracle Data Dictionary