Hi everyone, i  hope make me sense with this issue, i want to load a
file using the sqlldr program this is the command:
sqlldr control=/export/home0/CENIT/scripts/new_avail_load.ctl data=/
export/home0/CENIT/logs/070913.load userid=ovnoc/xxx log=/export/home0/

i was reading some paper related on clustering factor, this column
aimed to identified if the rows of a table are synchronized (ordered)
with the index.
If i don't mistake, the value of clustering_factor have to approached

I would like to make this work and I don't understand why it throws an
DRG-50901 error ( wildcard query expansion resulted in too many terms  )
The select is this one :
SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting\(%)' ) > 0)

We are currently on Oracle 8i, but in about 2 months we are moving to
10g.
Anyhow, we need to store more than 4000 bytes in a certain column.
How can I do that in 8i, such that it will not create a problem when

Oracle has Release 11g for LINUX.
Is there a roadmap available which shows when 11g is expected
for the other OS ? Especially AIX ?
Thanks

I deinstalled a Oracle 9.2.0.1 Enterprise Server on my Windows XP box.
When I go back into the OUI, the OUI picks up the home that I had last
defined. I have deleted all registry key entries under
HKEY_LOCAL_MACHINE\SOFTWARE\Oracle and under HKEY_LOCAL_SYSTEM\SYSTEM

today afternoon, my oracle system hanged. I found message "skgmdetach
- Unable to register unmap, error 4210" in my alert_SID.log file when
system down.
anyone met this problem? my OS is 64bit windows 2003, oracle is oracle

Oracle 10.2.0.3.0, Windows 2003 Server
Two servers:  Let's call server A "Lutsen" and server B "Annapurna".
Scripts are located and executed on Lutsen to read/insert/update and create
indexes on tables (a few 30+ and 80+ million rows in size) all located on

We have a PowerBuilder application where we started noticing the
performance of a query is worse if you do it with bind variables then
if you do the same query as a string. We made a small example and sent
to Sybase (makers of PB). We noticed that the bind variables query

For what it's worth:
http://tinyurl.com/yqpeqz

I have a horrible SQL statement to write!
I have to use a RIGHT OUTER JOIN to create a result set from 2 tables.
I'm using DECODE to select the correct value if one side doesn't exist
e.g -

www.oraperf.com always gives me a request timeout.
Searching google for oraperf links to www.sanperf.com, but this site
just displays the oraperf.com entry page and no links work.
Is this service still out there?

Hi, I have a problem with a customer pc.
We have an Oracle XE 10g installation (OS: WinXP Pro) that was working, and
now it's some days that it stopped working. I understood there is a problem
on the startup phase of the server.

I'm using 9207.

I have a table with a column with a constraint not null
and a index on this column
there are stats ion the table
when I do: