I am on solaris 9,Oracle 9i having 2g ram. 4g swap.
earlier i had only 1 db running on the machine so the changes made to
my /etc/system were as :
set shmsys:shminfo_shmmax=4294967295

OK... I finally have a window where I can mess with OEM.
I have a server with a bit of free space I would like to install the
respository on.  My environment is:
HP-UX11i

I am having trouble understanding the following states of a constraint:
Initially Immediate
Initially Deferred
NoValidate

I have a train's route table as follows (for one train):
LOCATION_I varchar2(6) not null
ORDERnumber not null
The table lists all the stations that the train goes through.

i am using the oracle 10g database
does anybody know how to create a diagram for views and materialized
views which a certain user owns.
under

Having spent most of the morning trundling through websites, some
blatantly not related, I was wondering if anyone may have any ideas on
how to go about this. I have a crib from when I used to do them as a
matter of course on version 7 and 8, but with the activation of spfile

CREATE OR REPLACE VIEW MYUSER.CLASS_VALUE
(
   TARIFF_CLASS,
   DESCRIPTION

I have in the Data Block Trigger ON-SEQUENCE-NUMBER
Begin
    IF :Global.Using_Transactional_Triggers = 'TRUE' THEN
         User_Exit('orderid seq=MEDORDER_ID');

I am using Oracle Universal Installer with the response file
clientuserapp.rsp (configured ok) from the response directory to
install Oracle client application user.
I have a problem during install - it gets to 95% and then stops - it is

I have the following procedure:
  TYPE testarray is table of int index by binary_integer;
  PROCEDURE testfast(par1 in testarray) is
  begin

I have been having a debate recently on another forum about database
market penetration and how to measure it.
My point of view would be that even for companies which *_only_*
produce databases (Oracle until recently, MySQL, say now), it is

Good afternoon believers,
A belated notice:
The PostgreSQL Global Development Group is proud to announce the release
of PostgreSQL 8.1, the world's most advanced open source database.

Group,
I wrote a function like this
------------------------------------
create or replace function test_function

I've installed Oracle 10g successfully on Windows 2000 Server, and o
Windows XP Pro... with no problems at all...
But I couldn't start the database on Windows Server 2003, th
OracleDBconsole and Oracle...TNSListner refused to start

here are two tables in ORACLE
create table country
   (
     ctry_id number(11),