We have upgraded all our AIX servers to Oracle 9i.  However there is 1
application that will not run on 9i and 8.1.7 is required. Our DBAs are
running both versions of Oracle on the same 2 servers.  We have 15
other servers that have been running with no issues and they are

OS: Windows NT 4.0 SP5
Oracle Version: 8.1.7
_____________________________________________________________
My database doesn't OPEN.  This is what I get.

I have a data structure that I need to represent
in a table.
It is a changelist, and the contents of the changelist
are either

I'm load testing an application and found that an oracle update query
made via JDBC by the app is taking between 2-20 seconds under 100 user
load.  With 1 user load the same query takes 0.05 seconds.  The query
is basically:

Just trying to find out if anyone has ever had this problem, and what
the issue was.
We applied the latest patch list night to our 50 servers.  This morning
two of the databases were down.

I have a table which is partitoned by range using a date column called
tarih. There exists also a bitmap local index on column dwh_isyeri_kod.
The below 2 queries , although does the same thing creates very
different kinf of load. The first sql counts all data by using the

My friend has a small pharmacy and wants his system to run on Oracl
database, currently he tested the Oracle 8i and works just right
He tried to ask for the license terms for the 8i version but reseller
said that support has been stopped for this version so there's n

It seem a 10.2.0.2 patchset is not planned yet.
Is 10.2.0.1 so bugfree? In the previous releases the first patchset
appeared sooner IIRC.

My query currently looks like this:
select user_id, count(*) total
from employeelog
where event = 'LOGIN'

we are building a DW which has Oracle Apps as one of the major inputs.
We would like to re-engineer some of the oracle apps tables into Erwin
as a starting point...we are using 4.1 of Erwin.
However, it does not seem to be giving me a choice of which tables to

I have a detailed question on Oracle iProcurement configuration where
should I post my query?
Thank you, Ned

I'd appreciate some feedback on this. I just did a fresh install of
Oracle 10g. I ran a script multiple times that dropped and recreated
tables, and then I noticed about 100-200 tables named like
"BIN$V3zj9aOWRImOT89aKyyVSg\=\=$0".

I'm in charge of setting up a new oracle installation, and I'd
like to read up access protection.  Any particularly good
resources to look at?
In particular, I would like to restrict some tables of

How can I validate an Oracle APPS password, version 10.7SC?
I am writing a custom application, and want to have the user provide the
same login credentials that they would if logging into Oracle APPS, then I
want to verify that they are correct.

I've got an application which deals with a bunch of
asset identifiers, which should all be NUMERIC(18).
Can I create a new data type or alias so that my
table definitions, etc, show a type of ASSETID rather