I wanted to know if Oracle provides any notification framework similar
to SQL Server Notitfication Services.
i.e.-  Does Oracle provide framework and API to send notifications to
users thru channels like email, SMS etc when the event of interest of a

I rand a script to check the health status of my database and it reports a
problem with some foreign keys where the referenced columns and the
referencing columns are of a different data type.
My question is:

We have just set up a second environment on the same server to test an
upgrade.  We set up a separate listener because we want to be sure we
are running the new version of the listener in the test environment.
We have it running, but I'm not 100% sure if I really have 2 separate

I need to perform queries on Oracle database from C/C++ program on
Solaris. I have very extensive experience with C/C++ and MS Windows OS
but close to none with Solaris or Oracle. Our database adminstrator
told me that we do not have any documentation, he does not know if we

want to connect as sysdba to an oracle 10g database using isqlplus. It's
 not possible to do that, because SYSOPER and SYSDBA are not available
in the connection dialogue. Instead there's the following phrase:
"Require WebDBA role and HTTP authentification"

I am curretly trying to set up two RH3 servers using VMWARE running
under win2003 server. I have installed one RH3 already and trying to
install secon one today. I would like to know if it is possible to
create raw device for these two nodes so I can install CRS and ASM.

It is asked to me to reduce the time of creation
of datafiles during a reorg:
some tablespace are created with 50 datafiles of
20 Gig, Is it possible to parallelize

I want to calculate the difference of days between records. Therefore I use
an update statement:
UPDATE TEST A SET DAYSTONEXTDATE = TRUNC((SELECT MIN(STARTDATE) FROM TEST
WHERE STARTDATE > A.STARTDATE)) - TRUNC(A.STARTDATE);

Not an Oracle DBA by any means, but I have an Oracle 9i database I need to
back up and want to use rman.  So I need to enable auto archive log.  I want
to make sure my steps are correct.
I will use the Enterprise Manager Console to enable Auto Archive, following

Summary: I am having a problem passing a value of a plsql variable to
an external Unix shell script using extproc.
I am using the Oracle suggested method of creating and executing
external procedures via extproc by creating an Oracle Library, function

I have a query where a function calculates a percentage.  Now I just
want to get the answer rounded to the nearest 10ths.
Example:
sum(c.pp_hours/b.hours*100)||'%' as Percent_pp

We are looking at switching oracle licensing options from Enterprise to
the Standard-One.
Aside from licensing issues, does anybody have any information about
what is involved to accomplish this? Is it relatively straigthforard?

I'm not really sure where to post this as I'm not really sure where the
problem lies, but I THINK it may be an oracle problem:
I have a problem with certain select statements hanging (either
retrieving several hundred rows than just stopping on the same row

  Scenario:
    1. We have a WinForm application using .NET that creates Sql
statements to be executed.
    2. We have an Oracle database 8i.

I'lm trying run the Object Type Translator ott.exe in order to obtain
type definitions for my SQLT_NTY columns, for a later use in a C++/OCI
app.
Unfortunately, ott in command line only outputs the message :