Re: skipping tables on export
- From: Jack Applewhite <jack.applewhite@xxxxxxxxxxxxx>
- To: "Powell, Mark" <mark.powell2@xxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jan 2015 17:02:11 +0000
Mark,
That's true. Fortunately we have a 64TB DataDomain system for our backups. It's
a self-contained SAN that does compression / expansion automatically - gets up
to 15/1 compression rates. All our ODA nodes have an NFS mount to it, so we do
all our DP and RMan backups to it. Space is not an issue for us - no more
gzipping required to save space. However, the method to which you refer is
certainly useful in normal DB server setups.
----
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk)
________________________________
From: Powell, Mark <mark.powell2@xxxxxx>
Sent: Wednesday, January 28, 2015 10:54 AM
To: Jack Applewhite; oracle-l@xxxxxxxxxxxxx
Subject: RE: skipping tables on export
Jack, true I forgot to mention that a local database on the client is still
required which is a major drawback, but you can sometimes use this alternate
expdp approach such as when you have an export file space issue on the source
server so I think it is worth knowing about.
From: Jack Applewhite [mailto:jack.applewhite@xxxxxxxxxxxxx]
Sent: Wednesday, January 28, 2015 11:43 AM
To: oracle-l@xxxxxxxxxxxxx; Powell, Mark
Subject: Re: skipping tables on export
Mark,
That MOS doc is somewhat misleading. The Client machine must have an Oracle DB
to which you connect in order to do the export from the DB specified by the DB
Link. You cannot us ExpDP to create a set of export files on a simple client
PC, for example. A database with a Directory to which you have read and write
privs on is always required.
We use DataPump extensively and do huge Exports/Imports across DB Links. It's a
great, great utility. I'm working right now on a PL/SQL package giving all our
developers the ability to backup and restore selected objects using the
DBMS_DataPump supplied package. It's taken a ton of reading the docs and
Googling to work out the correct syntax for all the procedures, but the results
are really slick.
HTH
----
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk)
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> on behalf
of Powell, Mark <mark.powell2@xxxxxx<mailto:mark.powell2@xxxxxx>>
Sent: Wednesday, January 28, 2015 8:35 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: RE: skipping tables on export
I have not done this but I believe that
You can run expdp from a client writing the file to the database server
You can run expdp from a client and write the export file to the client
Based on the following Oracle support note: How To Generate The DataPump Dump
File On The Sever Or On The Client Machine (Doc ID 1385324.1)
HTH
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Tuesday, January 27, 2015 8:09 PM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: skipping tables on export
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@xxxxxxxxx<mailto:jure.bratina@xxxxxxxxx>> 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@xxxxxxxxx<mailto:don@xxxxxxxxx>> 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@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>> 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@xxxxxxxxx<mailto:don@xxxxxxxxx>]
Sent: Tuesday, January 27, 2015 4:22 PM
To: Zelli, Brian
Cc: oracle-l (oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>> 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
Confidentiality Notice: This email message, including all attachments, is for
the sole use of the intended recipient(s) and may contain confidential student
and/or employee information. Unauthorized use of disclosure is prohibited under
the federal Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR
Part 99, 19 TAC 247.2, Gov't Code 552.023, Educ. Code 21.355, 29 CFR
1630.14(b)(c)). If you are not the intended recipient, you may not use,
disclose, copy or disseminate this information. Please call the sender
immediately or reply by email and destroy all copies of the original message,
including attachments.
Confidentiality Notice: This email message, including all attachments, is for
the sole use of the intended recipient(s) and may contain confidential student
and/or employee information. Unauthorized use of disclosure is prohibited under
the federal Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR
Part 99, 19 TAC 247.2, Gov't Code 552.023, Educ. Code 21.355, 29 CFR
1630.14(b)(c)). If you are not the intended recipient, you may not use,
disclose, copy or disseminate this information. Please call the sender
immediately or reply by email and destroy all copies of the original message,
including attachments.
Other related posts:
