ITPub博客

首页 > Linux操作系统 > Linux操作系统 > exp sys用户在非system_tablespace tables

exp sys用户在非system_tablespace tables

原创 Linux操作系统 作者:-Nero- 时间:2010-07-29 22:30:00 0 删除 编辑

[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博客 ” ,链接:https://blog.itpub.net/23184238/viewspace-669817/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-01-14

  • 博文量
    16
  • 访问量
    33114