5 Replies Latest reply on Jan 2, 2013 5:02 PM by Aman....

    Geting error while creating a dir through CREATE DIRECTORY command

      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.