linux上导入1个G的dmp,导出来只有不到5M

在centos7的oracle上创建新用户后,导入了一个1G多的dmp文件,再将这个用户导出时只有几个M

[oracle@oracle-test ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK[oracle@oracle-test ~]$ exp isc/isc@192.168.157.132:1521/orcl file=/disk3/expisc/tisc.dmp owner=isc

Export: Release 11.2.0.1.0 - Production on Tue Jan 14 12:36:23 2020

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ISC 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ISC 
About to export ISC's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ISC's tables via Conventional Path ...
. . exporting table              HR_ORG_BASIC_INFO          0 rows exported
. . exporting table         HR_ORG_BASIC_INFO_TEMP          0 rows exported
. . exporting table             HR_POST_BASIC_INFO          0 rows exported
. . exporting table             HR_USER_BASIC_INFO          0 rows exported
. . exporting table                    ISC_ACCOUNT          4 rows exported
. . exporting table           ISC_ACCOUNT_EXT_PROP          0 rows exported
. . exporting table               ISC_ACTOR_ROLE_R       4362 rows exported
. . exporting table                ISC_APPLICATION          3 rows exported
. . exporting table               ISC_APPSHOW_CONF          1 rows exported
. . exporting table              ISC_APP_CODE_CONF          0 rows exported
. . exporting table         ISC_APP_CODE_FIELD_EXT          0 rows exported
. . exporting table          ISC_APP_DATARESOUCE_R          3 rows exported
. . exporting table           ISC_AUTHORIZE_COMMIT          0 rows exported
. . exporting table                    ISC_BASEORG       8801 rows exported
. . exporting table           ISC_BASEORG_EXT_PROP          0 rows exported
. . exporting table       ISC_BASEORG_SPORG_UNIT_R          0 rows exported
. . exporting table               ISC_COMMON_CONST        196 rows exported
. . exporting table                     ISC_DEPLOY          2 rows exported
. . exporting table                        ISC_DIM          0 rows exported
. . exporting table                       ISC_DUTY          0 rows exported
. . exporting table                 ISC_LOGIN_LOCK         36 rows exported
. . exporting table                  ISC_MAIL_CONF          0 rows exported
. . exporting table         ISC_MAIL_TEMPLATE_CONF          0 rows exported
. . exporting table        ISC_MDMORG_SPORG_UNIT_R          0 rows exported
. . exporting table                    ISC_MDM_ORG          0 rows exported
. . exporting table               ISC_MSG_RESOURCE          0 rows exported
. . exporting table                       ISC_NODE          3 rows exported
. . exporting table              ISC_NODE_DEPLOY_R          2 rows exported
. . exporting table              ISC_ORG_ATTRIBUTE         11 rows exported
. . exporting table              ISC_ORG_SYS_DIM_R          0 rows exported
. . exporting table             ISC_ORG_UNIT_DIM_R          0 rows exported
. . exporting table                   ISC_RESOURCE        642 rows exported
. . exporting table      ISC_RESOURCE_EXT_PROPERTY        172 rows exported
. . exporting table  ISC_RESOURCE_EXT_PROPERTY_ETL          0 rows exported
. . exporting table              ISC_RESOURCE_TYPE         15 rows exported
. . exporting table ISC_RESOURC_TYPE_APPLICATION_R          0 rows exported
. . exporting table              ISC_RES_EXT_VALUE       3230 rows exported
. . exporting table                  ISC_RES_RES_R        638 rows exported
. . exporting table                  ISC_ROLEGROUP          8 rows exported
. . exporting table          ISC_ROLE_LAYER_BY_ORG         67 rows exported
. . exporting table                 ISC_ROLE_RES_R       2947 rows exported
. . exporting table                ISC_SECURE_CONF          2 rows exported
. . exporting table            ISC_SPECIALORG_UNIT          9 rows exported
. . exporting table        ISC_SPECIALORG_UNIT_BAK          0 rows exported
. . exporting table              ISC_SPORG_EXTPROP          0 rows exported
. . exporting table           ISC_SPORG_EXTPROPVAL          0 rows exported
. . exporting table       ISC_SPORG_EXTPROP_ATTR_R          0 rows exported
. . exporting table                     ISC_SPROLE         81 rows exported
. . exporting table                 ISC_SPROLE_EXT          0 rows exported
. . exporting table           ISC_SPROLE_EXT_VALUE          0 rows exported
. . exporting table                   ISC_SPROLE_R          0 rows exported
. . exporting table                  ISC_SP_DOMAIN          3 rows exported
. . exporting table    ISC_SP_DOMAIN_CODE_RELATION         15 rows exported
. . exporting table              ISC_SP_ORG_SYSTEM          3 rows exported
. . exporting table         ISC_STRATEGY_BASEORG_R          0 rows exported
. . exporting table              ISC_STRATEGY_CONF          0 rows exported
. . exporting table           ISC_STRATEGY_SESSION          0 rows exported
. . exporting table              ISC_STRATEGY_USER          0 rows exported
. . exporting table                   ISC_SYNC_LOG          0 rows exported
. . exporting table               ISC_SYNC_PROCESS          0 rows exported
. . exporting table        ISC_SYSTEM_START_CONFIG          1 rows exported
. . exporting table        ISC_TEMP_ACTOR_ROLE_TBL          0 rows exported
. . exporting table                  ISC_TEMP_USER          0 rows exported
. . exporting table              ISC_TEMP_USER_TBL          0 rows exported
. . exporting table                       ISC_UNIT         27 rows exported
. . exporting table                       ISC_USER       1947 rows exported
. . exporting table             ISC_USER_CFCA_CONN          0 rows exported
. . exporting table                  ISC_USER_DUTY          0 rows exported
. . exporting table                   ISC_USER_EXT          0 rows exported
. . exporting table          ISC_USER_EXT_PROPERTY          0 rows exported
. . exporting table          ISC_USER_EXT_PROP_ERP          0 rows exported
. . exporting table    ISC_USER_EXT_PROP_VALUE_ERP          0 rows exported
. . exporting table     ISC_USER_PASSWORDUSEFULDAY         54 rows exported
. . exporting table  ISC_USER_PASSWORD_REPETITIONS         20 rows exported
. . exporting table                 ISC_USER_SPORG       1557 rows exported
. . exporting table            ISC_WO_ACCOUNTAPPLY          0 rows exported
. . exporting table          ISC_WO_ACCOUNT_CHANGE          0 rows exported
. . exporting table          ISC_WO_APPCONF_CHANGE          0 rows exported
. . exporting table       ISC_WO_APPROVAL_COMMENTS          0 rows exported
. . exporting table            ISC_WO_APP_REGISTER          0 rows exported
. . exporting table                   ISC_WO_ORDER          0 rows exported
. . exporting table                ISC_WO_ROLELIST          0 rows exported
. . exporting table                   ISC_WO_ROLES          0 rows exported
. . exporting table                    OPERATE_OBJ         81 rows exported
. . exporting table                   OPERATE_TYPE        419 rows exported
. . exporting table      RESOURCE_DEFAULT_PROPERTY         43 rows exported
. . exporting table           SAS_REPORT_FILES_LOG          0 rows exported
. . exporting table     SAS_STANDARD_DB_LOG_201301          0 rows exported
. . exporting table          SAS_STANDARD_LOG_TYPE          5 rows exported
. . exporting table          SAS_STATISTICAL_RULES          0 rows exported
. . exporting table SAS_STATISTICS_DAY_LOGIN_COUNT         44 rows exported
. . exporting table SAS_STATISTICS_DAY_LOGIN_USERS         53 rows exported
. . exporting table  SAS_STATISTICS_SP_VISIT_COUNT          1 rows exported
. . exporting table                    USER_VERIFY          6 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

请问为什么会这样子?

1个回答

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问