Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

unable to restore DB

tarnak
2010-01-11
2013-05-02
  • 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;
    exit

    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.