OraFAQ Forum: Backup & Recovery » how can asm datafile is deleted

Home » RDBMS Server » Backup & Recovery » how can asm datafile is deleted

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

how can asm datafile is deleted [message #190363]

Wed, 30 August 2006 06:41

ramkrishna_gosavi
Messages: 15
Registered: June 2006
Location: pune

Junior Member

hi
i am ramkrishna
i am create one tablespace name is RG
then take a backup of this tablespace (RG)
after asm(automatic storage managment ) logon and try the delete RG tablesapce but can't delete ,error msg is display 'currently use' its very urgent can one of the command how can delete this tablespace

(i hv try restore the tablespace after asm delete)
Regards
ramkrishna

Report message to a moderator

Re: how can asm datafile is deleted [message #190765 is a reply to message #190363]

Fri, 01 September 2006 02:54

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

Hi

Does the tablespace hold any data/segments?

Br
Kim

Report message to a moderator

Re: how can asm datafile is deleted [message #191675 is a reply to message #190363]

Thu, 07 September 2006 12:59

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

You cant simplly delete the tablespace.

You have to alter the tablespace and make it offline and then drop the tablespace. and dlete the related datafiles from OS level. And later on create the new tablespace wirh the samename.

Thanks,

Mohan Reddy G

Report message to a moderator

Previous Topic:	Import related query
Next Topic:	Delete a datafile from physical location

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 16:55:08 CDT 2025