Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Import and export statements Oracle
  • Reading config file from other folder inside class Python/PySpark
  • scripts to take listener.log backup Linux/Unix
  • CTAS with LONG Column for 9i and higher Oracle
  • Changing Instance Name ( No DB_NAME) Oracle
  • Kernel Parameters for Solaris Linux/Unix
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • how to find OS block size Oracle
  • Sending email with file attachment. Linux/Unix
  • Configure ssh authentications for RAC Oracle
  • Oracle Release Explaination Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • Explain Plan Output 2 Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • sess_server.sql 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

  • Find nth max and min. Oracle
  • UNderstand and eliminate Latch contention. Oracle
  • Physical Standby switchover with session active Oracle
  • All About Trace Fils Oracle
  • How to analyze statspack or AWR report. Oracle
  • How to find where datafile is created dbf_info.sql 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
  • initUOCIOTTO.ora Oracle
  • Default User Profile Oracle
  • move_arch_files.ksh Linux/Unix
  • How to set Processes Parameter Oracle
  • DBMS_SQL for alter session. Oracle
  • Read CSV File using Python Python/PySpark
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • tuning commmand for cpu, ip and memory stats Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme