Re: Data Pump Import question

From: Manjula Krishnan <>
Date: Wed, 4 Dec 2019 15:09:19 -0600
Message-ID: <>

Thanks Mark and Joe.

On Wed, Dec 4, 2019 at 2:00 PM Powell, Mark <> wrote:

> 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?
> Thanks,
> Manjula
> 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 - 22:09:19 CET

Original text of this message