OS: Windows 2000 Pro
Oracle: 8.0.5.2.1

My company has many instances. Currently each instance is hosting one schema user which is access by an application. I thought of consolidating 2 or 3 instances into 1 instance. I want to know the pros and cons of running in 1 instance as compared to separate indivual instances. Tks.

Errors:
. exporting table JOB_GROUP
EXP-00056: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
. . exporting table JOB_SUB_GROUP
EXP-00056: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
. . exporting table KSEMP
EXP-00056: ORACLE error 1031 encountered
ORA-01031: insufficient privileges