Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to restore over an existing DB

How to restore over an existing DB

From: <RobbMichel_at_gmail.com>
Date: 23 Oct 2006 11:27:46 -0700
Message-ID: <1161628065.910115.31880@k70g2000cwa.googlegroups.com>


We are using Oracle 10g release2. We have a database csv5.dmp and want to restore it over CSV5, a database currently on our Oracle server. We get the errors below when trying to restore it. We are not very familiar with Oracle and I imagine the answer is simple?

imp sys/oracle file=csv5.dmp full=y
We get the error ->
IMP-00003 oracle error 1435
ORA-01435 user does not exist

imp fromuser = sys/oracle to user sys/oracle file=csv5.dmp full=y We get the error ->
IMP-00058 Oracle error 1017
ORA-01017 Invalid user name password
User does not exist ORA-01435 Received on Mon Oct 23 2006 - 13:27:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US