ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 以sys用户执行exp导出

以sys用户执行exp导出

原创 Linux操作系统 作者:lsq_008 时间:2010-07-30 16:32:12 0 删除 编辑

方法1:

[oracle@primary ebank]$ exp "'/ as sysdba'" tables=emp file=emp.dmp log=emp.log

Export: Release 10.2.0.4.0 - Production on Fri Jul 30 09:35:10 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                            EMP      20000 rows exported
Export terminated successfully without warnings.

方法2:

[oracle@primary ebank]$ exp \'/ as sysdba\' tables=emp file=emp.dmp log=emp.log

Export: Release 10.2.0.4.0 - Production on Fri Jul 30 09:36:32 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                            EMP      20000 rows exported
Export terminated successfully without warnings.

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

上一篇: push_subq
下一篇: 模拟数据块损坏
请登录后发表评论 登录
全部评论
十余年大型金融及电信系统数据库管理经验,曾服务于中国建设银行、中国移动。对oracle,mysql数据库有深入了解。 擅长python开发,独立开发了开源数据库自动化监控运维平台Power Monitor。

注册时间:2008-02-29

  • 博文量
    335
  • 访问量
    1369148