OraFAQ Forum: SQL & PL/SQL » External Tables -- Identifying

Home » SQL & PL/SQL » SQL & PL/SQL » External Tables -- Identifying (Oracle 9.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

External Tables -- Identifying [message #304223]

Tue, 04 March 2008 10:20

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

Report message to a moderator

Re: External Tables -- Identifying [message #304227 is a reply to message #304223]

Tue, 04 March 2008 10:27

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ALL_EXTERNAL_TABLES

Regards
Michel

Report message to a moderator

Re: External Tables -- Identifying [message #304229 is a reply to message #304223]

Tue, 04 March 2008 10:29

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

Thank you .. told you it was a dumb question.

I appreciate it.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 13:13:36 CST 2025