Re: skipping tables on export

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Tue, 27 Jan 2015 20:09:05 -0500
Message-ID: <54C836B1.2000407_at_yahoo.com>

The only capability of the good, old exp/imp that I miss is the fact that I can no longer perform it on the client side.

On 01/27/2015 06:31 PM, anthony Sanchez wrote:
> I have a encountered this before, and the segments that were skipped
> were indeed the deferred ones. I used the scripts here to create the
> segments prior to export.
>
> http://mruhtel.blogspot.com/2012/03/oracle-11g-and-export-empty-tables.html
>
> You can also use data pump which is far superior to import/export in
> my opinion.
>
> Regards,
> Anthony Sanchez
>
> On Tue Jan 27 2015 at 2:37:57 PM Jure Bratina <jure.bratina_at_gmail.com
> <mailto:jure.bratina_at_gmail.com>> wrote:
>
> Probably because of deferred segment creation:
> http://oracle-base.com/articles/11g/segment-creation-on-demand-11gr2.php
> . exp doesn't export such objects, whereas DataPump does.
>
> Regards,
> Jure Bratina
>
> On Tue, Jan 27, 2015 at 10:28 PM, Don Seiler <don_at_seiler.us
> <mailto:don_at_seiler.us>> wrote:
>
> If you're on 11.2 I would definitely get familiar with
> expdp/impdp.
>
> On Tue, Jan 27, 2015 at 3:25 PM, Zelli, Brian
> <Brian.Zelli_at_roswellpark.org
> <mailto:Brian.Zelli_at_roswellpark.org>> wrote:
>
> Don’t have the log and I was using the good old
> exp……..could that be the problem?
>
> Brian
>
> *From:*Don Seiler [mailto:don_at_seiler.us
> <mailto:don_at_seiler.us>]
> *Sent:* Tuesday, January 27, 2015 4:22 PM
> *To:* Zelli, Brian
> *Cc:* oracle-l (oracle-l_at_freelists.org
> <mailto:oracle-l_at_freelists.org>)
> *Subject:* Re: skipping tables on export
>
> Can you post the log of the export operation, and the
> parameters or parameter file you're using? I assume you're
> using expdp (data pump)?
>
> On Tue, Jan 27, 2015 at 3:18 PM, Zelli, Brian
> <Brian.Zelli_at_roswellpark.org
> <mailto:Brian.Zelli_at_roswellpark.org>> wrote:
>
> I exported my prod schema to import into a test schema.
> It seems to be skipping tables while I am watching the
> import.
>
> I’ve never had that happen before. Why would it skip on
> export? 11gR2 on HPUX……
>
> Brian
>
>
> This email message may contain legally privileged and/or
> confidential information. If you are not the intended
> recipient(s), or the employee or agent responsible for the
> delivery of this message to the intended recipient(s), you
> are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited.
> If you have received this message in error, please notify
> the sender immediately by e-mail and delete this email
> message from your computer. Thank you.
>
>
>
>
> --
>
> Don Seiler
> http://www.seiler.us
>
>
> This email message may contain legally privileged and/or
> confidential information. If you are not the intended
> recipient(s), or the employee or agent responsible for the
> delivery of this message to the intended recipient(s), you
> are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited.
> If you have received this message in error, please notify
> the sender immediately by e-mail and delete this email
> message from your computer. Thank you.
>
>
>
>
> --
> Don Seiler
> http://www.seiler.us
>
>

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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

Received on Wed Jan 28 2015 - 02:09:05 CET