How can I locate my external tables in the database without knowing the names and the count of those external tables?
from dba_external_tables a, dba_directories b
where a.default_directory_name = b.directory_name
Dig Deeper on Database management system (DBMS) architecture, design and strategy
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.