Oracle 10.2.0.3.0; Windows 2003 Server
These selects are against a table with over 3 million rows. SRV_DATE_FROM/
PERSON_ID/ SERVICE_TYPE_CODE and DATA_SOURCE comprise a primary key on a
table the rows from these selects will be loaded into.

I have been asked to put together a list of requirements to stand up
an Oracle Business Intelligence installation.  After poking around
MetaLink I find I'm just spinning my wheels trying to determine which
of various editions of BI we would want, and what database options are

10gR2 EE (10.2.0.3.0) /Solaris
what is the "best" option to abort a running stored proc, dbms_pipe ?
thanks

"Spoliation" is the "intentional destruction, mutilation, alteration,
or concealment of evidence." BLACKS LAW DICTIONARY 1437 (8th Ed.
2004). Federal law, not state law, controls the imposition of
sanctions for failure to preserve evidence in a diversity case. See

hi ..i was new to oracle and i have a question...
suppose there are two users x and y say..
if user X grants previlages on a object O to y..
1)how can X know all the Objects he shared with all other users and

I'm working with Oracle 10, and it appears that exceptions do not propogate
from one package to another. Is this true, and if so, is there a way to
change this?

If i have the backup of the database (RMAN incremental backup) for a
particular date, eg: till yesterday I have the backup. Due to some reason ,
if restore needs, from which time onwards the archive redolog needs to apply ?
16-09-2007 3:00 AM: Backup incremental level 1 - finished ...

In the area of services configuration to get the maximum availability the TAF
/ FAN configuration by default it is TAF. Can any body help me to get the
difference between TAF and FAN.
Thanks in advance.

I'm trying to email several addresses. My script works great when it's
only going to one address, but if I attempt to send to mulitiple
nothing get's sent. I've tried delimiting them with space, comma and
semicolon:

I've got a Problem with COMMENT ON TABLE and COMMENT ON COLUMN. I
exported and imported a User scheme and now i have
some comments on the wrong column. It seems, that this Problem happens
only on tables where columns from datatype

We have many unix (hp-ux, AIX, Linux, Solaris) servers running Oracle
database 9.2.0 enterprise edition. Each server has 4 or more
databases. Currently each unix server has its own tnsnames.ora in /etc
folder and all windows machines TNS_ADMIN is pointing to a shared

Hi people,
is it possible in Oracle9i/10g to grant a user permission to see the
code of someone else's procedure but without the permission to execute
this procedure ?

Solaris 9
Oracle 9.2.0.1.0
I hoping someone can help me out with this. I have just tried to
duplicate a database using RMAN however, I made one fundamental error

Hi, we have an application running with OracleXE 10g on Windows.
It's not unusual that the application runs in the same pc which host the db
server.
It happened that, after a sudden crash of the system and after the windows

Consider following situation:
1. A application connects to Oracle database using JDBC
2. The application starts a JDBC transaction
3. One of the query takes very long (more than an hour) to complete