How can I locate my external tables in the database without knowing the names and the count of those external...
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
Are business intelligence certifications worth it? Get certification advice from our business intelligence expert, William McKnight. Continue Reading
Get examples of how data mining is used in vertical industries, such as retail, manufacturing, healthcare, financial and telecommunications. Continue Reading
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... 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.