We're migating our OS from AIX (Oracle 9.2.0.6 & MF Cobol) to RHEL 4
(Oracle 10.2.0.1, also MF Cobol).  Every program that compiles and runs
on AIX seems to do the same on RHEL4. Every program except one, where
the precompiler seems to be having a problem rejecting some (but not ...

I need to write a script that will log into a server as a user and
delete the contents of that user's default tablespace. It'd be easy to
write a script to drop and recreate the tablespace, but the UID I
isn't supposed to leave his tablespace, hence I just want to "reset"

I have a table which has 3 columns: user id, key and value. A user may
only have one instance of a given key. However, the key may have
multiple values; these are held as comma-separated values within the
value column (there can be any number of these values in the row). An

Has anybody come across any tools/products that can scan the Oracle 7
redo log to identify the data changes and do something with it? Have
you worked in this area?
Thanks.

I have a problem, I found on internet a way to split strings separated
by pipe | (for example) with regexp, something like that:
SELECT REGEXP_SUBSTR('One|Two|Three|Four','[^|]+', 1, 3)
FROM dual;

We are running a 10.2.0.3 database and this is being monitored with a
10.2.0.3 Grid control agent in a separate home on the same server.
When starting and stopping this agent the 10g docs say to:
cd $AGENT_HOME/bin

Buenos días, voy a actualizar a la version 10.2.0.4, quiero instalarme una
máquina virtual para hacer primero la prueba, mi pregunta es:
En el caso de que fallara en el servidor en explotacion ¿podría cambiar el
nombre del servidor virtual para que todo funcione correctamente?, ...

I am using a CONTEXT text index with 10g express (to develop with on
my laptop).  I crated a custom search that joins together columns from
many tables using PL/SQL.
Is there any way to mark some words as relatively more important?  For

I'm a new learner in pl/sql & trying to write a small basic pkg which
includes both functions & procedures.  could you take a look & tell me
where I'm doing wrong & how to fix it? Appreciate your helps/
suggestions.

Is there a way to find out what indexes are used(useful)/unused(useless)
while the last few days/weeks?
If possible so tell me a way via data dictionary without using any
external tools.

Dear Friends,
Kindly dont ignore this mail. This is not a spam.
Visit the link to get OCP dumps online absolutely free:
http://neworacledba.blogspot.com/2008/04/oracle-exam-dumps-absolutely-free_5977.html

Our Windows Servers have 4 CPU’s. Our licenses are based on no of
cpu’s. Our cpu utilization typically is 10%. Is it possible to change
cpu_count parameter e.g. 1 to Oracle will only use 1 cpu. I changed
this parameter and did find that parameter remains in fact to 1. Now

Dear Friends,
Kindly dont ignore this mail. This is not a spam.
Visit the link to get OCP dumps online absolutely free:
http://neworacledba.blogspot.com/2008/04/oracle-exam-dumps-absolutely-free_5977.html

After installing Oracle 11g R1 EE Win XP SP 2 computer 2GB storage 11g oem
hogs cpu 100%
1. When stopping oem (emctl stop dbconsole) all is fine, after starting oem
(emctl start dbconsole) same situation.

Dear Friends,
Kindly dont ignore this mail. This is not a spam.
Visit the link to get OCP dumps online absolutely free:
http://neworacledba.blogspot.com/2008/04/oracle-exam-dumps-absolutely-free_5977.html