Re: problem in Oracle 10g window 7

From: Frank van Bortel <>
Date: Sat, 30 Jan 2010 19:15:46 +0100
Message-ID: <edc38$4b647751$524ba3af$>

Mubashir wrote:
> hi all i wanna ask a question. ihave created a database in drive d.but
> due to some reason i m transferring it to drive E.. now when i
> transfer it ,it donot work even if i vhange the locations in
> pfile.....if somebody has the solution on
> thanx

Oracle keeps that kind of data stored in a control file. You could recreate your control file, or just move your data files.

As you level of Oracle knowledge seems close to zero (no pun intended), I suggest:
- make a backup: shut down all oracle services from the Windows

   services (used to be in the Control panel). - copy all files, related to oracle to a safe location - search the internet for "Oracle move datafiles"

  • As an alternative, do a "backup controlfile to trace" and take it from there. Regard it as a learning experience --

Regards, Frank van Bortel

Topposting in Usenet groups I regard as offensive - I will not reply Received on Sat Jan 30 2010 - 12:15:46 CST

Original text of this message