Export all database objects under a user (do not export data)
[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.