oracle数据库导出灰色_导出用户下所有数据库对象（不导出数据）-Oracle

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

[sql]

[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

[plain]

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.