Home » SQL & PL/SQL » SQL & PL/SQL » Determining which tables are external tables (10g)
Determining which tables are external tables [message #381389] Fri, 16 January 2009 10:15 Go to next message
beetel
Messages: 96
Registered: April 2007
Member
Is there a way to know if a table is an external table or not? I dont seem to find which column in the ALL_TABLES determines this. Thanks in advance.
Re: Determining which tables are external tables [message #381391 is a reply to message #381389] Fri, 16 January 2009 10:21 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALL_EXTERNAL_TABLES

Regards
Michel
Previous Topic: sql
Next Topic: Invalid Identifier
Goto Forum:
  


Current Time: Sat Dec 03 03:51:43 CST 2016

Total time taken to generate the page: 0.17804 seconds