About ORA-01031: insufficient privileges Error [message #198961] |
Thu, 19 October 2006 06:21  |
romi
Messages: 67 Registered: October 2006
|
Member |
|
|
I am using oracle9i in scott/tiger account.I am trying to load csv file by external table.For this i m creating a directory with command
create directory dataload(directory_name) as 'c:/emp.csv';
but it's giving ORA-01031: insufficient privileges error.Can any one tell me what is wrong in it?
|
|
|
|
|
|
|
|
Re: About ORA-01031: insufficient privileges Error [message #199150 is a reply to message #199077] |
Fri, 20 October 2006 10:16  |
rampratap
Messages: 50 Registered: November 2004 Location: New Delhi
|
Member |

|
|
in init.ora
UTL_FILE_DIR='c:\mydir'
or
utl_file_dir=*
then restart the services or system
1. Login to sys or system as sysdba
2. Create directory utl_dir(directory name) as 'c:\mydir';
3. grant read, write to scott
start using utl_dir as oracle directory in scott
|
|
|