5 Replies Latest reply: Jan 2, 2013 11:02 AM by Aman.... RSS

    Geting error while creating a dir through CREATE DIRECTORY command

    amitavachatterjee1975
      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.