Skip to Main Content
  • Questions

  • Error importing a DMP file to a very different database

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Pedro.

Asked: January 17, 2018 - 3:36 pm UTC

Last updated: January 18, 2018 - 9:52 am UTC

Version: 11G

Viewed 1000+ times

You Asked

I created a completely new oracle database and I am trying to import a DMP file from a full backup of another database and I am getting several errors. Can you help me:

Command: impdp system/welcome1 full=yes directory=BACKUPSDR dumpfile=bck_full_AXISPROD_15012018.dmp logfile=bck_full_AXISPROD_15012018.LOG

Error: Processing object type DATABASE_EXPORT/TABLESPACE ORA-39083: Object type TABLESPACE failed to create with error: ORA-02236: invalid file name Failing sql is: CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 209715200 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE

and Chris said...

The problem is this statement doesn't specify a datafile:

CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 209715200 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE


You can get around this by using Oracle Managed Files. For instructions on how to do use this, read:

https://docs.oracle.com/cd/E11882_01/server.112/e25494/omf.htm#ADMIN003

Or creating the tablespaces manually before you import.

But this is creating an undo tablespace. The database you're importing to will already have one of these. So you can skip this one.

Rating

  (1 rating)

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

Comments

Pedro Nunes, January 18, 2018 - 3:30 pm UTC

Thanks for the note it was even helpful
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.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database