> -----Original Message-----
> From: O'Neill, Sean [mailto:[EMAIL PROTECTED]]
>
> 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?
What dba_ view are you looking at? This will probably be of little consolation to you, but for me, dba_data_files immediately reflected the change in maxsize on a datafile in my test database (8.1.7 on Windows 2000).
SQL> select file_name, maxbytes
2 from dba_data_files
3 where file_name = 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF' ;
FILE_NAME
--------------------------------------------------------------------------------
MAXBYTES
----------
D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF
115344384
SQL> alter database datafile 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF'
2 autoextend on maxsize 300 M ;
Base de donn�es modifi�e.
SQL> select file_name, maxbytes
2 from dba_data_files
3 where file_name = 'D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF' ;
FILE_NAME
--------------------------------------------------------------------------------
MAXBYTES
----------
D:\ORADATA\SDJRK1\INDEX\INDEX_HUGE01.DBF
314572800
