Export , Import specific columns
I need your expertise here. I need to export tables and the data into another database. I will export the structure of the table and specific columns only, not all data are required. Only specific column data are needed to be exported.
Can Oracle export and import utilities do this straight away?
Thanks so much, your help is appreciated.
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g, 11g DBA
You can export the tables only without rows.
You could import the table and copy the selected columns, then drop the imported tables.
I remember when this place was cool.
Import the tables and drop the columns which you don't need.
create a temp table with the required column. export the same.
Click Here to Expand Forum to Full Width