Skip to Main Content
  • Questions

  • Error while importing an Oracle 9 dump in Oracle 11g

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Andreea.

Asked: February 10, 2016 - 10:39 am UTC

Last updated: February 11, 2016 - 2:41 am UTC

Version: 11g

Viewed 1000+ times

You Asked

I need to import an Oracle9i Release 9.2.0.6.0 dump in an Oracle 11g. Using the import command I have a ton of erros like this:

IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 6550 encountered
Th command I use is:

imp system/<passwor>@<SID> file=export_20160209.dmp fromuser=USER1 touser=USER1 log=file_log_10022016.log

How else can I make the import I need?

and Connor said...

Interestingly, in the Upgrade guide it states that there should not be an issue.

"Export and Import Requirements for Upgrades

Dump files created by one of the Export utilities can be imported into all future releases of Oracle Database. For example, an Oracle8 original Export dump file can be imported by the Oracle8i, Oracle9i, Oracle Database 10g, and Oracle Database 11g original Import utility."

and then there is a table of support from/to versions, and yours is included.

Try this in your target environment:

grant execute on DBMS_EXPORT_EXTENSION to public

and see how you go.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

It's not working.

Andreea, February 10, 2016 - 12:45 pm UTC

I've already tried thaht and it's still not working.
Connor McDonald
February 11, 2016 - 2:41 am UTC

In that case, I'll think you'll have to log a support call. Quote the statements from the upgrade guide.

Please let us know if you get to a working resolution.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.