OraFAQ Forum: Server Administration » tablespace read only

Home » RDBMS Server » Server Administration » tablespace read only

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

tablespace read only [message #160895]

Tue, 28 February 2006 23:39

oracram
Messages: 17
Registered: February 2006

Junior Member

hi all

I want to make a tablespace read only. but when i issue

alter tablespace <xxx> read only,
it remains like that only for a long time. The query does not come out. what could be the reason? earlier it used to work fine..

Plz help

Report message to a moderator

Re: tablespace read only [message #160973 is a reply to message #160895]

Wed, 01 March 2006 04:05

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

The following articel does help your cause:

www.orafaq.com/papers/readonly.doc

Report message to a moderator

Re: tablespace read only [message #160984 is a reply to message #160895]

Wed, 01 March 2006 04:42

frank.svs
Messages: 162
Registered: February 2006

Senior Member

Hi ,
This might help u out.

May be some active txns are writing some data into that particular tablespace.That might be one of the reasons why
u cannot make a tablespace read only.

Report message to a moderator

Previous Topic:	Tablespace-Datafile-Tables ???
Next Topic:	difference b/w 2 core_dumps parameters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 14:18:59 CST 2025