'oracledba-[Email address protected] doesnot work

JUNK JUNK JUNK

-----Original Message-----
From: Paul Walker
[mailto:oracledba-ezmlmshield-x38985979.[Email address protected]
Sent: 30 July 2004 14:39
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





Oracle LazyDBA home page