Home » RDBMS Server » Enterprise Manager » please help - how to delete tablespace
please help - how to delete tablespace [message #124224] Thu, 16 June 2005 22:38 Go to next message
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




Re: please help - how to delete tablespace [message #124249 is a reply to message #124224] Fri, 17 June 2005 02:09 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: please help - how to delete tablespace [message #124305 is a reply to message #124224] Fri, 17 June 2005 07:30 Go to previous message
aiken
Messages: 7
Registered: June 2005
Location: ph
Junior Member

i didnt work Sad

but thanks 4 your reply Smile

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


Current Time: Thu Mar 28 04:16:33 CDT 2024