顺便说一下,这个用户是有DBA权限的,我看了一下,下面这些表就是用表空间方式无法导入导出的:
SQL> select object_name,object_type from user_objects
2 where object_type='VIEW'
3 or (object_type='TABLE' and (object_name like 'EVT%' or object_name like 'SM%'));
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
EVT_CARRIER_CONFIGURATION TABLE
EVT_DEST_PROFILE TABLE
EVT_HISTORY TABLE
EVT_INSTANCE TABLE
EVT_MAIL_CONFIGURATION TABLE
EVT_MONITOR_NODE TABLE
EVT_NOTIFY_STATUS TABLE
EVT_OPERATORS TABLE
EVT_OPERATORS_ADDITIONAL TABLE
EVT_OPERATORS_SYSTEMS TABLE
EVT_OUTSTANDING TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
EVT_PROFILE TABLE
EVT_PROFILE_EVENTS TABLE
EVT_REGISTRY TABLE
EVT_REGISTRY_BACKLOG TABLE
SMP_UPDATESERVICES_CALLED VIEW
SMP_SERVICE_ITEM VIEW
SMP_SERVICE_GROUP_DEFN VIEW
SMP_SERVICE_GROUP_ITEM VIEW
SMP_AD_NODES VIEW
SMP_AD_DISCOVERED_NODES VIEW
SMP_AD_ADDRESSES VIEW
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMP_AD_PARMS VIEW
SMP_AUTO_DISCOVERY_ITEM VIEW
SMP_AUTO_DISCOVERY_PARMS VIEW
SMP_SERVICE_DATA VIEW
SMP_JOB VIEW
SMP_JOB_HISTORY VIEW
SMP_JOB_INSTANCE VIEW
SMP_JOB_TASK_INSTANCE VIEW
SMP_JOB_LIBRARY VIEW
SMP_CREDENTIALS VIEW
SMP_BRM_ACTIVE_JOB VIEW
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMP_BRM_TEMP_SCRIPTS VIEW
SMP_BRM_RC_CONNECT_STRING VIEW
SMP_BRM_DEFAULT_CHANNEL VIEW
SMP_BRM_CHANNEL_DEVICE VIEW
SMHOST_V VIEW
SMPRODUCT_V VIEW
SMINSTALLATION_V VIEW
SMINSTALLED_PRODUCT_V VIEW
SMP_LONG_TEXT VIEW
SMP_BLOB VIEW
SMP_VAR_LIST_DATABASES VIEW
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMP_EBU_SAVED_JOB VIEW
SMP_EBU_ACTIVE_JOB VIEW
SMP_VAB_SAVED_JOB VIEW
SMP_VAB_ACTIVE_JOB VIEW
SMP_BRM_SAVED_JOB VIEW
SMCLIENT_V VIEW
SMCLIENT_INSTALLATION_V VIEW
SMFOLDER_V VIEW
SMHOST_ONLY_FOLDER_V VIEW
SMCLIENT_ONLY_FOLDER_V VIEW
SMHOST_FOLDER_MAP_V VIEW
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMCLIENT_FOLDER_MAP_V VIEW
SMACTUALPARAMETER_S TABLE
SMAGENTJOB_S TABLE
SMARCHIVE_S TABLE
SMBREAKABLELINKS TABLE
SMCLIQUE TABLE
SMCONFIGURATION TABLE
SMCONSOLESOSETTING_S TABLE
SMDATABASE_S TABLE
SMDBAUTH_S TABLE
SMDEFAUTH_S TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMDEPENDENTLINKS TABLE
SMDISTRIBUTIONSET_S TABLE
SMFOLDER_S TABLE
SMFORMALPARAMETER_S TABLE
SMGLOBALCONFIGURATION_S TABLE
SMHOSTAUTH_S TABLE
SMHOST_S TABLE
SMINSTALLATION_S TABLE
SMLOGMESSAGE_S TABLE
SMMONTHLYENTRY_S TABLE
SMMONTHWEEKENTRY_S TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMMOWNERLINKS TABLE
SMOMSTRING_S TABLE
SMOSNAMES_X TABLE
SMOWNERLINKS TABLE
SMPACKAGE_S TABLE
SMPARALLELJOB_S TABLE
SMPARALLELOPERATION_S TABLE
SMPARALLELSTATEMENT_S TABLE
SMPRODUCTATTRIBUTE_S TABLE
SMPRODUCT_S TABLE
SMP_AD_ADDRESSES_ TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMP_AD_DISCOVERED_NODES_ TABLE
SMP_AD_NODES_ TABLE
SMP_AD_PARMS_ TABLE
SMP_AUTO_DISCOVERY_ITEM_ TABLE
SMP_AUTO_DISCOVERY_PARMS_ TABLE
SMP_BLOB_ TABLE
SMP_BRM_ACTIVE_JOB_ TABLE
SMP_BRM_CHANNEL_DEVICE_ TABLE
SMP_BRM_DEFAULT_CHANNEL_ TABLE
SMP_BRM_RC_CONNECT_STRING_ TABLE
SMP_BRM_SAVED_JOB_ TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMP_BRM_TEMP_SCRIPTS_ TABLE
SMP_CREDENTIALS$ TABLE
SMP_EBU_ACTIVE_JOB_ TABLE
SMP_EBU_SAVED_JOB_ TABLE
SMP_JOB_ TABLE
SMP_JOB_EVENTLIST_ TABLE
SMP_JOB_HISTORY_ TABLE
SMP_JOB_INSTANCE_ TABLE
SMP_JOB_LIBRARY_ TABLE
SMP_JOB_TASK_INSTANCE_ TABLE
SMP_LONG_TEXT_ TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMP_REP_VERSION TABLE
SMP_SERVICES TABLE
SMP_SERVICE_DATA_ TABLE
SMP_SERVICE_GROUP_DEFN_ TABLE
SMP_SERVICE_GROUP_ITEM_ TABLE
SMP_SERVICE_ITEM_ TABLE
SMP_UPDATESERVICES_CALLED_ TABLE
SMP_USER_DETAILS TABLE
SMP_VAB_ACTIVE_JOB_ TABLE
SMP_VAB_SAVED_JOB_ TABLE
SMP_VAR_LIST_DATABASES_ TABLE
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
SMRELEASE_S TABLE
SMRUN_S TABLE
SMSCHEDULE_S TABLE
SMSHAREDORACLECLIENT_S TABLE
SMSHAREDORACLECONFIGURATION_S TABLE
SMTABLESPACE_S TABLE
SMVCENDPOINT_S TABLE
SMWEEKLYENTRY_S TABLE