ssh连接Linux导出oracle数据

本文展示了一个使用Oracle Export工具导出指定表数据的过程。在Linux环境下,通过SQL*Plus连接到Oracle数据库,并利用expdp命令导出了四个表的数据:gjj_dwzz、gg_dw、gjj_grmx和gjj_grzz。总数据量约为7.35GB,导出文件为gjtq.dmp。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

[root@dbsrv1 ~]# su - oracle
dbsrv1-> sqlplus gjtq/gjtq

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 21 19:46:41 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
dbsrv1-> expdp gjtq/gjtq directory=dmp tables="gjj_dwzz,gg_dw,gjj_grmx,gjj_grzz" dumpfile=gjtq.dmp  logfile=explog.log version=11.2.0.1.0

Export: Release 11.2.0.4.0 - Production on Thu Apr 21 19:51:43 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "GJTQ"."SYS_EXPORT_TABLE_01":  gjtq/******** directory=dmp tables=gjj_dwzz,gg_dw,gjj_grmx,gjj_grzz dumpfile=gjtq.dmp logfile=explog.log version=11.2.0.1.0
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 8.487 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/POST_TABLE_ACTION
. . exported "GJTQ"."GJJ_GRMX"                           7.136 GB 25412209 rows
. . exported "GJTQ"."GJJ_GRZZ"                           159.5 MB  419095 rows
. . exported "GJTQ"."GJJ_DWZZ"                           1.192 MB    2818 rows
. . exported "GJTQ"."GG_DW"                              719.1 KB    2818 rows
Master table "GJTQ"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for GJTQ.SYS_EXPORT_TABLE_01 is:
  /home/oracle/backupdata/gjtq.dmp
Job "GJTQ"."SYS_EXPORT_TABLE_01" successfully completed at Thu Apr 21 19:52:30 2016 elapsed 0 00:00:46

转载于:https://www.cnblogs.com/lanjianqing/p/5419990.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值