Oracle Database Discussions

All,

I like to export and import some selected columns and rows of a table from one oracle database to another database.

For example, I like to export the following SQL's result data to another oracle database.

select ename, sal from emp where dno = 100;

Can I create a database view based on the above SQL and export the view with data (I don't think data will be exported along with database view?)

I know, I can do this either with SQL*Loader or by creating DBLink between databases and using insert-select statement.


Please let me know if this is possible in exp/imp.

Appreciate your help.

Thanks

Kumar