I am having a table which is having around 11 million records. Now I have to take this table from one DB to another one so I am using exp and imp. But we want to use SQLLoader so how to extract the tables into flat files using PL/SQL. Any Help?
So far no one beats sqlloader direct path speed in loading data,
so if u knew ur data well yo can spool it using..
set echo off
set pages 0
set feedback off
set verify off
set term off
set heading off
select '~'||column1||'~'||column2||'~'...||'~' from table_name;
if date format is not the default use to_char(date_column,'yyyymmdd hh:mi:ss')
use the .ctl delimited by '~'
I often use this but not tried with tables having images saved