-
URGENT - Import Errors
Please look at the below error messages (while importing) and
let me know if I need to re-build the catalog or......
#####################################
Import: Release 8.1.5.0.0 - Production on Thu Jan 25
17:10:41 2001
(c) Copyright 1999 Oracle Corporation. All rights
reserved.
Connected to: Oracle8i Enterprise Edition Release
8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Export file created by EXPORT:V08.01.05 via
conventional path
import done in WE8ISO8859P1 character set and
WE8ISO8859P1 NCHAR character set
export client uses US7ASCII character set (possible
charset conversion)
IMP-00017: following statement failed with ORACLE
error 4068:
"BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been
discarded
ORA-04067: not executed, package body
"SYS.DBMS_REPCAT_UTL" does not exist
ORA-06508: PL/SQL: could not find program unit being
called
ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 94
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
#####################################
-
Might be good idea and good habbit too if you are going from version to version (8.0 to 8.1). Not a big deal if its between releases. (8.1.x to 8.1.x) Seems Charecter set also diffrent though its superset.
[Edited by sreddy on 01-25-2001 at 04:03 PM]
-
Can someone help me re-create Data Dictionary/Catalog???
Running the following as SYS would be enough???
$ORACLE_HOME/rdbms/admin/catalog.sql
$ORACLE_HOME/rdbms/admin/catexp.sql
$ORACLE_HOME/rdbms/admin/catproc.sql
-
catalog.sql and catproc.sql would do.
Catalog.sql includes catexp.sql.
you can see that at the end of catalog.sql.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|