Oracle outputs the data of one user using the data below the user and writes the data to another user using the data below.

Original article: http://specialwolf.blog.163.com/blog/static/124466832201131844717382/

In this case, Scott uses the following data records to export the data to the test user:

C: \ Documents ents and Settings \ dean_deng> exp system/manager @ orcl file = E: \ test. dmp owner = (Scott)

Export: Release 10.1.0.2.0-production on Thursday May 3 11:22:52 2012

Copyright (c) 1982,200 4, Oracle. All rights reserved.

Zookeeper to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production
With the partitioning, OLAP and Data Mining options
Zht16mswin950 Character Set and al16utf16 nchar character set have been exported

That is, the user set will be released...
. Listing program objects and actions first
. Releasing the feature program named external from user Scott.
. Generating the public-type homophone.
. Generating the class-type homophone.
. Defining the definition of user Scott object type
That is, Scott's object will be extracted...
. Generating data records.
. Sorting Out sequence...
. The parameter set definition is being extracted.
. That is, the Scott table will be output by the general channel...
... The bonus partition table is being exported and 0 columns are generated.
... The dept partition table is being written. Five columns are generated.
... Listing the table EMP contains 14 columns.
... Listing the table KC contains 9 columns.
... The order_status2 table is being exported. Column 0 is returned.
... The order_status_temp table is being exported.
... The table salgrade has 5 columns.
.. Listing the table sys_temp_fbt
... Rolling out table task rolling out 7 Columns
... The test partition table is being exported, and 1966088 columns are generated.
... Listing table test1 contains 1966088 columns.
... Listing the table Xs has 22 Columns
. The same definition is being written.
. Rolling out the two‑dimensional table.
. Pulling out the memory program.
. The outbound operator is being merged.
. Releasing the reference conformity restriction.
. Sending a producer.
. Sorting out index type
. Updating the output vertex. The function and the index can be added.
. Rolling out subsequent table actions
. Compile: generate a specific sequence table.
. Copying the data within the specified time period
. The worker column is being merged.
. Sorting out groups and sub-groups
. Rolling out degree
. Waiting for program objects and actions
Generating the statistical value.
The error message has been cleared and no warning has been reported.

C: \ Documents ents and Settings \ dean_deng> sqlplus system/manager @ orcl

SQL * Plus: Release 10.1.0.2.0-production on Thursday May 3 11:15:43 2012

Copyright (c) 1982,200 4, Oracle. All rights reserved.

Zookeeper:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production
With the partitioning, OLAP and Data Mining options

SQL> create user test identified by test;

A user has been created.

SQL> grant create session to test;

Permission granting.

SQL> grant resource to test;

Permission granting.

IMP system/manager @ orcl file = E: \ test. dmp fromuser = Scott touser = test

SQL> exit
Switch to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production
With the partition processing of the partitioning, OLAP and Data Mining options

C: \ Documents ents and Settings \ dean_deng> imp system/manager @ orcl file = E: \ test. dmp fromuser = Scott touser = test

Import: Release 10.1.0.2.0-production on Thursday May 3 11:21:05 2012

Copyright (c) 1982,200 4, Oracle. All rights reserved.

Zookeeper to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production
With the partitioning, OLAP and Data Mining options

It is created by the Unified router and created by export: v10.01.00.
Completed ingress entry in the zht16mswin950 Character Set and al16utf16 nchar Character Set
. Copying Scott's object to test.
... Loading table "bonus" into 0 Columns
... Loading table "Dept" into 5 columns
... Loading the table "EMP" into 14 Columns
... The Partition Table "KC" contains nine columns.
... Loading table "order_status2" inserting 0 Columns
... Loading table "salgrade" into 5 columns
... Loading table "task" into 7 Columns
... Loading table "test" into 1966088 Columns
... Loading table "test1" inserting 1966088 Columns
... Loading table "XS" into 22 Columns
Will be renewed with restrictions...
I have been profitable and have not been warned.

C: \ Documents ents and Settings \ dean_deng>