I say oldie because I'm still on 8.1.7.
I am in the process of testing a new infrastructure in my environment,
and I need to replicate our Dev database onto a new server for testing.
We are running AIX, and the test server is W2K, SP4.

I could really use some pointers. Here is the problem: I have a IBM MVS
process that when complete will FTP a single row file to a Windows or
AIX server. I need the data to be loaded into my Oracle DB that lives
on an AIX server. The work has no preset time of day or day of week and

Cross-posted to comp.databases.oracle.misc and comp.lang.php ...
Using PHP 4.3.11 on Linux and ADODB data abstraction library.
Oracle client version is 10.1.
Can successfully connect to remote database (version 9.2.0.6 on Linux

Does anyone know of anyway to trick Oracle, so I can export an Oracle 9
database using Oracle 10gs Data Pump utility?

Hello everyone. I think I need some guidance to get my query to use an
index. When I look at a plan table for a query I see "TABLE ACCESS
FULL" with bytes 186M.
-----------------------------------------------------------------------------------

I can connect to as database from the SQL prompt like:
SQL> connect sys/****** as sysdba
but cannot from OEM or the Data Guard interface?
The login screen says to connect as sysdba.  Why

We're experiencing "general slowness" with our application which has an
Oracle back-end. As far as possible, I've eliminated the front-end
(Forms) and network as bottle necks. Now, I'm not a DBA, but I did run
a query on the v@system_event table as follows:

I installed Oracle 10g Enterprise Edition 2 days ago, It gave me the
url path for
grid control
http://192.168.1.100:5500/em

I have a question on how oracle consider IBM DUAL or Sun 8 core CPUS.
ie. Consider as dual CPU's and assign two physical process to each CPU?

I am trying to restart AS10g on SPARC Solaris 9.  opmnctl command hangs
and only starts 1 of 4 processes (HTTP_Server only)... the output of
the command is below.
$ ./opmnctl startall

               I have a question, Is it possible to insert a value and
refer to that value in the same query?
What I mean is suppose in a table there are two fields. I insert the
value into the first field and the second value has to be inserted

Group,
Oracle is so expensive, often time, managers chose SQL server over Oracle
only because of the expense, and it is sad to see all those new projects go
to SQL server group. (Our shop do not do any in house software development,

I have a database among 6 tables. Each record goes from the main table to 5
other tables via 1:1 relation. A new record is only inserted once in the
main table tblPERSN, and the primary key ID_PERSN should become inserted in
the 5 other tables as a foreign key (ID_PERSI, ...).

Given is a table SEASONS with a DATE field and an ID field. Some IDs have
values, some IDs are NULL values. Now I want to update the NULL values with
the last assigned ID value of a prior DATE.
STARTDATE        SEASON_ID

We have a database running on RAC. The below is the problem summary I
am facing.
Previously we used to do a full export and the backup used to fail
regularly with the following error: