Getting this below error while trying to recreate a tablespace if the file already exists [message #316244] |
Thu, 24 April 2008 06:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
manoj12
Messages: 210 Registered: March 2008 Location: India
|
Senior Member |
|
|
Dear team
after i droppped the tablespace once again i recreated the tablespace with same filename.the above error popups,however when i query the dba_data_files i didn't find any files similar which i'm trying to use in new tablespace.
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exist.
Now I wanted to recreate a tablespace with the datafile already exists.Can I do that
Regards
|
|
|
|
|
|
|
|
|
|
|
|
Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316475 is a reply to message #316244] |
Fri, 25 April 2008 05:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Quote: |
After dropping the tablespace including contents the table structure asscociated to that tablespace also gets dropped.Now after restarting the services I am getting the below error while shutting down the database USING SHUTDOWN CLAUSE IN THE SYS USER.
ORA-0900 INVALID SQL STATEMENT.
I WANTED TO SHUTDOWN THE DATABASE.COULD YOU PLEASE HELP ME,,
|
1)put the CAPSLOCK off of your keyboard.Don't write in capital letters
2)Post the entire session
3)If you still write in capital letters,you will be ignored
|
|
|