Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i to 8i problem

Re: Oracle 9i to 8i problem

From: MC <morgonc_at_yahoo.com>
Date: 12 Nov 2002 17:13:36 -0800
Message-ID: <1c458600.0211121713.1166fc2d@posting.google.com>


Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA702E9D870_at_lnewton.leeds.lfs.co.uk>...

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.

> Morning MC,
>
> 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.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
>
>
> -----Original Message-----
> From: morgonc_at_yahoo.com (MC) [mailto:morgonc_at_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>
Received on Tue Nov 12 2002 - 19:13:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US