Oracle 9i to 8i problem
MC
I exported objects under a schema in Oracle 9i using v8.1.7
export and import them into another database running Oracle 8.1.7.
When I imported the file, following error exists:
-----
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 conventional path
Warning: the objects were exported by MMSBAT, not by you
import done in US7ASCII character set and US7ASCII NCHAR character set
export server uses UTF8 NCHAR character set (possible ncharset
conversion)
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'PMAS01',
export_db_nam"
"e=>'MMSP.WORLD', inst_scn=>'327056909');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
-----
Anyone know why and how to fix it?
Thanks in advance
MC.
Norman Dunbar
to be honest, it looks like the import is fine - did the error occur at
the end after the tables etc were imported ?
I've seen something like this myself - this is the giveaway error :
>> PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
It looks like the last bit of the import is being done where it compiles
procs, functions, packages and this is a simple PL/SQL error whereby a
proc/fn/package has made a call to a routine it does not have privileges
to do so. Whichever user you are imprting into needs to have privs given
to sys.dbms_logrep_imp then you can simply recompile the offending
proc/fn/package.
Looking at the 817 docs, sys.dbms_logrep_imp is not mentioned, nor does
it appear in the list of packages under SYS on my 8174 database(s),
however, it does appear under SYS on my 9iR2 (920) database - so it
looks as if it is 9i specific. It is also not mentioned in the 9i docs,
or on Tahiti.
There are a couple of jits on Metalink - problems importing into 9.01
from 9.2 - so it looks like the LOGREP stuff may be 9iR2 specific.
Metalink says to ignore error on imports which relate to SYS or SYSTEM
objects when going backwards between versions.
Looks like you are ok !
Cheers,
Norman.
-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman...@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: mor...@yahoo.com (MC) [mailto:mor...@yahoo.com]
Posted At: Tuesday, November 12, 2002 9:28 AM
Posted To: server
Conversation: Oracle 9i to 8i problem
Subject: Oracle 9i to 8i problem
Dear All.
I exported objects under a schema in Oracle 9i using v8.1.7
export and import them into another database running Oracle 8.1.7.
When I imported the file, following error exists:
<SNIP>
MC
Thank you Norman.
The error occurred when the import start and all objects were imported
successfully after the error. I checked against the metalink and
found that it was an Oracle 9i specific bug. Hopefully, it will have
patch to fix it soon.
Anyway, thanks.
cheers
MC.