Database Utilities (MOSC)

MOSC Banner

EXPDP and large export files

edited Feb 7, 2011 7:54AM in Database Utilities (MOSC) 9 commentsAnswered
I am looking into using expdp for export backup for my production databases.  I am have a big dilemma because the size of my curent exp (.dmp) file is ranges from 20 to 40GB compresses w/ gzip.  I use the usual technique - open up a pipe, and compress the piple while exp is pouring data into it.  However, for expdp:

  • I am not able to open a pipe  using exp because expdp can not tolerate an exising file
  • I am not able to compress the file while export is running (natually)

Why wouldn't expdp allow an age old Operating System feature?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center