RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Yexley Robert D Contr Det 1 AFRL/WSI
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Yexley Robert D Contr Det 1 AFRL/WSI
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

9i R2 not automatically starting up after upgrade

2002-06-13 Thread Yexley Robert D Contr Det 1 AFRL/WSI
I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm

Numeric comparison in DECODE statement

2002-05-20 Thread Yexley Robert D Contr Det 1 AFRL/WSI
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Trigger or ????

2002-05-14 Thread Yexley Robert D Contr Det 1 AFRL/WSI
Title: Trigger or Create a stored procedure that resets your sequence number, and then run that procedure at the necessary time each night using dbms_job to schedule it. Look into the Supplied Packages Reference for your version of the database for specifics on usage of the dbms_job

RE: Sqlplus Auto-trim Whitespace???

2002-04-05 Thread Yexley Robert D Contr Det 1 AFRL/WSI
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Latest patch for 8.1.7.0.0 (Win2k)

2002-02-06 Thread Yexley Robert D Contr Det 1 AFRL/WSI
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538