Home » RDBMS Server » Server Administration » Getting this below error while trying to recreate a tablespace if the file already exists (Oracle 9i)
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
manoj12
Messages: 185
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 #316255 is a reply to message #316244] Thu, 24 April 2008 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
File already exists on OS.
Use "reuse" option if you keep the same file size or drop it at OS level.

Regards
Michel
Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316268 is a reply to message #316255] Thu, 24 April 2008 07:29 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear team

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,,

[Updated on: Thu, 24 April 2008 07:29]

Report message to a moderator

Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316269 is a reply to message #316268] Thu, 24 April 2008 07:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What command did you issue to shutdown the database?

Do you see any errors in the alert log?
Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316271 is a reply to message #316269] Thu, 24 April 2008 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What command did you issue to shutdown the database?

And are you SYSDBA?

Regards
Michel
Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316275 is a reply to message #316271] Thu, 24 April 2008 07:55 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Yes I am a SYSDBA.

I HAVE ISSUED SHUTDOWN CLAUSE IN THE SQLPLUS.

I AM GETTING THE BELOW ERROR.PLEASE HELP ME TO RECTIFY THE BELOW

[Updated on: Thu, 24 April 2008 07:55]

Report message to a moderator

Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316298 is a reply to message #316275] Thu, 24 April 2008 09:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ DON'T POST IN UPPER CASE
2/ Copy and paste the whole SQL*Plus session INCLUDING the connection

Regards
Michel
Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316406 is a reply to message #316298] Fri, 25 April 2008 00:41 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
MANY THANKS.
Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316412 is a reply to message #316406] Fri, 25 April 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you know the purpose of the link "ignore all messages by this user"?

Regards
Michel
Re: Getting this below error while trying to recreate a tablespace if the file already exists [message #316417 is a reply to message #316412] Fri, 25 April 2008 01:22 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Which user?
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
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
Previous Topic: log_archive_max_processes parameter
Next Topic: Shutdown of OS Windows shutdowns database with abort option
Goto Forum:
  


Current Time: Fri Dec 02 23:10:48 CST 2016

Total time taken to generate the page: 0.07983 seconds