unable to restore DB

  • tarnak

    tarnak - 2010-01-11

    please can any one help out to find out the error while restore the database oracle Xe
    I am getting error as "unable to re create user name compiere
    sql line 24
    please help me
    thank you

  • stingreye

    stingreye - 2010-01-11

    Its been a while but I have always restored manually.  log into sqlplus as system/password
    (if user exist, I may have had to drop the user first to delete everything in DB, that MAY be your problem you might not be able to create a user if it already exists)
    create user compiere identified by password;
    grant dba to compiere
    grant all privileges to compiere;

    go to directory for expdat.dmp imp compiere/password file =expdat.dmp from user=compiere

    Thats all from memory…. good luck.  I think there is a more automated way but I have only done it manually.


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks