help!!

[cravi]

Hi Carp

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

Thanks
Ravi
_______

[denevge]

You have to recreate you controlfile with changed maxdatafiles parameter.

Gert

[TerryD]

Follow these steps to recreate your control file:

As SYS;

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.

Run:
svrmgrl
connect internal
@/patch/control.sql

**Shut down the database and take a full offline backup**

Hope this helps

Terry.

-------------------
Refer to below for more info:

[url]http://support.oracle.com.sg/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=30598.1[/url]

[url]http://support.oracle.com.sg/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1012929.6[/url]