Q
Problem solve Get help with specific problems with your technologies, process and projects.

Locating 'lost' external tables in a schema

Forgot what you named your external tables and what directory they are in? Have no fear, our expert tells you how to locate them!

I am working on Oracle-10g. A few days ago I created several external tables in my schema. Now I don't remember the names of all the tables. Nor do I have any details about to which external directory/directories these tables are linked.

How can I locate my external tables in the database without knowing the names and the count of those external tables?

To locate your missing tables, use the following query:

select a.*,b.*
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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close