how to keep certain columns in a table when import?
Have a need that only want to import a few columns to a table and leave the other columns in the table untouched. Is it possible with impdp? For example,
Have a table T with 3 columns as follows:
T
---------
col1 col2 col3
Want to import only columns col1 and col2 and keep col3 untouched.
If impdp can not do that, is there any better way to achieve it?
Have a table T with 3 columns as follows:
T
---------
col1 col2 col3
Want to import only columns col1 and col2 and keep col3 untouched.
If impdp can not do that, is there any better way to achieve it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot.
ASKER