Q:Is it allowed to change maxbytes in table dba_data_files

Hi ALL,

we are running Oracle 8.1.7 on SuSE Linux. Some of the datafiles in some tablespaces was created with autoextend on and no maxsize set. So Oracle write a MAXSIZE of 34GB. Linux runs with ext2 and the limit of filesize is 2GB. Sometimes, if nobody looks at databasefiles (ok, no comment please), they growing up over 2 GB and crashs the tablespace. The only way out is to recreate the whole tablespace from existing export. So, is it possible simply to change the maxbytes value for each databasefile in dba_data_files to the maximum of Linux? Nothing else to do? Must Stop/Start the whole database? Has someone expierence with that workaround? I can't find something in FAQ or documentation. If so,this would help us to work with. Also if the filessize of 2GB reached. Always better than overrun the maxium filessize of Linux and to recreate the whole tablespace. Ok, I know that is possible to set autoextend off, but the other way would help us more than doing this...and of course in future create databasefiles with the maxsize of 2 GB.

Thanks a lot for helping
Ralf Received on Mon Jun 17 2002 - 15:39:28 CDT