Export and Import using unix pipes and compression
EXPORT AND IMPORT USING UNIX PIPES. Sometimes, the space on disk may not be enough to hold a full export dump if uncompressed. EXAMPLE – export schema ARJUN from PROD database and import into DEV database. To avoid space running out, unix pipes and compression can be used. EXPORT IN PROD DATABASE cd /u02/oradata/export CREATE […]