Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to change the value of Sysdate

Re: How to change the value of Sysdate

From: David Sharples <davidsharples_at_gmail.com>
Date: Sat, 2 Jul 2005 23:41:43 +0100
Message-ID: <be592d5505070215412c6bf8fc@mail.gmail.com>


is it fixed now?

if not, create a pfile from the spfile without fixed_date set and use that to start the instance

On 7/2/05, Ram K <lambu999_at_gmail.com> wrote:
> Hi all,
>
> Problem: Database doesnt start.
> After playing with the fixed_date and then unsetting it with NONE
> option, I rebooted the machine later; tried to restart Oracle. Logged
> into sqlplus /nolog as sysdba then:

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jul 02 2005 - 17:43:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US