Database Utilities (MOSC)

MOSC Banner

How to Export/Import specific/selected table columns (can database view be exported with data?)??

edited Jun 20, 2018 4:53PM in Database Utilities (MOSC) 5 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center