mostly selects... but according to what everyone is telling me, if
there are any transactions in the database at all, it will prevent me
from making it read only
- Kirtikumar Deshpande <[EMAIL PROTECTED]> wrote:
> Will that be all DML activity?
> All the times?
> In a datawarehouse?
> In our data marts most activity is for just 'reading' stuff.... a lot
> of stuff locally... Not many
> active transactions.. So I can make TSs read only almost any time I
> want to..
>
> - Kirti
>
> --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > ARGH!
> >
> > Well, that pretty much kills the idea of using this for my data
> > warehouse as there is always activity in it. Dang!
> >
> > Okay, I'll try it from my laptop as I can control users there :)
> >
> >
> > --- Daniel Fink <[EMAIL PROTECTED]> wrote:
> > > Rachel,
> > > It is not active transactions against that tablespace, it is
> active
> > > transactions. Yup, period! As soon as all the active transactions
> > > complete, the tablespace will complete altering itself.
> > >
> > > Dan
> > >
> > > Rachel Carmichael wrote:
> > > >
> > > > there WERE no active transactions against that tablespace.
> > > >
> > > > The steps I took were:
> > > >
> > > > as system:
> > > > 1) create tablespace as an LMT
> > > > 2) create table within that tablespace
> > > > 3) attempt to make the tablespace read-only
> > > > when that hung I logged out (which certainly killed any active
> > > > transactions against that tablespace!)
> > > >
> > > > 4) log back in as / as sysdba
> > > > 5) attempt to make that tablespace read-only
> > > >
> > > > No one else knows about that tablespace, it's brand-new. No one
> > > else
> > > > has quota or access on the table I created.
> > > >
> > > > However, for completeness, I just offlined and onlined that
> > > tablespace,
> > > > then tried to make it read only. It's still hanging.
> > > >
> > > > Oh yeah, 9.2.0.1 on Linux
> > > >
> > > > Rachel
> > > >
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kirtikumar Deshpande
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jun 18 2003 - 20:32:15 CDT