Re: problem in Oracle 10g window 7
From: Mubashir <mubashirahmadcu_at_gmail.com>
Date: Sat, 30 Jan 2010 11:59:15 -0800 (PST)
Message-ID: <76e7a344-1c00-49e4-9d3e-35d0ccf75bec_at_s36g2000prf.googlegroups.com>
On Jan 30, 11:15 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> 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_faro..._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 - 13:59:15 CST
Date: Sat, 30 Jan 2010 11:59:15 -0800 (PST)
Message-ID: <76e7a344-1c00-49e4-9d3e-35d0ccf75bec_at_s36g2000prf.googlegroups.com>
On Jan 30, 11:15 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> 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_faro..._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 - 13:59:15 CST