Export all database objects under a user (do not export data)

Source: Internet
Author: User

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.  

 


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.