ORA-6512 During Full Export

Running Oracle 10.2.0.3 on Solaris 10. Encountered the error below when testing a full export after applying CPUJan2008. Encountered the same error previously in another database after applying CPUOct2007 on an Oracle 9.2.0.8 database.

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifier ‘SYS.DBMS_DEFER_IMPORT_INTERNAL’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at “SYS.DBMS_SYS_SQL”, line 1204
ORA-06512: at “SYS.DBMS_SQL”, line 323
ORA-06512: at “SYS.DBMS_EXPORT_EXTENSION”, line 97
ORA-06512: at “SYS.DBMS_EXPORT_EXTENSION”, line 126
ORA-06512: at line 1

Metalink Note 464672.1 lists the problem as Bug 6392040 and provides a solution.

GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO <user_name>;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO <user_name>;

One important statement to consider from Metalink Note 464672.1:

“There is no fix in this bug because the export utility is no longer supported in 11g and should be replaced by the Data Pump Export.”

Additional References
Metalink Note 464862.1 – “EXP-00008 PLS-00201 When Performing Full Database Export After Applying CPUOCT2007”

Bug 6510213 – “INSTALLED CPUOCT2007; NOW EXP GETS THE ERRORS EXP-00008,ORA-06550,PLS-00201”

Advertisements

17 Responses to ORA-6512 During Full Export

  1. Matt says:

    Hi,

    Just FYI – I got the same problem on 9.2.0.8.

    Cheers

    Matt

  2. Tegan says:

    hi!,I love your writing very a lot! proportion we be in contact more approximately your article on AOL?

    I require a specialist on this space to solve my problem.
    May be that is you! Taking a look forward to peer you.

  3. whiten teeth says:

    It is not my first time to pay a quick visit this site, i am browsing this web
    site dailly and obtain good information from here everyday.

  4. I’ve been surfing online more than three hours today, yet I never
    found any interesting article like yours. It’s pretty worth enough for me.

    In my opinion, if all webmasters and bloggers made good content as
    you did, the web will be a lot more useful than ever before.

  5. Everything is very open with a clear description of the challenges.

    It was definitely informative. Your website is very helpful.

    Thanks for sharing!

  6. This article provides clear idea in support of the new users of blogging, that in fact how
    to do blogging and site-building.

  7. health care says:

    I am truly glad to read this weblog posts which includes tons of helpful information, thanks for providing such statistics.

  8. Johnson says:

    I used to be recommended this website via my cousin.
    I’m now not sure whether or not this publish is written by him as no one
    else recognize such special approximately my problem.
    You’re amazing! Thanks!

  9. Superb blog! Do you have any tips and hints for aspiring writers?
    I’m hoping to start my own site soon but I’m a little lost on everything.

    Would you recommend starting with a free platform like WordPress or go for a paid option?
    There are so many options out there that I’m completely confused
    .. Any suggestions? Bless you!

  10. Hi to every body, it’s my first pay a visit of this website; this blog includes awesome and really good stuff designed for visitors.

  11. I know this web site gives quality based articles or reviews
    and additional information, is there any other website which provides
    these stuff in quality?

  12. I was very happy to discover this website.
    I want to to thank you for your time just for this wonderful read!!

    I definitely really liked every part of it and i also have you
    saved to fav to check out new stuff in your blog.

  13. Leland says:

    Im Nordosten des Landes, nahe der Grenze zur Slowakei,
    sind die Temperaturen etwas niedriger als im Westen Tschechiens.

  14. Die Deutsche Hochdruckliga empfiehlt Bluthochdruckpatienten ausreichend Sport und
    Ruhephasen für den Körper im Alltag zu integrieren.

  15. Der Bio Diät Shake besteht aus natürlichen Fruchtkonzentraten und ist daher bedenkenlos für Ihre Gesundheit.

  16. Florine says:

    Dazu sollte man sich ausgewogen und gesund ernähren,
    sich mindestens drei Mal pro Woche sportlich betätigen und übermäßigen Stress vermeiden.

  17. Im Umkehrschluss bedeutet dies, bei Kindern die zu wenig schlafen, kann sich eine Wachstumsstörung einstellen.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: