i posted the following message in another gorup - but maybe someone
here knows the answer ?
thanks !
***********************************

Anyone have a rough idea how much RMAN costs for US customers?
Our company has been buying the Oracle 9i Database Enterprise Edition
for our Oracle clients but they do not include the RMAN product (or at
least we never use it and I was told that it was because RMAN used to

---------------------------------------------------------------------------------------------
CREATE OR REPLACE PACKAGE BKDP_SEARCH_PKG AS
   TYPE BKDP_Cur_GetAccts IS REF CURSOR; --RETURN BKDP_Rec_GetAccts;
  PROCEDURE SP_BKDP_ACCOUNTSEARCH (param_account in

I am building reports for a migration project on an Oracle 10g database
server.  I have built all my reports with text queries in Visual Studio
.NET and setup my data source connections there, and all the reports
work great when I preview them there.  Once I upload them to Reporting

I'm trying to connect "/ as sysdba" (without using a username or password) as
the documentation says
http://search.cpan.org/dist/DBD-Oracle/Oracle.pm
I can connect as follows:

Can somebody suggest, what could be the problem and how I should start
investigating it ?
When I try to save the data through forms it is taking 2 minutes and 30
Seconds for each save.

I installed Oracle 10g Enterprise Edition.  However, I can't find the
OEM GUI that I'm used to.  Anyone know how to get to this?
Thank you.

oracle ent ed, 9.2.0.5, dmts, compatible = 8.1.0 AIX5L
How can you use explain plan with a plan table that is named something
other than plan_table?

BACKGROUND:
============
We have seven Oracle systems that have been running on Oracle 8i
(8.1.6.3) Enterprise Edition with AIX 4 32-bit. They are slowly

I am considering writing a table function to return a row for each
calendar date within supplied data range.
Here is the SQL:
SELECT to_date(day_year_seq||'-'||year,'ddd-yyyy'),day_abs_seq

Thanks in advance for reading and any posts.
We have just recently upgraded/patched our way to 11.5.10 on Oracle
Financials with a 10g database on the background.  Anyhow I was
wondering if anyone knows of a quick way to work out if there are any

We are running a 9i production database in which the parameter
PGA_AGGREGATE_TARGET is set.  By setting this we are enabling automatic
memory management and thus, supposedly, disabling the usage of the
*_AREA_SIZE parameters.

I posted a month or so ago asking if anyone knew about
the status of Oracle Standard Edition for VMS. Metalink
says that Oracle 10gR2 Standard edition is "not planned"
for VMS on any platform (VAX, Alpha or Itanium). Of course

I'm trying to call a procedure within a package, which inserts a row into a
table.
However, I'm getting the following error:
"SQL execution error, ORA-06550: line 1, column 22: PLS-00302: component

I am looking into analytic functions to solve a Top-N query problem, so
I've been looking at some examples to understand how they work. I can't
seem to get the examples to behave the same way on my Oracle
installation, so does anyone have any idea why the following isn't