TS is showing 100% used in DBA Studio. DBA_DATA_FILES is showing MAXBLOCKS,
MAXBYTES values corresponding to filesize of 2000M which was what tablespace
was originally created with. Subsequently altered to 4000M with ALTER
DATABASE DATAFILE '<filename>' AUTOEXTEND ON MAXSIZE 4000M. I'm puzzled as
to why the DBA views do not reflect the 4000M. Can anyone explain what I'm
overlooking please?
Sean O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
Oracle 8.1.7 - W2K
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: O'Neill, Sean
INET: Sean.ONeill_at_organon.ie
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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 Fri Oct 19 2001 - 09:44:59 CDT
