导出用户下所有数据库对象(不导出数据)
来源:互联网 发布:企业网站源码自适应 编辑:程序博客网 时间:2024/06/04 17:51
[lubinsu@200-168-1-2 dpump]$ exp lubinsu/lubinsu owner=lubinsu rows=n indexes=y compress=y buffer=65536 feedback=100000 file=/home/lubinsu/dpump/lubinsu.dmp log=/home/lubinsu/dpump/lubinsu.log
Export: Release 10.2.0.1.0 - Production on Mon Sep 9 21:50:08 2013Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setNote: table data (rows) will not be exportedAbout to export specified users .... exporting pre-schema procedural objects and actions. exporting foreign function library names for user LUBINSU . exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user LUBINSU About to export LUBINSU's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export LUBINSU's tables via Conventional Path .... . exporting table AREA_TM. . exporting table BSS_PO_SPEC_D. . exporting table CRM_BASE_BUSI_ORDER. . exporting table CRM_BASE_BUSI_ORDER_MID. . exporting table DEPT. . exporting table EMP. . exporting table GRID_MSG. . exporting table INFILE_CRM_BASE_BUSI_ORDER. . exporting table JOB_PARMS. . exporting table KETTLE_TEST. . exporting table LATN_AREA_INFO. . exporting table MANAGER_TM. . exporting table MANAGER_TM_510. . exporting table MANAGER_TM_T. . exporting table PIPE_MSG. . exporting table PO_SPEC_CATE_TREE_RELA. . exporting table PROCEDURE_RESULT. . exporting table REGEXP_TEST. . exporting table SERV_MSG. . exporting table SERV_MSG_T. . exporting table STAT_PROCEDURE. . exporting table TEACHER_VPN_STAT_DAILY. . exporting table TEACHER_VPN_STAT_DAILY_T. . exporting table TT4. . exporting table T_SCN. . exporting table T_TEST. . exporting table T_TEST_2. . exporting table USER_OBJECTS_TMP. 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 statisticsExport terminated successfully without warnings.