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 I query DD from my account...? Thx
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!