How to move database to another drive
How can I move my database to another drive? I am working with Oracle 9.2 This is what I tried so far and have had no luck.
I
moved all the data files and log files to the new drive. ( I did not
move the control files) In the pfile I used the following parameters
db_file_name_convert=('C:\Oracle','D:\ORA')
log_file_name_convert=('C:\Oracle','D:\ORA')
When I try to start up the database I get an error saying it can't find any of the data files or log files.
Thanks in advance for any suggestions.
db_file_name_convert=('C:\Oracle','D:\ORA')
log_file_name_convert=('C:\Oracle','D:\ORA')
When I try to start up the database I get an error saying it can't find any of the data files or log files.
Thanks in advance for any suggestions.
0