how to change the path of all dbf files once database installed...
Hi All,
I m using 10g Database...
During my DBCA installation I forget to change location of the database files, redlologs and control files... and my Database is successfully installed. Now, I want to change my all these above mention files location And also adump,bdump,cdump and udump...so what I did is
1- create pfile from spfile.
2- Shutdown immediate.
3- from OS level copies all files to new location.
4- Editing in pfile
5- Startup with new pfile and check all the locations...
for datafiles
SQL> select FILE_NAME,TABLESPACE_NAME,STATUS from dba_data_files;
(this shows me the older location not new one.)
for controlfiles,adump,bdump,cdump and uduump
SQL>Show parameter...
6- create spfile from pfile .
pl. suggest me what should I do for the datafiles?
Thx,