Subject create tbale EXTERNAL cmd usage
Author karthick srini
Dear Members,

While I tried to create table in external file in ISQL
, I have got an authorization exception. How to make
it work. Below is the snippet from ISQL prompt.

SQL> create table test external '\Temp\passwd.txt' (id
Statement failed, SQLCODE = -902

Access to external file "C:\TEMP\PASSWD.TXT" is denied
by server administrator

I tried with different types of files such as
\Temp\passwd , etc. And I tried without and with the
actual file as in the specified file spec(file
location following external keyword external).

Note: I logged in sysdba account (Administrator)

Please do help in fixing this problem,


Do you Yahoo!?
Shop for Back-to-School deals on Yahoo! Shopping.