Re: max data files

Chris Kempster wrote in message <6ohnmk$ovv$1_at_news.cowan.edu.au>...
>Dont even try it. You should not modify any 'oracle kernal', ie. system
>tables. First of all you dont know how the internal structure operates and
>more than likely you will void any support from oracle.
>
>oh, v$ tables are vapour tables, ie. Views, look somewhere else :)
>
>The only way to change this parameter is re-creating your control files
with
>the alter database command and specifying a new maxfiles value.

In fact this is quite easy as the ALTER DATABASE BACKUP CONTROL FILE TO TRACE command will create you the sql script that will recreate your control files. Just edit in the new values you require.

MotoX.
>
>OR
>
>rebuild the whole DB from scratch.
>
>
>Good luck :)
>
>
>
Received on Wed Jul 15 1998 - 04:11:19 CDT