Export and Import of oracle Objects for multiple users

In this example, three Users: YAFEISHI, TEST, TEST11 export: C: \ Users \ Administrator> exp system/dang file = c: \ multi_owner.dmp log = c: \ multi_owne rlog grants = n rows = y direct = y owner = (YAFEISHI, TEST, TEST11) Export: Release 10.2.0.3.0-Production on 13:10:15 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-Production With the Partitioning, OLAP and Data Mining options
The ZHS16GBK Character Set and AL16UTF16 NCHAR character set have been exported. Note: The authorization of the table, view, sequence, and role will not be exported. The specified user will be exported soon... www.2cto.com. exporting objects and operations in the pre-schema process. exporting the external function library name of user YAFEISHI. exporting the external function library name of user TEST. exporting the external function library name of user TEST11 ........ exporting the object type definition of user YAFEISHI. exporting the object type definition of user TEST. exporting the object type definition of user TEST11. The object of YAFEISHI to be exported .... exporting database link. exporting sequence number. exporting the cluster definition. the table to be exported to YAFEISHI is saved in the direct path ..... exporting 0 rows from table TEST. exporting synonym. exporting view. exporting the stored procedure. importing The output operator is about to export the TEST object .... exporting database link. exporting sequence number. exporting the cluster definition. the table to be exported to TEST will be exported through the direct path ..... exporting table TESTBIGTABLE exported 10000000 rows .. exporting table TESTBIGTABLE2 exported 10000000 rows .. exporting table TESTMOHU 2 rows .. exporting table TESTPART exported 200 rows ....... exporting operator to export TEST11 object .... exporting database link. exporting sequence number. exporting the cluster definition. the TEST11 table will be exported through the direct path .......... exporting statistics is being exported successfully. No warning is displayed. Import: C: \ Users \ Administrator> imp system/dang file = c: \ multi_owner.dmp log = c: \ multi_owne rlog grants = n rows = y ignore = y fromuser = (YAFEISHI, TEST, TEST11) touser = (YAFEISHI, TEST, TEST11) Import: Release 10.2.0.3.0-Production on 13:14:16 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-Production With the Partitioning, OLAP and Data M The EXPORT File Created by using the direct path "EXPORT: V10.02.01" in ining options has been imported into the ZHS16GBK Character Set and AL16UTF16 NCHAR character set. importing the YAFEISHI object to YAFEISHI www.2cto.com. importing the TEST object to TEST. importing the TEST11 object to TEST11. importing the YAFEISHI object to YAFEISHI .. importing the table "TEST" to 0 rows. importing the TEST object to TEST .. importing table "TESTBIGTABLE" into 10000000 rows .. importing table "TESTBIGTABLE2" into 10000000 rows .. importing table "TESTMOHU" to 2 rows .. importing table "TESTPART" to import 200 rows. Importing the YAFEISHI object to YAFEISHI. importing the TEST object to TEST is successful. No warning is displayed. Author: yafashi