is the utl_file_dir parameter required to be identical for all
nodes(instances, 1 per) in a RAC cluster?

I have  a table with 17M rows, and a B-tree index with 13M unique
values, and clustering factor almost as large as # of unique values.
Oracle bypasses the index when querying on the field, and if I force it
to use the index will run forever.

I would like to know what's the best way to validate or manage an error when
connecting on a Oracle DB with oci_connect from php 5.
For instance with:
$c1 = oci_connect("stephane","password",$db);

 Is it possible to use Oracle's RMAN (Recovery Manager) utility to
create backups to Sun DLT 7000 tape drive or do I need to download and
install any media management software? Can the backups be taken without
any added configuration?

URGENTLY LOOKING FOR A BEA WEBLOGIC PORTAL DEVELOPER --- i can manage
interview today itself, this is a sure shot closure . Please find the
req. below : -
location : - Iowa

I am not an Oracle Developer so please bare with me n the terminology.
I am a Crystal Reports Developer and I was told to create Stored Procs
instead of SQL Queries for the report. Everything is working great. Now
my manager and the Business Users wants to know how much time does ...

Hi there - if an Oracle account that has privileges to create a database
link tries to run a stored procedure owned by the same account and
whilst connected to the same account, why should one get an
"insufficient privileges" error / what privileges might be required?

I am having following table
09:48:42 SQL> desc t
Name                                      Null?    Type
----------------------------------------- --------

Well, yes and no.
I have a table which had a column (myLongField) of a long data type. I
dropped the the column without error, but when I try to replicate this
table, it comes back saying illegal use of Long data type.

I am calling a procedure(order) from a calling procedure (caller).
Order uses an In out parament (Ser_no)
Order is supposed to return a serial number.
how can i copy the value returned by Order to a local variable of

I am wondering if there is a way that you can get the SQL query string
that triggers the Oracle Trigger.
what I want to do is to write a INSERT/UPDATE trigger for all the
tables, and in the trigger i will call a java function that will do

Ten days ago I asked what goes on when you create a mat. view
(*even* without building it) and why so many locks suddenly
appear THAT DON'T LOOK RELATED to your mview creation, yet
are systematic, and why it makes so many sessions hang. All

We are having a problem with installing App server 10g (9.0.4) on AIX
5.3...
Compatibility matrix shows it is certified with AIX 5.2 and 5.3, yet
the installer gives us:

I want to move a tablespace from one instance to another, they have
different names.
Ex: user test_user with tablespace test_user_data, want to move this to user
prod_user with tablespace prod_user_data.

Is it possible to grant create view for owner only on tables in some
schemes for example po, pu.
Maybe user can grant creating views for owner on his objects? I know
that user can grant object previliges on his objects, but is he able to