hp-ux 11.23 Itanium, Oracle 10.2.0.4
I ran Oracle's rda tool (rda.sh -T hcve what they call a database
health check, they robotically ask for it with support calls), and it
tells me semvmx is too small.  I have it set to 32767 as the install

I'm looking around for Oracle 10g CREATE PROCEDURE syntax and looking
for examples with simple SELECT statements inside.  I see a lot of DML
but none with simple SELECT statements.
I'm thinking something like

In the 'Dependent Data mart' case, there is an ETL layer to extract
the data from the central Data Warehouse to adapt and Load onto the
'Data mart'.
Assume that the 'Data warehouse' and 'Data mart' run on separate

I'm trying to investigate a table drop using LogMiner.
I can locate the needed SCN and can see the 'DROP' command in V
$LOGMNR_CONTENTS along with some internal stuff in one transaction.
But for some reason SESSION_INFO is missing for that transacation!

Join us on Wednesday, March 25th, 2010
10:30 am – 12:00 pm GMT (4:00pm to 5:30pm IST)
Oracle Application Express is a rapid web application development tool
for the Oracle database. Using only a web browser and limited

I'll use Oracle 10g R2 on Linux with RAC, from the old system we used
oracle 7 on Miracle Linux.
With 10g R2 I want to know if Red hat enterprise linux is a better
choice ?

I have a service request, level 4, that hasn't been touched in 5 days. I
haven't even received an email that it has been assigned to an analyst.
Is anybody else having an experience like this? Should I call my legal
department and ask them to mention the word "lawsuit" to our ...

We have a large schema and packages that compile find on Oracle 11.1.
When I try the same procedure to build our schema and packages on a
new Oracle 11.2 on a new box it hangs during the compilation of a
package:

Previously one of our DBA's must have turned on auditing.  We get this
error in RMAN:
RMAN-00571:
===========================================================

I fell in love with the net and all the compuiter teahcnology in the very early years and have loved it ever since, I have an IT Degree and Communications degree and will be working on my doctorate for the next five years, in bwetween I design websites, databases, Multimedia ...

Here at Red Gate we've recently released early builds of Schema
Compare for Oracle. This tool is primarily to assist the pushing of
changes from environments such as development, test, staging, UAT and
production. It is the Oracle equivalent of our popular SQL Compare for

I have two file trees that correspond to two differerent versions of the
database schema for a web application I'm developing. These files
contain the SQL code to generate the objects (tables, sequences,
views...). I can find out what changed with any standard compare tool (I

Is there the way to get the full size of tablespace except from table
dba_data_files?

I upgrade sqldeveloper to 2.1.0.63 from 1.0.0.15.57.  When I
export to Excel files or SQL files, the new version does not
remember what directory I exported to last time and goes back
Documents And Settings\[username].  I looked but could find

I've been looking over ON & Metalink with no luck,   We have to
restore some data and are looking through the logs.  But the changes
took place via a stored procedure using passed parameters and it looks
like the parameters are not resolved in the logs.  Are we SOL?  Or is

the pawerfull book to learn oracle 10 g free download for a limited
time don't miss this
    http://tinyurl.com/y9pfppe

To do update for a record , or insert a record to a db?

We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the above web page, but basically, its a
very ambitious project to create what we call 'the query tool to end