I want to export a column in a table like (column ename in emp table) and import it later. I have faced a situation where I had to export only four colunms in a table containing 20 columns.
Oracle's export utility will export all columns of a table. You cannot use exp or 10g's new Data Pump, expdp, to export only specific columns of a table. If you want to export just one column of data from a table, then I would recommend simply using SQL*Plus and spooling the output to a file, similar to the following:
SELECT ename FROM scott.emp;
With the above commands in SQL*Plus, you will have a text file containing the output of just the ENAME column of the SCOTT.EMP table.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.