Re: Data Pump Import question

From: Powell, Mark <>
Date: Wed, 4 Dec 2019 19:59:58 +0000
Message-ID: <>

If the export is a full export it will try to create all tablespaces, users, etc... for you however if the source uses ASM and your site doesn't this will be a problem. I find it generally better to pre-create tablespaces and owning users with the necessary privileges. This eliminated file path issues.

If the export is a SCHEMA export I am pretty sure you must pre-create the target tablespaces. If the schema pre-exits impdp will give you a warning but will continue to import the target schema(s).

Mark Powell
Database Administration
(313) 592-5148

From: <> on behalf of Manjula Krishnan <> Sent: Tuesday, December 3, 2019 4:26 PM
To: ORACLE-L <> Subject: Data Pump Import question

Hi all: I received a 500GB compressed dump file from a vendor which I am to restore. I created a blank database for this to go into. Will the impdp utility create all the tablespace/schemas etc or do I need to pre-create all these?



DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA. DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.

Received on Wed Dec 04 2019 - 20:59:58 CET

Original text of this message