Paul,

Get a downtime ,
Give the command shutdown immediate.
Start in restricted session.
Then give the command.

Rohit


-----Original Message-----
From: Paul Walker [mailto:oracledba-ezmlmshield-x38985979.[Email address protected]
Sent: Friday, July 30, 2004 7:09 PM
To: LazyDBA Discussion
Subject: read only command

Hi,

I've created a tablespace and was trying to to issue the following command:

alter tablespace ts_name read only

this command hung over the weekend even though all other processing on the
database was in different tablespaces

looking in dba_waiters showed that my command was waiting on another
session. Can anyone explain why?

I have tried the command as a normal user as well as sysdba, some effect.

I'm running 9.2.0.5 on Windows 2003



regards

Paul Walker
Database Administrator
Tel: 020 7871 9029
Fax: 020 7871 9009

Email: [Email address protected] <mailto:[Email address protected]

Web: www.wegenerdm.co.uk <http://www.wegenerdm.co.uk/>

<http://www.wegenerdm.co.uk/>




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




=================================================
Disclaimer : The information contained in this Message is confidential and intended only for the use of the individual or entity identified. If the reader of this message is not the intended recipient, any dissemination, distribution or copying of the information contained in this message is strictly prohibited. If you received this message in error, please notify the sender immediately.

Oracle LazyDBA home page