DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export Failed

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    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

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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??
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use some decent user to run your exports

  4. #4
    Join Date
    Sep 2003
    Location
    China
    Posts
    72
    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?

    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]

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width