).
--
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
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
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
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
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
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
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