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 [...]
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 [...]





