I am trying to create dynamic update statements, but then have them
execute as well, so I do not have to take another step of running my
results. I cannot figure out the proper syntax to run my update
statement in the cursor.

I have a huge performance degradation on Oracle side
of my Web application. I found that problem come from select
statement from table with above 1.5 millions records with
"where condition" that contains function "upper", like following:

without taking it offline,
i.e. clients can continue to update and select
from the table, while the reorg is running.

I have some trSQL procedures to rewrite in PLSQL, is there any way to
convert transactSQL code to PLSQL code...freewares..links...
Anymay, what is the similar oracle exe for 'osql' of SQLServer, in
order to insert by command shell SQL code ?

I come across many requirement that require DBA to have specific RAC
experience. I would like to solicit input from the experts in this
forum on following.
1) For Sr. DBA with solid fundamentals, how difficult/different is to

Hi! Into my database (its part below), i'm trying to insert values.
CREATE TYPE t_vphonenos AS VARRAY(3) OF VARCHAR2(15);
CREATE OR REPLACE TYPE t_customer AS OBJECT (
id           number(4),

Using Oracle sqlldr to load values into a table, I would also like to
load a constant (the filename of the file) into the table as well, is
this an easy thing to do? Would someone have a quick sample?
Thx!

Is this the wrong approach ? (looking for opinions)
Oracle 9.2.0.6 on Solaris 64
We currently have a 10G production database on a first server.
We have a copy of that database on another server, used for reporting.

I've a problem: is there a possibility, on a Oracle 9.2.0.1 server with
STOPPED redo, to know WHEN they was used the last time or when they has been
stopped?
They have the same creation day of the day in which the server started

One of my developers just emailed me with the issue I've quoted below.
The "upgrade" he mentions was the recent patch from Oracle 9.2.0.4 to
9.2.0.5.  This is an x86 box running RHEL 3.0 ES.  I've read a "horror
stories" thread on 9.2.0.5.  Should I consider downgrading the box ...

Which order should this be done in. Anyone experienced problems as a
result of satrting database first, then listener and which were
resolved by doing it the other way around?
Client is saying they have to start listener first with our app or it

If anyone is interested in getting Oracle data directly into Microsoft
Excel then take a look at www.synola.com it does just what you'd
expect...

Thanks in advance.
We have a situation where a machine is streaming large amounts of data
via multiple oracle connections to our Oracle DB.  Over time, the
oracle listener does not respond to any more connection requests.  Only

I'm just checking whether I understand the way Oracle RAC is suspposed
to work.
I have two nodes, named pora1 and pora2. Both nodes access the cluster
registry and voting disk files on raid storage, mounted on /oracrs . All

Hola, ¿ saben si la version Lite de Oracle se puede usar como gestor de base
de datos normal o tiene algunas restricciones ?
Gracias