Home » SQL & PL/SQL » SQL & PL/SQL » External Tables -- Identifying (Oracle 9.2.0.4)
External Tables -- Identifying [message #304223] Tue, 04 March 2008 10:20 Go to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Hi,

Dumb question time.

How do I get a query of all tables in the database that are externally organized tables?

I've looked through the system views and I must be missing it.

Any hints appreciated.

Thanks.

Marc
Re: External Tables -- Identifying [message #304227 is a reply to message #304223] Tue, 04 March 2008 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALL_EXTERNAL_TABLES

Regards
Michel
Re: External Tables -- Identifying [message #304229 is a reply to message #304223] Tue, 04 March 2008 10:29 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Thank you .. told you it was a dumb question.

I appreciate it.

Previous Topic: Alter Table
Next Topic: How to Change Language and characterset dynamically.
Goto Forum:
  


Current Time: Thu Dec 08 03:56:40 CST 2016

Total time taken to generate the page: 0.08023 seconds