通过imp命令导入:
. . importing partition "T_CMS_HB_PROCESS_LOG_3G":"PARTMAX" 1694 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "T_CMS_HB_PROCESS_LOG_3G" TO "WNMS_GRID""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'WNMS_GRID' does not exist
导入数据时,赋予 名为WNMS_GRID的用户或角色 这个表T_CMS_HB_PROCESS_LOG_3G的查询权限,但是WNMS_GRID不存在,如果WNMS_GRID没什么用的话,可以忽略这个错误 ,导入命令加上 IGNORE=Y