| Database [message #102998] |
Wed, 08 January 2003 07:55  |
Eras
Messages: 1
Registered: January 2003
|
Junior Member |
|
|
Please help,
I have a database on drive C: (Home - C:ORANT). I need:
1. Install new Oracle server on drive F:
2. To move database to F: drive
3. Uninstall Oracle server on drive C:
Can anyone help me with suggestions about that
|
|
|
|
| Re: Database [message #103013 is a reply to message #102998] |
Sun, 12 January 2003 10:28  |
Sravani
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
If you want to unintsall the oracle in c:orant you can go ahead and do it.
BUt you can have two oracle homes in both c: and f: directories.
To move the database from c: to f: drive:
i) bring down the oracle database running on the c:
ii) copy/move the database files physically from c: to f: drive
iii) create the oracle service using the new oracle home with the new db name
iii(a) edit the init.ora and config.ora files to correct the location of the copntrol files etc..
iv) start the database in mount state
v) change the location of the db /log files
start the database
vi) alter the database and mount it
vii) shutdown
viii)start
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
