OraFAQ Forum: Enterprise Manager » please help

Home » RDBMS Server » Enterprise Manager » please help - how to delete tablespace

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

please help - how to delete tablespace [message #124224]

Thu, 16 June 2005 22:38

aiken
Messages: 7
Registered: June 2005
Location: ph

Junior Member

hello people Smile

i just want to ask a thing :
please help me Smile

heres what happen...

i've run a sqlfile that will create a tablespace...
but i run it on a wrong database...

so i deleted the created tablespace using Enterprise Management Console,
but i forget to delete the other tablespace...

the next thing i do is i delete the files created...

w/o knowing that there still a tablespace in Enterprise Managemet Console

When i try to delete the tablespace using Eneterprise Managemen Console i get an error...

so my first solution is to generate a tablespace(file) again and just rename it to the one i deleted.

but still no luck

i received a message :

ORA-01122:database file 10 failed verification check
ORA-01110:data file 10:
'path in here'
ORA-01251:Unknown File Header Version read for file number 10

i messed up.... huhu!

please help on this Smile

hope someone can give a better solution in this Smile

thanks in advance Smile

Report message to a moderator

Re: please help - how to delete tablespace [message #124249 is a reply to message #124224]

Fri, 17 June 2005 02:09

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Try the following to get rid of the tablespace:

ALTER DATABASE DATAFILE '...' OFFLINE DROP;
ALTER TABLESPACE ... OFFLINE IMMEDIATE;
DROP TABLESPACE ...;

BTW: If this is a production database, take a backup first!

Best regards.

Frank

Report message to a moderator

Re: please help - how to delete tablespace [message #124305 is a reply to message #124224]

Fri, 17 June 2005 07:30

aiken
Messages: 7
Registered: June 2005
Location: ph

Junior Member

i didnt work Sad

but thanks 4 your reply Smile

Report message to a moderator

Previous Topic:	Database Sizing
Next Topic:	enterprise manager freezes on selecting XML tab

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 21:46:08 CST 2024