alter database ... MAXSIZE UNLIMITED query
iinfiOct 9 2008 — edited Oct 10 2008i m practicing and learning Oracle on my windows machine. using Oracle 9.2.
i created a database manually and later created a tablespace using
create tablespace tbs1
datafile 'D:\oracle_databases\bkp1\datafiles\tbs1' size 150M
reuse autoextend on maxsize unlimited;
i configured enterprise manager to use the new db with it.
for the datafile tbs1 under storage i find that the maximum size is given a value as 16383M.
where does this value come from.
later i fire the command
"ALTER DATABASE
DATAFILE 'D:\ORACLE_DATABASES\BKP1\DATAFILES\TBS1' AUTOEXTEND
ON MAXSIZE UNLIMITED"
still the enterprise manager jumps back to storage maximum size value 16383M.
can someone tell me where this standard value of 16383M comes from.