C:\Documents and Settings\Administrator>d:

D:\>cd dbbackup

D:\DBBackup>set nls_lang=GERMAN_GERMANY.WE8ISO8859P1

D:\DBBackup>sqlplus system/manager@dpeea

SQL> drop user dpmgr cascade;

User dropped.

SQL> CREATE USER dpmgr
  2     IDENTIFIED BY dpmgr
  3     DEFAULT TABLESPACE dpdata
  4     TEMPORARY TABLESPACE temp;

User created.

SQL>
SQL> GRANT CONNECT, RESOURCE, DBA TO dpmgr WITH admin OPTION;

Grant succeeded.

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

D:\DBBackup>imp dpmgr/dpmgr@dpeea file=dpliv3.dmp fromuser=dpmgr touser=dpmgr

Import: Release 8.1.7.0.0 - Production on Do Nov 3 11:46:54 2005

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

Export file created by EXPORT:V08.01.07 via direct path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00017: following statement failed with ORACLE error 2082:
 "CREATE DATABASE LINK "DPEEA.BIS.SWIREBEV.COM" CONNECT TO "DPMGR" IDENTIFIED"
 " BY "dpmgr" USING 'DPEEA'"
IMP-00003: ORACLE error 2082 encountered
ORA-02082: a loopback database link must have a connection qualifier
. . importing table                      "CCONFIG"          1 rows imported
. . importing table                     "DFUMATCH"          0 rows imported
. . importing table                     "DFUTLIST"         42 rows imported
. . importing table                      "DPEE_UC"         88 rows imported
. . importing table              "FFW_BEZMOD_HEAD"          7 rows imported
. . importing table               "FFW_BEZMOD_POS"         15 rows imported
. . importing table                 "FFW_CALENDAR"          2 rows imported
. . importing table                   "FFW_EXPORT"          7 rows imported
. . importing table             "FFW_EXPORT_PARAM"         18 rows imported
. . importing table               "FFW_FISCALYEAR"          0 rows imported
. . importing table                "FFW_H_ENTRIES"        661 rows imported
. . importing table                 "FFW_JOB_HEAD"         17 rows imported
. . importing table                  "FFW_JOB_POS"         17 rows imported
. . importing table                  "FFW_LICENSE"          3 rows imported
. . importing table                "FFW_MBE_CLASS"         41 rows imported
. . importing table               "FFW_MBE_GRAFIK"          6 rows imported
. . importing table                 "FFW_MBE_KRIT"          8 rows imported
. . importing table                "FFW_MRMO_HEAD"          1 rows imported
. . importing table                 "FFW_MRMO_POS"          4 rows imported
. . importing table                "FFW_NOMO_HEAD"          5 rows imported
. . importing table                 "FFW_NOMO_POS"         15 rows imported
. . importing table                   "FFW_SELDEF"         45 rows imported
. . importing table                 "FFW_SELRECON"        473 rows imported
. . importing table                    "FFW_SIGMA"          0 rows imported
. . importing table                "FFW_STRUCTDEF"         11 rows imported
. . importing table               "FFW_TSRELATION"       1077 rows imported
. . importing table                     "FFW_USER"          0 rows imported
. . importing table              "FORSYS_ERRTABLE"          3 rows imported
. . importing table               "FORSYS_FSBASIC"          1 rows imported
. . importing table                  "FORSYS_INFO"          0 rows imported
. . importing table               "FORSYS_MEANCHG"        243 rows imported
. . importing table                "FORSYS_OPSMTX"         13 rows imported
. . importing table               "FORSYS_SEPRCNT"       1192 rows imported
. . importing table                "FORSYS_SYSTEM"          1 rows imported
. . importing table               "FORSYS_TSBASIC"       1081 rows imported
. . importing table               "FORSYS_TSFCMOD"      14395 rows imported
. . importing table                 "FORSYS_TSMBE"       1081 rows imported
. . importing table             "FORSYS_TSMEANCHG"        243 rows imported
. . importing table                "FORSYS_TSPLAN"        688 rows imported
. . importing table               "FORSYS_TSSEABS"        619 rows imported
. . importing table             "FORSYS_TSSEPRCNT"       1197 rows imported
. . importing table              "FORSYS_TSTARGET"         89 rows imported
. . importing table                 "FORSYS_TSVEC"       5276 rows imported
. . importing table             "FORSYS_TSXSEASON"          2 rows imported
. . importing table               "FORSYS_XSEASON"          4 rows imported
. . importing table                       "KEYMAP"          0 rows imported
. . importing table                     "TEMP_LIR"         78 rows imported
. . importing table                     "TRANSERR"          0 rows imported
. . importing table                     "TRANSGRP"         31 rows imported
. . importing table                    "TRANSHIST"          0 rows imported
. . importing table                     "TRANSSEL"          0 rows imported
About to enable constraints...
Import terminated successfully with warnings.