hello forum,
i know about DBMS_OBFUSCATION_TOOLKIT in 9i. but, is there anyway to get the
10g|11g DBMS_CRYPTO stuff for 9i? for example, if i get a hold of
{ORACLE_HOME}/rdbms/admin/dbmsobtk.sql from a 10g/11g installation, would it

I installed oracle 10g on my system the installation was successfull
but in the enterprise manager console
1.database instance is down
2.Listener is up and running

Problem Statement:
I’ve written a Stored Procedure which has several insert statements.
After inserting these statements ,its calling other stored procedure
which again has some insert statements. Now if the second procedure

Is it possible to download somewhere JDBC Driver 8.1.6 ?
I would need to connect an old Oracle 7 database
(The oldest one I found is 8.1.7)
Thanks in advance.

I have a problem with a script that ran OK with 9i but which does not
work with 10G
Here is the output:
SQL> @tmp

    My proc program report a ora1801 error. My code is like this
-----tblPdspTxnMon.h------------
typedef struct
{

With reference to my other post on various SYS packages being
unavailable, I now know the cause. Despite my declarations of
confidence, it turns out that one of our guys (a student on work
placement as it happens) wanted to create a public synonym and called

DB2 allows one to select from an insert, update, or delete, e.g.:
select * from old table (delete from x where y = 1);
--OR--
select * from new table (update x set y = 1 where z = 2);

I'm having a problem with oracle 11g:
Once in a while system runs jobs named something like in a title.
Those are very resource intensive and in my case last for 4-5
minutes.

I am facing a strange problem....
Every night, tables in my database are getting analyzed automatically.
I have checked, our job is configure only for Sunday, not daily.. but
it is happening daily

I've an 8.1.7 oracle home on an xp pc.  I installed OEM 9.2.0.1 of
client cd.  I created repository tablespace and user and granted
recommended roles.  i changed my oracle home to 9.  I imported the
database tree and after I enter the login and password I get a popup

I am using 10g. I want to test a few queries and have a look at the
execution plan. But I cannot find where is the tool. The tuning tool
seems only applicable to the most used queries in the database, but
not any one.

I'm looking for increasing my database performance, I ve just noticed,
in a heavy query that using substr instead of like is very faster :
350ms vs 30s !!
But in the other hand, when i count all the element in the table with

10gR2 on Windows 2000
All running absolutely fine. We develop applications using OHS /
mod_plsql.
Suddenly we got a "page not found" error in the browser trying to

I am trying to run a long sql script that creates tables, triggers and
procedures etc.
I ran the same script on 9i some time ago and it worked OK - but 10G
barfs on  CREATE OR REPLACE VIEW as follows: