--1 导出26表数据 pub开头
exp mpaccs/[email protected]/mds file=/oradata/mdsbiaoshuju_pub26.dmp log=/oradata/mdsbiaoshuju_pub26.log statistics=none buffer=8192000 tables=PUB_APP,PUB_CANT,PUB_CANT_TYPE,PUB_CMD_LOG,PUB_COMMON_SINGLE_PARMS,PUB_CONF_ROLES,PUB_CONF_ROLESET,PUB_COUNTRY,PUB_DATA_RES_TYPE,PUB_DOC_CONTENT,PUB_DOMAIN,PUB_DOMAIN_ADMIN,PUB_DOMAIN_RESOURCE,PUB_DOMAIN_RESOURCE_BAK1,PUB_DOMAIN_STRU,PUB_D_DEV_BATCH_INFO_BAK,PUB_EXAMPLE_ORGAN,PUB_FIN_MONTH,PUB_FIN_MPERIOD,PUB_FIN_PTYPE,PUB_FIN_YEAR,PUB_FUNCTIONS,PUB_GET_BACK_PASSWORD,PUB_GLOBAL,PUB_GLOBALPARMS,PUB_HR_EVENT,PUB_HR_EVENT_TYPE,PUB_IDTABLE,PUB_ISC_FUNCTIONS,PUB_LDAP_USER,PUB_MENU_PERITEM,PUB_MENU_STRU,PUB_MENU_STRU_TYPE,PUB_MENU_SYS,PUB_MENU_SYSITEM,PUB_MENU_TEMPLATES,PUB_MENU_TYPE,PUB_MODULES,PUB_ONLINE,PUB_ONLINE_HIST,PUB_ORGAN,PUB_ORGAN_HIST,PUB_ORGAN_PARMS,PUB_ORGAN_PARMS_T,PUB_ORGAN_TYPE,PUB_ORGAN_WORKDAY,PUB_PARA,PUB_PASSWORD_HIST,PUB_PERMIT,PUB_RESOURCES,PUB_RES_EXT_TYPE,PUB_RES_TYPE,PUB_ROLES,PUB_ROLE_ACCESS,PUB_ROLE_PERMIT,PUB_ROLE_PRIVS,PUB_ROLE_RESOURCE,PUB_ROLE_RESOURCE_BAK,PUB_ROLE_RESOURCE_BAK1,PUB_ROLE_TYPE,PUB_SAME_CLIENT,PUB_SCN_INFO,PUB_SECURITY_LEVEL,PUB_SECURITY_LOG,PUB_SECURITY_LOG_BAK_20170525,PUB_SESSION,PUB_STRU,PUB_STRU_HIST,PUB_STRU_RULE,PUB_STRU_TYPE,PUB_STRU_TYPE_REF,PUB_STRU_VERSION,PUB_TEMPLATES,PUB_TMENU_SYS,PUB_TMENU_SYSITEM,PUB_TROLES,PUB_TROLE_OPTS,PUB_TROLE_PERMIT,PUB_URLS,PUB_USERROLE_AUDIT,PUB_USERS,PUB_USER_AUDIT,PUB_USER_DATAREF,PUB_USER_FUNC_RESOURCE,PUB_USER_FUNC_RESOURCE_BAK,PUB_USER_FUNC_RESOURCE_BAK1,PUB_USER_HIST,PUB_USER_IP,PUB_USER_MAP,PUB_USER_MENU,PUB_USER_PARMS,PUB_USER_PROFILE,PUB_USER_PROXY,PUB_USER_RES_DATAREF,PUB_USER_ROLE,PUB_USER_ROLE_BAK,PUB_USER_STRU_TEMP,PUB_USER_TIME,PUB_WORKPLACEexp mpaccs/[email protected]
