in our application it would be very helpful, if the search wouldn't
return only exact matches, but also similar items, e.g.
search for "models" returns also "model"
search for "exmaple" returns also "example"

Anyone care to reccommend  a backup script for a cold backup (db shut
down) for 9i on Redhat?
Also a script for a hot backup (archivemode on).
TIA

Working environment: Oracle 10.2.0.2 , 10.2.0.3 on several OS
platforms
Nor working environment: Oracle 11.1.0.6 on Windows XP Pro.
The problem:

(this message was originally posted in comp.databases.oracle.misc, but
it was suggested that comp.databases.oracle.server might be a better
fit).
The existing server extensibilities in modern DBMSs have been critical

we're running Oracle 10.1.0.3.0 on Linux Redhat ES 4, 12GB memory.
we are testing application with 50user+ that connect into the database
oracle 10.1.0.3.0 and i saw graphic performance on my EM, it looks ok.
and then on top sql, few queries showed percentage 44% and 60%, i

I am doing an execution plan from a schema for which RLS is enabled.
But I am getting an error ORA-28113: policy predicate has error
The same query works fine if I execute it otherwise. It is only the
execution plan which gives this error. Is there any way to generate

Say I have a table SCOTT.EMP and when someone inserts into the table
and incurrs and error (Violated PK, FK constraints, etc) I want that
record to write to an EMPAUDIT table so I can review it.   I wrote
this trigger that I thought would do the job, but it does not.  My

How can I read from registry (VB 6.0) ?
Need sample code, please.
Thanks :)

I have noticed that client applications running on BEA WebLogic Server
as well as Sun Application Server are allowed to create connection
pools to the non-vip address on the Oracle 10g RAC. The jdbc url both
application servers use is:

Oracle 10.2.0.3 non-RAC on RHAT 4 32 bit
We are trying to copy a fairly large table (about 8 billion rows with
16 hash partitions) to another database.  We are periodically running
into performance issues during the copy via database lihk where the

Good Day All,
I'm slowly making my way through the Oracle Database 10g Server manual
and have a quick question.
I know that Oracle Database Server uses a spfile to get the

Rainbust your Oracle DBA "system" password in mere minutes
Rainbow Tables for CAIN:
- only for system account
- up to 8 characters passwords;

I am new to taking backups in Oracle. Say if I create a database with
the Archived log space as 10GB . Now if I have a daily backup , I see
that it eats up quite a lot of space. Now how do I move some of the
archived logs or delete them ? Do I have to necessarily use RMAN for

Dear Friends,
iConnect Software Solutions (India) Pvt Ltd. is a US based Software
Development & Consulting Company and it's a strategic IT consulting
firm that delivers business-driven solutions. Our solutions encompass

i am right now using oracle 9i.
i have a procedure named
any_table(p_tablename varchar2)
which i am using to create a .sql file using the UTL_FILE package.that