amitavachatterjee1975 wrote:use a different OBJECT_NAME; since PUMP_DIR already exists
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
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.
amitavachatterjee1975 wrote:Actually it is , please see,
I checked and there is no such directory. I guess it is not that simple, the error I mean.
So as Sb mentioned, check that which object is using the same name that you are trying to assign to this directory object and either rename or drop the object if you want to use the same name only. If not, you can always use another distinct name for this directory object .
ORA-00955: name is already used by an existing object Cause: An attempt was made to create a database object (such as a table, view, cluster, index, or synonym) that already exists. A user's database objects must have distinct names. Action: Enter a unique name for the database object or modify or drop the existing object so it can be reused