I've got what I think is a simple question. We have a 10g database,
and I'm trying to run a batch file that uses 'sqlldr' to check a
control file and then update the database. The batch file will run on
the db server of course, the problem is that it cannot be run from a

What is Oracle Open gateway and how it’s used for APPC (IBM
Mainframe)?
Thanks,
DK

I have several databases running version 10.2.0.3.
O7_DICTIONARY_ACCESSIBILITY is set to FALSE on all of them, yet in some
cases v$parameter.isdefault says TRUE and on others it says false. Why
would this be? Below is an example.

Im trying to use the column 'process' in v$session but the information
returned showed numbers in different formats and made me confused. Is
there any documentation about how this data is formatted
(hex,octal,...) for each platform? So far, what i most need now is to

Oracle 10g 10.2.0.3.0
Perusing the database where I work I've noticed that, among other things,
the following privileges have been granted as a general rule to all users:
1.    select any dictionary

Hello NG,
I'm stuck with the following problem and need the help of someone with
more oracle-exp. than me (which isn't that difficult)
Having a stored procedure which creates a multi-partitioned table

i am looking to find the first word of a field greater than 17
select businessname
from tablename
where

Apologies if this gets posted twice
I am relatively new to PL/SQL and want to do is find a list of
duplicate records, then recording the duplicate c_rec id's in some
sort of structure which I can extract at a later date

I think this may be a bug in Oracle, but Im not 100% sure.
A little background: I have a script which builds up and tears down a
database schema for testing purposes. This script is run several times
a day, and usually works fine but I just had the following issue

who has planned and succesfully done a database move to a new server with
multi-master environment.
What needs to be considered beforehand?
tia

i have a table with 4 columns,  they look like
currency1 currency2 amt1 amt2
=======================
USD   GBP   10    9

Please take a look at this query:
SELECT max(action_date), customer_id
FROM email_product_hist
WHERE action = 'A'

I had a database in archive log mode
I did a cold backup once a week.
If I restore the database from cold backup
and if I open it, can I recover it after

Didn't get to go to Collaborate this year. Are there any comparable
seminars or symposiums coming up?