All,
I have an application in which i have to serialize an C++ object in
Oracle DB. This object has 100 properties and all properties have to be
stored in different tables. These properties can be added/deleted at

Has anyone had an opportunity to implement RAC on AIX 5.2 (64 bit)
running Oracle 9.2. I would be grateful if you could please share your
experience.
I also need to know what the operating system-dependent (OSD)

I have a 7.3.4 database on a Solaris 2.5 server (32 bit) I want to
export and import into a 10gR2 database on Windows 2003 (32 bit). Since
Solaris 2.5 and 7.3.4 has a limit on 2Gb files, I usually use pipes to
transfer exports between servers, but I dont know how to resolve this

I am running this statement and got  not get what this output means .
At each step in the plan the cardinality is not what is actually
returned.
for example at Step 0 Card = 412

I am relatively new to Oracle and am assigned to determine the spec for a
few servers to house Oracle databases. I need your help in shedding a light
on the factors involved in making a wise decision for the features and specs
of the servers.

I have a java program and I'd like to call a stored procedure or create
triggers on oracle, can I use OCI for this ?
thanks
best regards

I am trying to do a 'create table as select' to create a remote table,
but I am getting the error "ORA-02021 DDL operations are not allowed on
a remote database".  Is this operation at all possible?  The error
seems to say no but I've read and been told that you just need the

I would like to convert a date value in a select statement to the
session timezone.  I know I can use NEW_TIME with the timezone
abbreviations, but dbtimezone and sessiontimezone returns offsets
(-05:00 for CST etc). not timezone abbreviations.  Since I want to

I have a table with three fields:
f1, f2, f3
1 a 432
2 b 323

Why would a query of  all_constraints cause  7 million consistent gets
and take nearly two minutes ?
On a similarly configured instance it only takes about 700 CGs and 0.02
seconds.

We are planning to upgrade our Solaris box, running oracle 9.2.0.5,
from solaris 9 (5.9) to 10, this to take advantage of better TCP/IP
stack on Solaris 10 , and the Network trunking feature, multiplexing
network cards to same IP, which is non-standard in Solaris 9.

I'm new to the oracle world and trying to find out the size of my
oracle database. I ran the query as below and not getting the correct
result back. Any pointer please??
SVRMGR> select sum(BYTES) from DBA_DATA_FILES;

Dear group,
we are currently building a database cluster with Oracle 10g on two
Primepower 250 machines. Our goal is to start with small hardware
equipment, because of the costs, but to be able to upgrade the equipment

Please help me resolve the error above. I'm new to the Oracle world and
not sure how to get this done.
Here are the results from the v$access view.
SVRMGR> select * from v$access;

I'm using a Java Stored procedure to do some processing in a Oracle 9i
database. The Java Stored Procedure takes several string parameters.
The Java Stored Procedure returns string data to the calling PL/SQL
Procedure.