Re: Q: Is there a way to change MAXDATAFILES after Instance createion ?

Yes you can extend the number of datafiles.

This paramter is a PERMANENT database setting, continaed in the control files. in order to change it, you will need to rebuild your control files.

The procedure goes something like this:

Shutdown the database
Do a full backup
Edit init<>.ora file (add new # files)
Start up a new instance
Create a new control file (CREATE CONTROLFILE) Copy the new control file (For backup)
Edit the CONTROL_FILES parameter (add new file) Mount and Recover the database
Open the database

Hope it helps
Randy :)

Martin Pammer (mpammer_at_vlr.gv.at) wrote:
: Hi there
 

: We are using Oracle 7.2.2.4 on AIX 4.1.3.
 

: I have several databases which were all created with the default
: MAXDATAFILES of 20.
 

: After creating new tablespaces I am now coming close to the limit
: of 20 datafiles.
 

: My question is:
 

: Can I change the MAXDATAFILE after instance creation without
: recreation of the whole database ?
 

: Thank You very much in advance
 

: Martin Pammer
: mpammer_at_vlr.gv.at (VRZ Informatik in Dornbirn, Austria)

--
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I