Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • move_arch_files.ksh Linux/Unix
  • pvm_pre_change.sql Oracle
  • Unix command for system configuration Linux/Unix
  • find the files that are 1 day old. Linux/Unix
  • replace alphabets using sed Linux/Unix
  • Oracle Internal Good Websites 1 Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • My Test Case On 21-OCT-2005 Oracle
  • Export Import with QUERY Oracle
  • Wait Based Tuning Step by step with SQL statement Oracle
  • Temporary tablespace explaination Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • Rollback force for distributed transactions Oracle
  • Jai Shree Ram Oracle
  • Temporary Tablespace Information and restriction. Oracle

Export Oracle data and Compress at same time

Posted on 23-Aug-2005 By Admin No Comments on Export Oracle data and Compress at same time

If one cannot afford to buy extra disk space one can run the export and compress utilities simultaneously. This will prevent the need to get enough space for both the export file AND the compressed export file. Eg:

# Make a pipe

mknod expdat.dmp p # or mkfifo pipe

# Start compress sucking on the pipe in background

compress < expdat.dmp > expdat.dmp.Z &

# Wait a second or two before kicking off the export

sleep 5

# Start the export

exp scott/tiger file=expdat.dmp

Or export accross the network directly into the target database:

Host A:

mknod FIFO.dmp p

exp u/p FILE=FIFO.dmp rest_of_parameters…

Host B:

mknod FIFO2.dmp p

rsh host1 dd if=FIFO.dmp > FIFO2.dmp &

imp u/p FILE=FIFO2.dmp rest_of_parameters

Oracle, SQL scripts

Post navigation

Previous Post: How does one overcome the Unix 2 Gig file limit?
Next Post: Oracle Data Direct to TAPE

Related Posts

  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Identical Dblink Issue… Oracle
  • Finding Oracle Patches with opatch Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to choose Driver table in SQL statement Oracle
  • tar and untar a dolder with all its subfolder. Linux/Unix
  • on IBM-AIX for display Linux/Unix
  • Zip and unzip with tar Linux/Unix
  • To find all disk io ( EMC as well as local) Linux/Unix
  • alter database backup controlfile to trace Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme