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
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.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.