Can datafile size is more than MAX_SIZE of tablespace
1004521May 30 2013 — edited May 30 2013Hi everyone ,
I am using
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
and i have increased the size of user01.dbf file size
SQL> alter database datafile 'D:\APP\NAVEEN\PRODUCT\DATABASEFILES\PROD\USERS01.DBF' resize 3100M;
Database altered.
SQL> select name, bytes from v$datafile;
NAME
--------------------------------------------------------------------------------
BYTES
----------
D:\APP\NAVEEN\PRODUCT\DATABASEFILES\PROD\SYSTEM01.DBF
1048576000
D:\APP\NAVEEN\PRODUCT\DATABASEFILES\PROD\SYSAUX01.DBF
786432000
D:\APP\NAVEEN\PRODUCT\DATABASEFILES\PROD\UNDOTBS01.DBF
57671680
NAME
--------------------------------------------------------------------------------
BYTES
----------
D:\APP\NAVEEN\PRODUCT\DATABASEFILES\PROD\USERS01.DBF
3250585600
D:\APP\NAVEEN\PRODUCT\DATABASEFILES\PROD\EXAMPLE01.DBF
104857600
D:\APP\NAVEEN\ADMIN\NAVEEN1.DBF
52428800
6 rows selected.
But in tablespace description MAX_SIZE is showing as 2147483645
SQL> select tablespace_name, max_size, contents from dba_tablespaces;
TABLESPACE_NAME MAX_SIZE CONTENTS
------------------------------ ---------- ---------
SYSTEM 2147483645 PERMANENT
SYSAUX 2147483645 PERMANENT
UNDOTBS1 2147483645 UNDO
TEMP 2147483645 TEMPORARY
USERS 2147483645 PERMANENT
EXAMPLE 2147483645 PERMANENT
NAVEEN 2147483645 PERMANENT
7 rows selected.
I am just confused with this , can anyone help in this matter please ?