OraFAQ Forum: SQL & PL/SQL » External Table

Home » SQL & PL/SQL » SQL & PL/SQL » External Table (Oracle 9i)

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

External Table [message #446803]

Wed, 10 March 2010 09:14

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

Hi all,

For external tables does not require any database space.But
where the external tables are storing.

Thanks
Ramesh

Report message to a moderator

Re: External Table [message #446805 is a reply to message #446803]

Wed, 10 March 2010 09:23

cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester

Senior Member

External tables are basically pointers to files.
Therefore the storage is the file.

external tables

Report message to a moderator

Re: External Table [message #446811 is a reply to message #446803]

Wed, 10 March 2010 09:49

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

Senior Member
Account Moderator

External table are stored like views are.

Regards
Michel

Report message to a moderator

Re: External Table [message #446882 is a reply to message #446803]

Wed, 10 March 2010 21:48

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

External table is a concept by which one can reffer a flat file as a table to retrive data from that file.
And as this is a regular file, it is stored in the computer's file system.

regards,
Delna

Report message to a moderator

Previous Topic:	useful analysis from history tables
Next Topic:	Insert with restrictions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 14:38:01 CST 2024