I need refresh test d/b with prod data. I am running Oracle 8i on
WinNT. Prod server has 9 drives and test server has 2. What are my
options? I am already doing export of prod d/b. Can I use that to
import into test? Do I need to do anything special?

utl_file.fclose(emi_output);
Compilation errors for PROCEDURE CAPUSER.SP_FEES_EMI
Error: PLS-00201: identifier 'EMI_OUTPUT' must be declared
...

Whenever I try to schedule a backup I get the following error.  Can
anyone explain this to me?  Thanks in advance.
Recovery Manager: Release 10.1.0.3.0 - Production
Copyright (c) 1995, 2004, Oracle.  All rights reserved.

The Topics Covered In This Book Are: Understanding the Oracle
Environment; Understanding the Oracle Instance; Understanding the
working of Oracle Instance; Understanding the Oracle Database; Oracle
9i Software Installation; Oracle 9i Database Design using DBCA;

We recommend: Oracle Silver Bullets: Real World Oracle Performance
Secrets
(Oracle In-Focus)
by Donald Keith Burleson

Greetings, I looked in the patches section for Linux 64 Bit Intel and
there is  no family patchset for 10.2.0.2 or 10.2.0.3?  Is 10.2.0.1
the only version for 64 bit intel?

What's New Yellowfin Business Intelligence 3.2!
--------------------------------------------------------------------------------
Powered by J2EE, Spring, BIRT, Jasper, Spring, iText,
Release 3.2 of Yellowfin is in the pipeline, and we thought we better

Trying my first Oracle install here.  I followed this guide -
http://www.oracle.com/technology/tech/linux/install/files/oracle-database-10gr2-
kubuntu-dapper.txt
and when it started installing, it was stuck at 3%.  The "Installation
in progress" check mark is moving, yet it's ...

Let's say I have the following table B containing
SQL>  select * from b order by bl_id;
NAME                      BYTES     BLOCKS     FILEID      BL_ID
-------------------- ---------- ---------- ---------- ----------

I have 2 tables BATCH and BATCH_PROGRAM.
BATCH
----------
BATCH_ID NUMBER(10)

can i add a field on an existing primary key ?
thanks

Hi gurus
I have the following schema, for a given item i have a set of
attributes and for this set of attributes , i can have thousand set of
attributes values (ie.  item (pant) -> set of attributes

The Topics Covered In This Book Are: Understanding the Oracle
Environment; Understanding the Oracle Instance; Understanding the
working of Oracle Instance; Understanding the Oracle Database; Oracle
9i Software Installation; Oracle 9i Database Design using DBCA;

We are trying to develop a script which detects if oracle server is
running correctly. We have seen that lot of oracle process are running
and with ps is not easy to know if oracle is really running. On the
other hand we saw that through sqlplus is possible to start a

we are planning to upgrade 9.2.0.8 to 10.2.0.3.
On our old environment we have had four separate instances and multi-master
replication setup.
Now when moving to 10.2.0.3 there might be a chance to start using Oracle