Problem solve
Get help with specific problems with your technologies, process and projects.
Exporting a column from a table for later import
I want to export a column in a table and import it later. I have faced a situation where I had to export only four colunms in a table containing 20 columns.
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:
spool emp_ename.txt SELECT ename FROM scott.emp; spool offWith 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.
