Home » SQL & PL/SQL » SQL & PL/SQL » About ORA-01031: insufficient privileges Error
About ORA-01031: insufficient privileges Error [message #198961] Thu, 19 October 2006 06:21 Go to next message
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 #198965 is a reply to message #198961] Thu, 19 October 2006 07:15 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

 the error message itself is the answer for your question.you need to have create directory privilege for that.




regards,
Re: About ORA-01031: insufficient privileges Error [message #198971 is a reply to message #198961] Thu, 19 October 2006 08:07 Go to previous messageGo to next message
KCee
Messages: 16
Registered: October 2006
Junior Member
create directory dataload(directory_name) as 'c:/emp.csv';

not looking at the privilege error;
shouldn't it be a '\'?
create directory dataload(directory_name) as 'c:\emp.csv';

Re: About ORA-01031: insufficient privileges Error [message #199076 is a reply to message #198961] Fri, 20 October 2006 00:53 Go to previous messageGo to next message
romi
Messages: 67
Registered: October 2006
Member

i am giving this command,where dd is diretory name but it's giving a new error Missing Keyword.

create directory dataload dd as 'c:\emp.csv'

Can u tell me what is the problem with it?
Re: About ORA-01031: insufficient privileges Error [message #199077 is a reply to message #198965] Fri, 20 October 2006 00:54 Go to previous messageGo to next message
romi
Messages: 67
Registered: October 2006
Member

Thanks.but can u tell me that how can i give that privileges,when i use scott/tiger account.
Re: About ORA-01031: insufficient privileges Error [message #199081 is a reply to message #199077] Fri, 20 October 2006 01:10 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Check the manual?
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_58a.htm#2061964
Re: About ORA-01031: insufficient privileges Error [message #199150 is a reply to message #199077] Fri, 20 October 2006 10:16 Go to previous message
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
Previous Topic: sequences
Next Topic: ORA-00937Group by / avg problem
Goto Forum:
  


Current Time: Sat Dec 03 10:23:04 CST 2016

Total time taken to generate the page: 0.12232 seconds