aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter

IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter
Cause: A table name was qualified with the name of its owner, as shown in the following example. This is not allowed. IMP SYSTEM/MANAGER TABLES=(SCOTT.EMP)
Action: Use the FROMUSER parameter to specify the table's owner, as shown in the following example: IMP SYSTEM/MANAGER FROMUSER=SCOTT TABLES=(EMP, DEPT)

请先 登录 后评论

1 个回答

小智
IMP-00029:无法通过所有者(字符串)限定表名称,请使用FROMUSER参数,
.原因:表名称使用其所有者的名称限定,如以下示例所示。这是不允许的。IMP SYSTEM / MANAGER TABLES =(SCOTT.EMP),
.操作:使用FROMUSER参数指定表的所有者,如以下示例所示:IMP SYSTEM / MANAGER FROMUSER = SCOTT TABLES =(EMP,DEPT),
.
请先 登录 后评论