Re: create java class using bfile

From: godmann <allanwtham_at_yahoo.com>
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

Original text of this message