Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-15005 when creating tablespaces

The FlazJul 25 2008 — edited Jul 28 2008
Database oracle 10g
OS Redhat EL4
Using RAC and +ASM

Hi

I created a load of tablespaces with specific datafiles.

create tablespace whatever datafile '+DATA01/etc/etc.dbf' size 100M

I then realised I had mixed up all the datafile names so dropped them all

drop tablespace whatever;

After this I fixed up the naming and tried to recreate the tablespaces but get the following error

ORA-01119: error in creating database file '+DATA01/etc
ORA-15005: name etc/etc is already used by an existing alias

Any ideas how I get rid of these so I can start again?

Thanks for help in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2008
Added on Jul 25 2008
#general-database-discussions
4 comments
6,830 views