how to use exp/imp only for specific columns?

hallo!

i have for example the following situation:

a table on site a tab1(a_key integer,

	               a_val1 varchar(500),
                        a_val2 varchar(1000))

and a table on site b tab2((b_key integer,
                        b_val2 varchar(1000),
	               b_val3 integer)

is it possible to use the export/import utility or the sql loader to transfer only the data of the columns a_key and a_val2 from tab1 to tab2(into b_key, b_val2)?

in the documentation of export, i have only found the QUERY parameter, but it can only limit the rows not the columns which should be exported.

if i have a direct database connection i can use "insert into tab2(b_key,b_val2) (select a_key, a_val2 from tab1)"

but how can a make this with export/import utility or sql loader?

what i need is a way to export only specific columns of a table and to import these export into tables with different column names and order.

where can i find the missing information?

thanks
andreas Received on Wed Mar 24 2004 - 04:39:47 CST