Dear friends,
I try to export csv from a partitoned table ( 300GB ) it takes 6 hours (only one table), using following code
set term off
set feed off
set colsep '|'
set echo off
set feedback off
set linesize 1000
set pagesize 0
set trimspool on
SET TERMOUT OFF
spool '/backup/csv/Mytable.csv'
SELECT /*+ parallel */ /*csv*/ col1 || '|' || col2 || '|' || col3 FROM MySchema.MyTable ;
spool off
exit;
but when I export (using expdp ) all of tables under the schema & its data (3TB) it takes only 20 minutes!
why expdp is very fast comparing to sqlplus spool ?
what is the fast method to export csv from oracle table ?
regards
Siya AK
Hardware 4 TB Ram + 196 core cpu + rapid nvme disk
oracle 11g r2