导出用户下所有数据库对象(不导出数据)

[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 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported

About 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 statistics
Export terminated successfully without warnings.



版权声明:本文为snoopy93原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。