In my init.ora the db_files=20
In my controlFile Maxdatafiles 20
In my database we already had 19 datafiles.
Now i want to add 3 more datafiles.
Databse : oracle 7.3.4
OS : Windows NT
Could you please let me know what should i do in detail
You have to recreate you controlfile with changed maxdatafiles parameter.
Follow these steps to recreate your control file:
SVRMGR> alter database backup controlfile to trace;
Shutdown the database (immediate or normal - not abort)
*** Take a Full Cold Backup ***
Goto your user dump dest and find the control file produced by the above command (will be a .trc file - sort by date/time to find).
You will need to move/rename your existing control files at this point - also make sure you have sufficient space to create new ones as they will be bigger than the old.
Modify this trace file (call it control.sql or something as well) -
Delete any header information prior to the words Startup nomount.
Increase your maxdatafiles parameter and save the file.
**Shut down the database and take a full offline backup**
Hope this helps
Refer to below for more info:
Click Here to Expand Forum to Full Width