I am trying to modify a stored procedure that was written by an old
colleague, which currently imports product data changes into a products
table from a csv file.
Each product has a flag to say if it's visible on the web site or not.

I have 2 tables (T_TAB1, T_TEMP). T_TAB1 has approximately 30 columns
and 2.6 Mio. records (rows). I put an index on KDNR (NONUNIQUE).
For both tables I created statistics, as well as for the index
(calculator symbol in TOAD 7.4).

I am trying to install Oracle 10g on Solaris 9 OS and getting following
error message.
"ERROR: Unable to convert from "UTF-8" to "646" for NLS!
Bus Error - core dumped"

Hi, I'm having trouble working out the Ora equvalent of the following.
I'm merging two rows, the row I'm using to update the first will
populate any columns which have a null value.
UPDATE #Temp

I've been trying to find several hash_values found in V$SQL[AREA]
in V$SQL_PLAN but to no avail (also tried with the ADDRESS)...
What makes a query enter the V$SQL_PLAN view ?
(I'm talking about 9i)

Can anybody say that Oracle is better than Informix in terms of spatial
capability? Is there any references on the Web where I can compare the two.
Michael

I want to create an alert that tells me the changes on a specific field
of a table when done.
Therefor I also need the old and the new value from that specific
object.

We have an installed base of 10g on Solaris 8 across several mid-range
Sun servers. As we migrate to Solaris 10, our dba group has proposed we
move the Oracle binaries in place - that is, we deport the volumes from
the Solaris 8 environment and import them on Solaris 10 (we are ...

OK, Im having a bit of difficulty here and hoping that the knowledgeable
folks here at cdos can help me out:
We are upgrading a 9iR1 database to 10gR2.  At the same time, we are
upgrading the hardware.  Both platforms are Win2K.  Right now, I am

Hi: everybody
just say hello to you guys. of course I need some help from your
suggesstion, I am a oracle DB developer, recently join a project, one
query I am currently working with is to join 9 tables together, the

sorry for my english. I try to create manually a database in Oracle 9i. I don't
understand this step:
CREATE TABLESPACE rollback DATAFILE '....' ....
/***************/

On the 9i and 10g download pages, I have seen references to the
following 64-bit Intel architectures:
x64,
64-bit Itanium,

i currently trying to change all our rman to disk backupsscheduled in
cron to:
netbackup scheduled rman straight to tape.
I have set up netbackup to take the disk backup off to tape after cron

perfstat runs at my site every hour of every day of the week. Because of
the continue groth of data I want to remove old snapshots. How can I do
this?
Also I am not very interested in the perfstat data that is collected in

I have oracle 9.2.0.7 on two windows 2003 servers. When I run a sql
with sort operation, the server 1 runs quicklier that server 2. There
are a lot of wait events "direct path write/read" on server 2.
I am not sure what causes this. I guess it is caused by direct io or