Export

Oracle Export Through a Named Pipe with mknod for Space-Constrained Hosts Purpose Oracle's original Export utility (exp) writes a binary dump file. On production hosts where disk space is tight — where staging a full-database dump and its compressed copy simultaneously would exhaust the filesystem — the classic …

Oracle exp/imp Parameter File: Direct Path User-to-User Data Migration Using a parameter file (parfile) with Oracle's legacy exp and imp utilities is a clean, repeatable way to move schema data between users — especially when you need speed, control over what gets transferred, and a consistent log trail. This post …

Oracle Optimizer Statistics Transfer Guide This guide demonstrates how to migrate schema statistics between Oracle databases using DBMS_STATS procedures - crucial for maintaining consistent execution plans across environments. Exporting and importing optimizer statistics in Oracle Database is essential for maintaining …