How to import a specified table?
Detailed explanation:
D: /> exp scott / tiger file = a.dmp
D: /> IMP test / test fromuser = scott tables = EMP file = a.dmp
D: /> IMP test / test tables = dept file = a.dmp
Description:
If the export user does not have DBA permissions, the import user can do not specify fromuser, Touser parameters
If the export user has DBA permissions, import users must have DBA privileges.