Re: create java class using bfile
Date: 3 Sep 2001 01:03:03 -0700
Message-ID: <95cd51c.0109030003.6e61aa31_at_posting.google.com>
Mark,
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.
When you try to do a create directory as .. you get the above error. So, you have to drop the directory by issuing :
sqlplus> drop directory bfile_dir;
Check what is bfile_dir right now by issuing: select * from all_directories;
Try again. I issued this command all the time, there is no problem for me.
Allan W. Tham
DBA
Received on Mon Sep 03 2001 - 10:03:03 CEST