Hi Team,
I would like to export a table using sqlplus(instantclient) client remotely. I am database user(schema user) and not database administrator.
Below link gives how to export table using sql developer UI client. Iam sure this can be done through using command line also using instantclient.
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLdev3.0_Import_Export/sqldev3.0_import_export.…
I have some code like below to export table data in csv format but it is not same as when i export the table using SQL Developer client using UI.
set colsep , -- separate columns with a comma
set pagesize 0 -- No header rows
set trimspool on -- remove trailing blanks
set headsep off -- this may or may not be useful...depends on your headings.
set linesize X -- X should be the sum of the column widths
set numw X -- X should be the length you want for numbers (avoid scientific notation on IDs)
spool myfile.csv
why its not possible to do using sqlplus( instantclient ) when it is possible to do through SQL Developer. Both are clients connecting to database using schema name and password.
Please help to get the exact functionality same as SQL Developer for exporting table. I am trying