Re: How to restore over an existing DB

From: Hans <Hans.Wijte_at_mail.ing.nl>
Date: 24 Oct 2006 00:34:27 -0700
Message-ID: <1161675267.625448.295070@b28g2000cwb.googlegroups.com>

RobbMichel_at_gmail.com wrote:
> 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

Question :
- How can you use an Oracle database if you are unfamiliar with Oracle

I think :

- the data in your Oracle database is not important to your company
- you don't have a backup procedure other than an export
- your company doesn't have a database administrator

...
etc. etc.

Bottom line : if your data is important to you, get a DBA, right now

Hans Received on Tue Oct 24 2006 - 02:34:27 CDT