RE: Data Pump Import question

From: Sweetser, Joe <>
Date: Tue, 3 Dec 2019 21:30:27 +0000
Message-ID: <>

I believe you will need to pre-create the tablespaces. Datapump should handle the rest.


From: <> On Behalf Of Manjula Krishnan Sent: Tuesday, December 3, 2019 2:27 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?


This e-mail transmission and any attachments that accompany it may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law and is intended solely for the use of the individual's to whom it was intended to be addressed. If you have received this e-mail by mistake, or you are not the intended recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited. If you have received this communication in error, please immediately reply to the author via e-mail that you received this message by mistake and also permanently delete the original and all copies of this e-mail and any attachments from your computer. Please note that coverage cannot be bound or altered by sending an email. You must receive written confirmation from a representative of our firm to put coverage in force or make changes to an existing policy.
-- Received on Tue Dec 03 2019 - 22:30:27 CET

Original text of this message