This is a 6 months contract position. we need someone with strong
hands-on in ETL programming/data warehouse design/data modeling, Oracle
and Cognos backgrounds is preferred. You will assist in design/setup
data warehouse and BI solution from scratch.

<flame retardant>
i'm in the process of researching this but have not found anything yet, so
any pointers would be helpful
this is immediately applicable to R9.2

    I have a problem about Oracle 10g and a patched bug 1377901.
    Our system using Oracle 10g Win64 version and running a windows
2003 64bit HP. When I using this system, it sometimes report ora-12519
error, and when this error occurred, users can not connect to DB

Can anybody give me a list of pros and cons for keeping package specs
and bodies separate.
TIA

I cannot find any information on this message.   We have a 10g
environment that was just set up and we are regression testing
applications in the new environment.  I have several .trc files that
log this message and I am trying to find out if there's something I can

I tried to make a new installation of my old DB Oracle 7.2 on the new
Sco Openserver 6 but  "./orainst.sh" installation script doesn't work.
So I tried with bash command but also in this case, some errors "files
not found" were generated. I have uderstood also that the new Sco OSR6

Why do I get java.security.AccessControlException when using Java
Sockets in oracle to connect with other sockets

I would like to know if someone could help me with this topic, I'm
traying to analize and chek which Oracle Patches are appplied to an
Oracle DataBase Server

This is a 6 months contract position. We need someone with strong
hands-on in ETL programming/data warehouse design/data modeling, Oracle
and Cognos backgrounds is preferred. You will assist in design/setup
data warehouse and BI solution from scratch.

Why do I get java.security.AccessControlException when using Java
ServerSockets in oracle to connect with other sockets

I'm not quiet sure how "select for update" works in the case that I
execute a second "select for update" statement in the same process.
Imagine I have some records in a table locked by a first "select for
update". Then I execute a second "select for update" on other records.

I have a problem "joining" two tables.
One table contains data like S_ID, name, notes, created_date.
A second table S_ID, property_ID, property_value
For property_ID values from 1 to 10 are possible the meaning of the

we are currently struggling with quite a slow SQL-Statement. When we use
a Bitmap Index on 3 fields of the table, the SQL-Statement needs to
finish its operation approximately 30 seconds.
Now we changed the composite index to cover 4 fields and is not

9.2.0.6 on Windows
I am getting unexpected results from a statsoack output:
The 'physical reads' value in the "Instance Activity Stats" section is
as follows:

Hi everybody, I have a problem with Oracle 9i (and with english, be
patient).
I have an ASP page connected to an Oracle 9i database with this string:
Provider=ORAOLEDB:Oracle;Data source=pippo;User