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).
Received on Wed Jun 18 2003 - 18:42:03 CDT
