Re: Data Pump Import question

Thanks Mark and Joe.

On Wed, Dec 4, 2019 at 2:00 PM Powell, Mark <mark.powell2_at_dxc.com> 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:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Manjula Krishnan <oradba.la_at_gmail.com>
> *Sent:* Tuesday, December 3, 2019 4:26 PM
> *To:* ORACLE-L <oracle-l_at_freelists.org>
> *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. --.
>

--
http://www.freelists.org/webpage/oracle-l