I'm new in oracle. I would like to control which user modyficates which
tables,etc(mainly jppm by hibernate). I tried to configure audit such way:
   I set value AUDIT_TRAIL = true  in
%ORACLE_HOME/admin/<myDatabase>/pfile/%init.ora (it dosen't work. After

Please, can you confirm the license model ...
If I have two databases in a 2-way server
1) if I choose CPU model
I have to pay for 4 CPU  (  nb CPU * nb DB )

We are a Resource Management Company providing Resources to a lot of
CMM Level 5 companies both in India and Abroad.
Now one of our clients: a US based  a CMM Level 5 company which is
involved in providing ERP solutions in Oracle, SAP etc require the

I have 4 columns (Doc, Date, FT, IRD).  Trying to create a query that
will set the IRD column to 1 else set it to 0.  The criteria to set IRD
to 1 is for each FT/Doc combo, find the oldest date within that group
and that should be set to 1.

we have an Oracle 10 (version details below) on Linux (RHEL 4).  When
connecting via JDBC we get intermittend ORA-12519 (reflected as TNS-12519
in listener.log).  sqlldr also has a problem, although at the moment I
can't exactly determine whether it's the same (I'm guessing it is ...

Dear DBA,
You are cordially invited to test and review our windows native and
100% pure Java Oracle 10g Monitoring & Security Application (Xg).
Xg is  the Ultimate Visual Real Time Oracle Monitoring Tool. As the

       Daniel Morgan and the Tragedy of OMLET: The Prince of Masshole
       =================================================
       This is the tale of Daniel Morgan,
       Who had a tiny ORAmance and clit-ormance,

We are a Resource Management Company providing Resources to a lot of
CMM Level 5 companies both in India and Abroad.
Now one of our clients: a US based  a CMM Level 5 company which is
involved in providing ERP solutions in Oracle, SAP etc require the

Hi NG,
generating the estimated execution plan of my queries, I use "explain plan
for"
and then select the information I am interested in from the plan_table.

I have a 'NAMES' table:
NAME    COLOUR    FROMDATE     TODATE
Fred        Green        01-JAN-2006    04-JAN-2006
Bob        Red            07-JAN-2006    09-JAN-2006

I'm running some debug code in a program in C++, and I have a grid that
returns the results of any SQL statement that I care to enter on
screen. I can see the results of a select query, or I can execute a
command (such as delete), but in the latter case I can't see any

I am desperately trying to find out how to recover a single tablespace
to a specified point in time.
I got an scp from "list backup;"
so I am trying

I have created a view on the database.
Now can I see, somehow, when I updated/created the view.
(system tables or something).
Thanks :)

I have a db layout as defined below. It contains 1 main table, 2 helper
tables and 1 view.
The problem is that the view is a little bit slow. It means that a
select ID from the view takes 4-6 times more time than the select ID

I have installed Oracle 9i client on Windows Server 2003, and able to
work with SQL Plus. But when I try to connect to the database
programmatically, (I am using Microsoft Oracle .NET Data Provider with
the connection string "Data Source='dev1';User