If the catalog and catproc scripts create the data dictionary objects
in the database, does anyone know why the deinstallation of a patchset
(I'm working with installing 9.2.0.6 over 9.2.0.4 on solaris) is not as
simple as restoring the oracle_home software and re-running the ...

I'm running Oracle 10g on Linux. I'm trying to bulk load the database
but am getting :-
ORA-00900:    invalid SQL statement
Cause:    The statement is not recognized as a valid SQL statement. This

I am new to Oracle and would appreciate some help from you gurus out there

I want to create a DDL for all the tables and indexes under a certain
schema. I tried to execute these commands:

Hi, I have a 10gR2 environment consisting of two nodes both with an own
10gR2 installation (not RAC). They share disks and are intended to work
as a standby solution.
I want to be able to use a common/shared listener for the solution,

In an application, I enable a role through a procedure, so if one user
enables sqlnet tracing,
on his client, he'll be able to see the name of the procedure.
You'll probably say: yes, but not the name of the role. Anyway, I

Hi Gurus ,
One of my parallel queries( update statement) uses db file scattered
read.
But according to the documents , parallel query uses direct path read

given the following:
type uo_data object as (some_key number, some_more_data ...);
type t_uo_data as table of uo_data;
function somePipeFunc ( parms ...) return pipelined t_uo_data{...};

I am studying the use of sys_context.(Oracle 9206)
I created a function
-----------------------
create or replace function test_function

We experience several installation of oracle (not only different
versions but also multiples identical version) and then we have several
oracle inventory. Is there any mean to specify to the oracle installer
to use one inventory rather than one ?

I noticed that Oracle 10g XE, with the ojdbc14.jar JDBC driver, returns
DATE columns as java.sql.Date valuess. That surprised me, because the
ResultSetMetaData claims the column's Java type is java.sql.Timestamp
-- which would make more sense since DATE columns contain date *and*

Hi, all.
I have a need to insert a string value into a VARCHAR2(4000) field in
Oracle 8i. The string value happens to be a large SQL statement in
itself; the purpose of this is to record some ad-hoc queries for

I have a frustrating problem:  how do I replicate the effects of
SQLserver's "Generate SQL script" function in Oracle?
For those unfamiliar with the functionality, you can designate any
objects, across any schema, and SQLserver will automatically generate

We are planning for a change in ip address of our sun server on which
oracle database is hosted. The new ip address will belong to a
different subnet mask. What are the things that I should be aware of
while this is being done?

In case of a Foreign key constraint on the child table in a parent and
child relationship, how does the Foreign key contraint impact the
performance of any massive Insert or Update on the PARENT table?
The specific scenario does not update the primary key of the parent

I searched the group and found a couple of instances of this, but
without any responses/resolution.
I am attempting to install Oracle Lite on my Windows XP Laptop.
The installer does not detect JDK 1.4.1 or newer.