如何查看oracle的exp导出的.dmp文件的用户

本文介绍了一种方法,用于解析仅有Oracle EXP导出的.dmp文件的情况,尤其是在未知导出用户或表名的情况下,通过特定命令及文件头部信息来获取导出的用户及其对象详情。

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

由于某种原因(是由别人很久以前导出的,这个人你已经联系不到),只有exp导出的.dmp文件,不知道用户导出的用户名或表名的信息,可以使用下面的方法:

[oracle@dg01] exp thomas/thomas owner=thomas file=1.dmp
Export: Release 10.2.0.4.0 - Production on Thu Mar 26 18:29:32 2009
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
server uses ZHS16GBK character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user THOMAS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user THOMAS
About to export THOMAS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export THOMAS's tables via Conventional Path ...
. . exporting table                         TEST       10 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@dg01]
[oracle@dg01] head -10 1.dmp |strings
EXPORT:V10.02.01
DTHOMAS     --导出用户
RUSERS    --以owner的方式,如果是以表的方式则是:RTABLES
8192
                                     Thu Mar 26 18:29:32 20091.dmp
#C##
#C##
+00:00
BYTE
UNUSED
INTERPRETED
DISABLE:ALL

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值