以sys用户执行exp导出

最新推荐文章于 2023-05-08 22:07:31 发布

转载最新推荐文章于 2023-05-08 22:07:31 发布 · 399 阅读

本文介绍了使用Oracle Export工具导出数据库中特定表(EMP)的方法。通过两种命令行方式成功导出了2万条记录，并保存到emp.dmp文件中。

方法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

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

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

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

转载于:http://blog.itpub.net/10972173/viewspace-669901/