oracle_imp_aleph_libs: "cannot drop a user that is currently connected"
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We are running the oracle_imp_aleph_libs procedure to import our v17 data into our v20 Oracle instance.
Looking at the $TMPDIR/oracle_imp_aleph_libs.log.29625, we see these errors:
aleph_admin@ALEPH20T> DROP USER abc01 CASCADE
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
CREATE USER abc01 IDENTIFIED BY ABC01
*
ERROR at line 1:
ORA-01920: user name 'ABC01' conflicts with another user or role name
and later:
Export file created by EXPORT:V09.02.00 via conventional path
import done in UTF8 character set and UTF8 NCHAR character set
. importing ABC01's objects into ABC01
. . importing table "Z00" 311990 rows imported
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "Z00_ID" ON "Z00" ("Z00_DOC_NUMBER" ) PCTFREE 5 INITRA"
"NS 2 MAXTRANS 255 STORAGE(INITIAL 4194304 FREELISTS 1 FREELIST GROUPS 1) TA"
"BLESPACE "TS2X" NOLOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Resolution:
The following two steps worked. (Probably only one was necessary, but I'm unsure which.)
1. Had everyone dlib-ed to an ABCnn library, dlib to usm01 instead.
2. Ran aleph_shutdown . (This just shuts down aleph, *not* Oracle.)
Then I ran the "csh -f $aleph_proc/oracle_imp_aleph_libs ... " as described in the doc and as done before.
This second run did *not* have the errors from the above Description.
- Article last edited: 10/8/2013