External Files? [message #61769] |
Wed, 26 May 2004 06:32 |
Patrick Tahiri
Messages: 119 Registered: January 2004
|
Senior Member |
|
|
<DIV style="mso-line-spacing: '100 20 0'; mso-margin-left-alt: 216; mso-char-wrap: 1; mso-kinsoku-overflow: 1">Hi
Could you, please, explain me what is the external file? What is its use? And how (conceptualy) we use it and should use it?
In a security book, I have red:
"
Don’t use any external files if possible!
SELECT COUNT(*) FROM DBA_EXTERNAL_TABLES --> Should be 0 !!
"
Can someone tell me why? Is the some user_name, password or server settings info?
Thank you for your help!
Regards,
Patrick.</DIV>
|
|
|
Re: External Files? [message #61781 is a reply to message #61769] |
Wed, 26 May 2004 22:22 |
ora9iDBA
Messages: 31 Registered: March 2003
|
Member |
|
|
external table is new concept in oracle 9i
the data is lying outside of oracle e.g. in flat files in the server. but the metadata of this data will be lie in data dict.
when you select from external table... oracle will read this flat file and give you output.
Kishor
|
|
|