Export/Import

From: Kathinka Diehl <kathinka_at_rrr.de>
Date: Fri, 29 Oct 1999 11:40:06 +0200
Message-ID: <7vbqhm$aut$1@fu-berlin.de>

First question:

In the Online-Documentation (Oracle7, NT) I can read:

To use Import, the script CATEXP.SQL must be run.

Which user have to be connected? Sys, System, Internal, the user who wants to import datas?

And second (perhaps the reason for this is given in the first question?):

When I export datas from one table, I use the parameters:

userid=user1/passwort1_at_orcl
tables=table1
file=expdat.dmp

and I get a successfull execution. :-)

Then I try to import the datas in an existing table owned by another user in the same database, using the parameters

userid=user1/passwort1_at_orcl
fromuser=user1/passwort1_at_orcl
touser=user2/passwort2_at_orcl
file=expdat.dmp

The errormessage is:

IMP-00034: Warning: FromUser "USER1/PASSWORT_at_ORCL" not found in export file. Import terminatetd successfully with warnings.

But there are no datas in user2.table.

What's wrong?

THX in advance
Kathinka Received on Fri Oct 29 1999 - 04:40:06 CDT