exp sys用户在非system_tablespace tables

[oracle@linux ~]$ exp \'sys/oracle@orcl as sysdba\' file=/u01/tt2.dmp  tables=sys.tt1  grants=y

Export: Release 10.2.0.1.0 - Production on Thu Jul 29 22:01:56 2010

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

About to export specified tables via Conventional Path ...
. . exporting table                            TT1      10000 rows exported
Export terminated successfully without warnings.
[oracle@linux ~]$ exp \'wj/oracle@orcl \' file=/u01/tt2.dmp  tables=sys.tt1  grants=y

Export: Release 10.2.0.1.0 - Production on Thu Jul 29 22:04:46 2010

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

About to export specified tables via Conventional Path ...
Current user changed to SYS
. . exporting table                            TT1      10000 rows exported
Export terminated successfully without warnings.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23184238/viewspace-669817/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23184238/viewspace-669817/