Export Failed

Printable View

08-13-2004, 12:37 AM
CaoCao

Export Failed

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
08-13-2004, 04:16 AM
OracleDoc

Quote:

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.

first of all...

1.Do all these instances run on one server? If not, do you have enough room and resources to fit all the extra data onto the one server.
2.The type of instances you have.. are they all realtivly the same? IE.. OLTP, warehouse, ect, ect..

Code:

. 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

isn't the error obvious??
08-13-2004, 04:49 AM
pando

use some decent user to run your exports
08-15-2004, 09:36 PM
CaoCao

Oops I mixed up this thread. Actually should be asking concerning instance plan on a server. Yeah those are suppose to run on the same machine. Memory wise should be sufficient for 3 instances in one machine. Those instances are OLTP and not so high load. So would it be wise to group 2 or 3 instances into only 1? This is will easier to manage but when and instance is down all the 3 schema and users will be affected. So what do you think?

Quote:

Originally posted by OracleDoc
first of all...

1.Do all these instances run on one server? If not, do you have enough room and resources to fit all the extra data onto the one server.
2.The type of instances you have.. are they all realtivly the same? IE.. OLTP, warehouse, ect, ect..

[code]
08-16-2004, 04:09 AM
davey23uk

http://asktom.oracle.com/pls/ask/f?p...:4347545437371