Re: Porblem with Size in Oracle 7

If it's the maxdatafiles parameter exceeded you will have to recreate the controlfile to increase the parameter. You can instead run:  alter database datafile 'path\filename' resize XXXXM;

This way you can increase the datafile to hold more w/o recreating the controlfile.
If the database is growing fast this will be a very temporary patch.

To check the controlfile parameters run:  alter database backup controlfile to trace;

This will generate a trace file in your user_dump_dest like ORA00123.TRC and this will be the script to recreate the controlfile after editing the max parameters that are holding you back.

Matt-

BTEzra <ezra_at_telcom.es> wrote in article <6ocnfd$b9m$1_at_talia.mad.ibernet.es>...
> Hello,
>
> I've got a big problem with a table in which I can`t introduce any more
date
> in it... the problem is
> not due to data but to some kind of specified maximun sixe for the
> database... I would like to know how to expand the database or the
specific
> table but the problem is the Oracle server is very old.. What can I do?
>
> Please respond to daniel_at_bauer.es
> thanks
>
Received on Mon Jul 13 1998 - 07:43:57 CDT