Re: Q:Is it allowed to change maxbytes in table dba_data_files

Ralf Bender wrote:

> 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

Had you gone to http://tahiti.oracle.com and typed in as your search criteria "TABLESPACE AUTOEXTEND"
you would have had your answer immediately.

Since you didn't you had to wait for me to do it for you: Here is the search result.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem3a.htm#2057436

Hopefully in the future you will try to find the answer before asking someone else to look it up for you.

Daniel Morgan Received on Mon Jun 17 2002 - 15:43:23 CDT