Oracle v. 8.1.7:
I have a situation where some constraints are set to INITIALLY DEFERRED, as
data within the transaction may come in an 'unpredictable' order.
Is it possible to check whether a COMMIT will fail or succeed without

All,
We have a couple of snapshots that had the rollback segment defined.
As we have upgraded the 'master' database to 9i, we've gone the
'automatic undo' way.. Although we have the undo_suppress_errors set

Platform: Ora 9.2.0 on Solaris 8
Digging into the guts of extended trace, working with Tom Kyte's and
Cary Millsap's books.  Using MTS, so I know session traces will be
potentially scattered across multiple trace files in the bdump

I am using Oracle security for my application and would like to allow users
to change their own passwords without using SQLPlus.  I am attempting to use
"ALTER USER username IDENTIFIED BY newpassword REPLACE oldpassword" in a
stored procedure to provide this functionality, but it ...

How can I create and manage standby database for Oracle10g standard edition?
Data Guard is not available for this version.
Could someone point me to detailed documentation (or howto or someth) for
standby configuration for standard edition, step by step?

Select from V$SGA_TARGET_ADVICE fails on Oracle 10.2 for Linux.
The error reported is about division by zero:
SQL> select * from v$sga_target_advice;
select * from v$sga_target_advice

I'm trying to do a local install of an Oracle 9.2 client on a Solaris 9
box.  This box already has the /var/opt/oracle/oraInst.loc file set,
but I want to perform a separate install.  However, when I start the
interactive installer I get this error:

I've looked through the archives of the group, and seen lots of posts
on this, but none have solved my problem yet.
I have the Oracle 9i client installed on a machine, in order to provide
connectivity to a SQL-Server box. I will be creating linked servers in

I use Oracle 9i Release 9.0.1
I am facing a problem in one of my stored procedures. The execution is
too slow. I have taken an extract from the procedure into a PL/SQL
block

I am getting:
ERROR: ORA-01034: ORACLE not available
ORA-09243: smsget: error attaching to SGA
OSD-04101: invalid SGA: SGA not initialized

I use Oracle 9i Release 9.0.1
I am facing a problem in one of my stored procedures. The execution is
too slow. I have taken an extract from the procedure into a PL/SQL
block

I just inherited a Java application with a fairly complex data model
that does not yet have any indexes except those on primary keys. It is
still in development and before I get to do any performance testing I
want to put some default indexes on it. I realize that this a very

Is there any parameter that defines the limit on the number of records
to be read through a cursor (using OCI APIs)?
We have had a problem a couple of times when after a certain limit,
oracle starts throwing following error: ORA-1455 (saying something

Environment: Oracle 10g (10.0.1.4), MS Windows Server 2003.
I can not get my stored procedure to process an "IN" clause passed
parameter:
create or replace function GetRoles(APP_NAME  IN VARCHAR2,

I have programmed a shell script to do the backup to server Oracle on
linux system.
Here it is the script
'--