Anybody else getting solicitations from Nigeria with hard-luck stories from
newly certified DBAs?
++ mcs

Folks,
  I'm currently trying to get to the bottom of why my 4 database
writters spend so much time
 waiting on 'db file parallel write'... even when it appears that the

on 9ir2
say I have a table A and B.  A contains 6 million records that need to
be updated.  This is in a data warehouse.
I want to.

Hi Friends ,
well i am new to this group, can anyone tell me about how much
beneficial an Oracle certification i.e introduction to Sql will have in
getting a good job ??

Hi everyone, I have a table that contains duplicate records.  All of
the fields in these records are duplicates except for the primary key.
I need to identify these records by their primary key.  Can anyone help
me with this?  Thanks ahead of time.

Wanting to run a query which will do the following.
Extract information from the first and last record in the query and
also the number of records processed.
So a table containing the following.....

Can you pass a parameter to an anonymous block?   We have a Unix script
which will run and compile some procedures for us.  For checking, we
want to select the status column and make sure everything is valid.
Rather than spool all this junk to a file, we were going to write an

I am in a dilemma , where I have 2 Oracle databases . Database 1 has
data which I need to join with Database 2 and create reports.
My approach for now and i don't know how I will be achieveing is:

Can anybody tell me how to insert a Non-breaking Space (ASCII 160) in a
field using SQL? I use SQL*Plus.
Any comments would be appreciated.
Thanks,

in order for the instant client to work, the FAQ mentions that the
TNS_ADMIN variable must be set. I can get it working if I create it as
an environment variable (windows O/S). It also mentions a registry
setting to set the TNS_Admin... I couldn't find more info on that, in

we're on 9.2.04 and about to implement advanced security.  we are also
about to explore replication to a distant site.  from a days worth of
manual reading and googling, i can't tell if replicated data packets
can be encrypted.  can anyone share their experience with needing to

Has anybody tried to install 8i on Redhat 3.0 or 4.0?
Its not a supportd congiuration but i need to do it.
Thank you!

Hi Friends ,
well i am new to this group, can anyone tell me about how much
beneficial an Oracle certification i.e introduction to Sql will have in
getting a good job ??

I have a problem with GetRecordCount() in VC ..
When I execute SP returning multiple rowset using ref_cursor, this
process is succeed in excuting. But the result of GetRecordCount is -1.
If the result of SP is and then I excute MoveFirst() or MoveLast(), it

I am calling a package.procedure from oracle from asp but get above
error.
But if tries to excute same from sqlplus it works fine.
Please help.