Home » SQL & PL/SQL » SQL & PL/SQL » External Table (Oracle 9i)
External Table [message #446803] Wed, 10 March 2010 09:14 Go to next message
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



Re: External Table [message #446805 is a reply to message #446803] Wed, 10 March 2010 09:23 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
External tables are basically pointers to files.
Therefore the storage is the file.

external tables
Re: External Table [message #446811 is a reply to message #446803] Wed, 10 March 2010 09:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
External table are stored like views are.

Regards
Michel
Re: External Table [message #446882 is a reply to message #446803] Wed, 10 March 2010 21:48 Go to previous message
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
Previous Topic: useful analysis from history tables
Next Topic: Insert with restrictions
Goto Forum:
  


Current Time: Sun Dec 04 22:46:56 CST 2016

Total time taken to generate the page: 0.08143 seconds