Database Utilities (MOSC)

MOSC Banner

import (using impdp) specific table from full dump file

edited Jun 8, 2015 12:14PM in Database Utilities (MOSC) 10 commentsAnswered

I have oracle database , I made full expdp from this database at 22-2-2014 which generates dump file called "fulldmp22-feb-14.dmp" for this day resident in directory called My_Backup

now at 5-3-2014 I created a new user called kamtst , I want to use the file  "fulldmp22-feb-14.dmp" to import the data of specific table called cash_trans resident in user called kam06 into kamtst.

how can I do that using impdp

Thanks a lot

Fady.

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