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

RobbMic...@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

cvs5.dmp is NOT a database, it is an export! (which is a *logical*
dump)
Basically you can not 'restore' an export,
as the export is just a series of INSERTs.
So you can also not 'restore' it *over* an existing database, without
dropping the existing users.
There are several export types. Only a *full* export contains create
user statements.
As you get an error for a non-existing user, you don't have a full
export, but an user export.
You can verify this by
imp <username>/<password> full=y show=y log=<any file>
This will dump all commands which are going to be executed in <any
file>
If the user is missing, use the CREATE USER statement to precreate the
user.

--
Sybrand Bakker
Senior Oracle DBA

Is there a way to delete the imported CSV5 files and replace them with
the new information in the dmp file?

RobbMichel@gmail.com wrote:
> Is there a way to delete the imported CSV5 files and replace them with
> the new information in the dmp file?

There is no "imported CSV5 files". There are only tablespace files.
(Well, and redo log files, and control files, and initialization
files,....). As Sybrand said, the .dmp file is *not* a database file,
it is a collection of INSERT (and possibly CREATE and ALTER)
statements.

If you delete the "imported CSV5 files" ... what files are you thinking
of? You might want to spend some time in the Utilities manual (see
tahiti.oracle.com) and the Concepts manual.

RobbMichel@gmail.com wrote:
> Is there a way to delete the imported CSV5 files and replace them with
> the new information in the dmp file?

What CSV5 files? You have a dump file created by an export named
csv5.dmp. What else is there?

You can not restore or recover from an export.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

the CSV5 files were imported from an earlier dump file over a month
ago. We now want to import the CSV5 dump that we got last week to make
the information in the tables associated with the dump current.

RobbMichel@gmail.com wrote:
> the CSV5 files were imported from an earlier dump file over a month
> ago. We now want to import the CSV5 dump that we got last week to make
> the information in the tables associated with the dump current.

Can you lose the data entered in the database between "over a month
ago" and now ?

mRangel wrote:
> RobbMichel@gmail.com wrote:
>> the CSV5 files were imported from an earlier dump file over a month
>> ago. We now want to import the CSV5 dump that we got last week to make
>> the information in the tables associated with the dump current.
>
> Can you lose the data entered in the database between "over a month
> ago" and now ?

And can you consider using a better technology for accomplishing this
goal if you are going to be doing it on a regular basis? Export-Import
does not seem to be a good technique for what you are trying to do.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

RobbMichel@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

The goal is to query the data in the Oracle database and move it into
our SQL database. We get the data from a client (they only know how to
send a dmp), and we do not use Oracle here we use SQL.

We just have an Oracle test enviroment to practice writing queries to
get data from the client's Oracle database. So we threw together an
Oracle enviroment to allow easier development. The developer wanted
more recent data than the last dump we imported and we are now in this
situation. We have about 4 employees total and can not just hire a new
person to monitor this enviroment. That is why I am using gooogle
groups to discuss the problems we are having. I have gotten great
advice from google groups in the past.