Oracle 10g RMAN with catalog.
Our RMAN catalog db manages 10 databases (all are 10g). From RMAN
catalog database machine, can we schedule RMAN jobs for the target
databases in EM browser?

I have a tablespace of 10 gb with 1 datafile. I took the backup of this
tablespace through rman using controlfile.
--It was read only tablespace.
Later I need this I restored it successfully from RMAN on a diff.

      I am using Oracle 8.1.7 On Windows...
Id (Primary Key)    Name (Name of the person)    PredId (Predecessor Id)
1                         A                                     0
2                         B                               1

Are there performance advantages to having a sequence generator per
table VS a single sequence generator used across all tables?  Are there
locking issues that might be a problem with using a single sequence
generator?

I have the following questions in the Oracle 8 and 9 platforms:
1.     Does the roles need to set password?  If no password, any negative
impact?
2.     Can user data / objects be put in the system tablespace?  Can this

Could you please tell me (step by step) how to uninstall Oracle 8 (Server)?
I have it on two computers with Windows NT 4 and Windows XP Pro.
I'd like to remove it from all places (directories, registry, services, path etc.)
on both computers.

What are the advantages/disadvantages of using a bigger stripe width
for datafiles at the storage level.

I want to know that actual meaning of some of the keywords used in the
Oracle SQL query execution plan.
Some of these are
INDEX UNIQUE SCAN

There are several FAQs about the Oracle database
scattered around the Internet, and many ways of
finding answers to the shorter questions about Oracle
very quickly.

I found a statement on J. Lewis' site about which
I feel particuliarly puzzled, it starts as follows:

We are having intermitent, but reproducable, ORA-04031 errors in our
application, and I am looking for solutions.
To reproduce the problem I have to run the probelm query simultaneously
on three sessions. Two sessions work fine, so there is obviously a

What Oracle sql query would take data in a table
like follows:
DEPARTMENT     JOB             Total_Empl  Average_Sal
Accounting     AC_ACCOUNT      1           99600

newbie alert, apologies in advance...
I have a connection string that looks like this:
    //oracle-rac-1:1521/racdb.pixar.com
Is there a way to use this string with sqlplus, instead of using

I had difficulty loading some data using sqlldr; A coworker offered a
solution but no explanation as to why it works.
Looking on the web, I found that integer values in the .ctl file can be
changed to char() with a number of digits spcified in the parens.

I would like to pass in a schema name to a cursor but I'm not sure what
the syntax is, can someone help...
cursor mycursor (v_schemaname in varchar2) is
    select name from v_schemaname.emp where empid=100;