I'm running through the installation instructions "Oracle Internet
File System" for Oracle9iAS on Solaris8 and I've hit a statement in
the guide that reads
"d. Make sure there is at least one online non-system rollback

I am standing right now before a task to install many databases on one
host. I know this is waste of resources and that all shoul be put to one
instance and managed with different schemas - but please just leave the
discussion asaid.

I have a function return time for specific hour a day: (this is
adopted from askTom site)
CREATE OR REPLACE FUNCTION getNextRun(p_date IN DATE)
  RETURN DATE IS

in dba_audit_trail and sys.aud$ is not getting updated. Anybody seeing this
kind of behaviour. We are using oracle 9204.

New to Oracle and having an apparent RI problem in SQL PLus.
Ran a script to create some tables. When I began to drop them (this is
for a class) one would not drop citing an RI constraint.
I have a problem with a table in SQL Plus.

Hallo together,
I have to work out an sql-statement which was former runnning on an
Informix-Database. This has to be converted to the Oracle-Outer-Join
Syntax.

We are designing on Oracle 9i database. Many tables have PK on one
column of
30 Varchar2 length. Some even with 50 Varchar2 column as PK.
Will this cause performance problem ?

Does anyone know the PL/SQL code behind SQL Single Row Character Function,
for example, UPPER()?

On a multi-developer project, what's your standard/typical way of handling
the deployment of PL/SQL packages from developer schemas to a centralized
schema (version control schema), test schemas, and finally production
schema(s)?

All,
I had the statspack report with a wierd issue: very high
   Rollback per transaction %:   99.49
but other rollback statistics don't show many rollbacks.

All,
I had a statspack report with high Rollback Per Trans:
 Rollback per transaction %:   99.49
But other rollback activities look not that bad:

we`re running out of free tapes in our lib, because
rman (using no catalog, just controlfile) wasn`t synced so far with the
catalog of our 3rd party backup software.
It does not provide any tools to do so.

RDBMS Version: 9.2.0.5
Operating System and Version: Solaris 8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Data Guard

I'm trying to plan how many instances can I create on the P650 Server
without loosing great deal of performance and encounter a lot of
swapping:
Server Specs:

What is the quickest and the best way to learn Oracle?
Regards
John