• 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