Why would DBA_FREE_SPACE not reflect the same as what OEM is showing
me?

I've installed Oracle 10G Enterprise + Client + Companion on a SuSe 9
server and none of them installed the Pro*C demo files, i.e.
ORACLE_HOME/precomp/demo/proc/demo_proc64.mk, etc.. I must recompile
our Pro*C apps and can't without these files--or I don't know how.

I am using 2 tables: an Order Header and Order Detail. The problem that
I keep running into is for a request to pull some criteria based on the
detail lines, then display all the lines for orders meeting that
criteria.

How about we revise the charter to exclude the clause on top posting.
Apart from some users preferences, and perhaps a weak argument about
bandwidth, why is their so much aggression about top posting?
Regardless of what the charters for this newsgroup say, people are

CREATE TABLE "UPD"."SELECTED_NODES" ("SEQ_I" NUMBER NOT NULL,
   "NODE_I" NUMBER NOT NULL, "LABEL_S" VARCHAR2(1 byte),
   CONSTRAINT "PK_SELECTED_NODES" PRIMARY KEY("NODE_I")
   USING INDEX

Hi . i'm new to this area . i i need some one help .
We discovered important process missing in our operation and
implementation, and we consider it as new requirement which is :
We need to find away how we could be alerted if new items arrived at

I'm working with an oracle 9i server and I already created :
A new role
A new tablespace for datas
A new tmp tablespace

In a related story, Danny the wanny: DA Morgan get his balls inflated
to match the
above mentioned.
and it seems that Oracle finally fixed their shitty PL/SQL so the

Is there anything like certified hardware for Oracle Database Servers?
I thought it's mainly a matter of the operating system. but now
somebody told me, it's better to stick with IBM-servers, as they are
certified by Oracle, and other vendor's servers are a problem. I

I'm trying to connect to a specific Oracle instance on my localhost.
If I do:
- sqlplus connect as system/passwd@instance as sysdba
should that connect me?

I know how to change user's session nls_date_format with alter session, but
I want to alter default database nls_date_format. I tried a :
alter database set nls_date_format='yyyy-mm-dd hh24:mi:ss';
but I doesn't work. (ORA-02231: missing or invalid option to ALTER DATABASE)

I'm soon going to be moving a couple of db's from separate servers and
consolidating them on one new server. One is currently on 8.1.7.4 and it
will be no problem as I will just export/import it into the new 9.2
database. The other one though, is currently running on 9.2.0.5 and ...

Oracle 9.0.1 Std Ed. on Win2003 Server Enterprise edtition
The tnslstnr service is crashing every 3-5 min.
What it can be?

I have been searching about 4 weeks for an answer to resolve this
error. The error text reads, "unable to open or write to file". This is
occuring only on 4 files that are being read from the directory. From
what I have seen on other postings it appears to be something that

Since few months I have an Oracle database 8.1.7  working under Win2003
server SP1. s
I have modified the listener port too, for more security.
All is working fine. But sometimes, I have some error in the Windows's