Re: problem in Oracle 10g window 7
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 30 Jan 2010 19:15:46 +0100
Message-ID: <edc38$4b647751$524ba3af$30777_at_cache1.tilbu1.nb.home.nl>
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 ........email on
> mubashir_farooqi_at_yahoo.com thanx
Date: Sat, 30 Jan 2010 19:15:46 +0100
Message-ID: <edc38$4b647751$524ba3af$30777_at_cache1.tilbu1.nb.home.nl>
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 ........email on
> mubashir_farooqi_at_yahoo.com 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