ORACLE IMPORT PROBLEM
09/02/2019 11:47
Hi, I'm new to Oracle so I thought someone here might be able to help me.

I'm trying to do a schema import using imp and i get the following inthe import log file (below). It looks like the like PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared is where the errorcascade begins. How do I declare 'SYS.DBMS_LOGREP_IMP' ? import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR characterset. importing EXMETA's objects into EXMETAIMP-00017: following statement failed with ORACLE error 6550: BEGIN sys.dbms_logrep_imp.instantiate_schema(schema_name=>'EXMETA',export_db_n ame=>'EXIMTD.SYS_NAME.COM', inst_scn=>'66741801'); COMMIT; END;IMP-00003: ORACLE error 6550 encounteredORA-06550: line 2, column 1: PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declaredORA-06550: line 2, column 1: PL/SQL: Statement ignoredIMP-00017: following statement failed with ORACLE error 922: CREATE TABLE ECD_ACCRULE_SET (RULE_ID VARCHAR2(12) NOT NULLENABL etc. etc.

Any help would be appreciated.

Many Thanks.


Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
09/02/2019 11:47 - You provide precious little info: - what version(s) of Oracle?- what errors bother you (the IMP-00017/ORA-06650, or the IMP-00003/ORA-06650, or all)- how was the export made (command line options, please)- how do you attempt to import (ditto)

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below