How to import a specified table?

zhaozj2021-02-16  47

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.

转载请注明原文地址:https://www.9cbs.com/read-26070.html

New Post(0)