Hey, all...
So what's RMAN doing under the hood here?
I have a full backup of a db which I am using as a source for both
restores and duplications. I'm testing and getting familiar with RMAN.

From what I read, I thought that Oracle 10g, release 2 on Windows
should be supporting CLR/.NET procedures and so on.
However, I cannot find anything related to this in the documentation.
Was I mistaken?

select  p.d_insp_date,
       p.d_dam_date_by
      ,b.stat
      ,NVL(a.cnt,0) CNT

I need some help understanding how to make this SQL work. Below works
fine:
'****
SELECT

I want to remove the 10g-on-XP install to make more space for Linux/10g on
VirtualMachine.
Please point out or provide relevent instruction on removal.
There was a note on MetaLink but I think it's rather old and I don't have

I'd like to install Oracle 9iR2 (9.2.0.4.0) on a HP-UX 11.11 machine.
Which operating system patches should I install?
The documentation at <http://oracleheva1.oracle.com/docs/html/A96167_01/pre.htm#sthref108>
only lists 11.00 patches.

Maybe my question is quite a new by one, but is it possible to use
regexp in SQL. For instance in the WHERE clause ? Do you have examples ?
Thanks in advance.

Another question about web apps built with the PL/SQL web cartridge. We
have procedures which display data from the db to the user in a table
format. We show the first 45 results, and if the user needs more, there
are links to other "page numbers" at the bottom of the table.

I have to take a xml-document (the same type every time) through a
web-service.
Are there tools to generate table-ddl's? (just neede one time)
The xml-document should be "converted", e.g. stored in a set of (normalized)

i want to move oracle 9.2.0.5.0 from solaris 9 to AIX (which is brand
new).
size is 150 gigs no rac,no replication,no standby.
i feel if i go with exp/imp its gone take a huge time for exp and

Hey, there,
I was trying to create a view to get the new customer# fro year 2005
using the following code:
CREATE OR REPLACE VIEW NewCustomers

Initial setup: Embedded SQL/C Client (Pro*C) accessing Oracle Server (8, 9,
or 10)
Problem: In my client program I have (from earlier processing) a very long
list of values for given WHERE criteria (10s of thousands or more). I would

I have an ETL application that allows you to select a table delivery
method, one of which is APPEND.  When I select this option and turn on
sql trace to watch the sql being generated there is no /*+ APPEND */
hint in the INSERT statement.

When I try to run this stored procedure I get this error
PLS-00201: identifier schema2.table3 must be declared
I have looked everywhere and can't find the answer to this. I come from
a T/SQL background so I am at a loss as to why this doesn't work.

I am working a bill-of-material (BOM) problem, and i need some help.
I want to make a report for my employees at the warehouse, telling them
which articles to pick.
I have the following table BOMTABLE: