This discussion is archived
5 Replies Latest reply: Jan 2, 2013 9:02 AM by Aman.... RSS

Geting error while creating a dir through CREATE DIRECTORY command

amitavachatterjee1975 Newbie
Currently Being Moderated
Hi Gurus,

When I'm trying to create a dir through this command with logged in as SYS

CREATE DIRECTORY pump_dir AS 'd:\temp\pump_dir';

I'm getting the error
...
Error starting at line 1 in command:
CREATE DIRECTORY pump_dir AS 'd:\temp\pump_dir'
Error at Command Line:1 Column:18
Error report:
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
...

Any ideas how I can create a dir and grant access to a different user.

Thanks
Amitava.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points