OraFAQ Forum: Server Utilities » table mode exp/imp

Home » RDBMS Server » Server Utilities » table mode exp/imp (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table mode exp/imp [message #402554]

Mon, 11 May 2009 08:10

rajasekhar857
Messages: 500
Registered: December 2008

Senior Member

hi,
i am having a dmp file which i have performed with full mode
like exp x/x file=xyz.dmp log=xyz.dmp
imp x/x file=xyz.dmp fromuser=x touser=x

if i want to use table mode to perform by creating a blank database and want to imp with the existing dmp file and want to imp only tables like for example a and b from the existing dmp file what is cthe command i have to use?

Report message to a moderator