OraFAQ Forum: Server Administration » Getting this below error while trying to recreate a tablespace if the file already exists

Home » RDBMS Server » Server Administration » Getting this below error while trying to recreate a tablespace if the file already exists (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting this below error while trying to recreate a tablespace if the file already exists [message #316244]

Thu, 24 April 2008 06:50

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

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

manoj12
Messages: 210
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

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?

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

What command did you issue to shutdown the database?

And are you SYSDBA?

Regards
Michel

Report message to a moderator

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

manoj12
Messages: 210
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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

MANY THANKS.

Report message to a moderator

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you know the purpose of the link "ignore all messages by this user"?

Regards
Michel

Report message to a moderator

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

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Which user?

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	log_archive_max_processes parameter
Next Topic:	Shutdown of OS Windows shutdowns database with abort option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 21:35:19 CST 2024