Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.2 - db_files - increase

Re: Oracle 7.2 - db_files - increase

From: Benoît Bouthillier <Benoit.Bouthillier_at_loto-quebec.com>
Date: Wed, 09 Sep 1998 14:35:06 GMT
Message-ID: <umwJ1.217$Ni5.382834@198.235.216.4>


Hello,

            you have to recreate the control files. To do so:

  1. issue the command "alter database backup controlfile to trace;"
  2. find the *.trc file and copy that file under a proper location and name
  3. update the values for db_files
  4. connect internal and submit the script

            I suggest you to take a backup before and after, as usual.

Benoit Bouthillier
DBA - Loto-Quebec

lauritzen_at_my-dejanews.com a écrit dans le message <6t5v7q$2k1$1_at_nnrp1.dejanews.com>...
>How to increase the number of data files whitout reinstall oracle?
>
>OS:AIX 4.01/ HW:RISC/6000
>
>Thanking you in advance,
>
>Regards,
>
>Søren Lauritzen, Denmark
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Sep 09 1998 - 09:35:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US