Thanks Mark and Joe.
On Wed, Dec 4, 2019 at 2:00 PM Powell, Mark <mark.powell2@xxxxxxx> 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Manjula Krishnan <oradba.la@xxxxxxxxx>
*Sent:* Tuesday, December 3, 2019 4:26 PM
*To:* ORACLE-L <oracle-l@xxxxxxxxxxxxx>
*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. --.
