I need to export 60 tables to CSV file. 1 csv file per table.
I need help and need instructions on how to do this.
I am no export in oracle but here is what i researched.
Here is sample code that i researched using PL/SQL
Step 1.
create or replace procedure test_dump_csv
as
l_rows number
begin
l_rows := dump_csv( 'select *
from t1',
',', '/tmp', '[login to view URL]' )
end
/
Step2
dump_csv( 'select f1, f2 from t1',',', '/tmp', '[login to view URL]' )