Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › exp的问题

紫恒

40 积分	0 好友	0 主题

发消息

exp的问题

1^#

发表于 2012-7-10 15:20:14 | 查看: 5251| 回复: 10

在rhel 5.3 oracle database 10.2.0.1上使用exp导出表，但是表无法导出，是否是权限的问题
日志如下

dmp.rar

591 Bytes, 下载次数: 953

分享0

收藏0 回复只看该作者道具举报

pengzhi

11^#

发表于 2012-7-11 22:31:19

exp_full_database权限就可以了

回复只看该作者道具举报

aks5201314

10^#

发表于 2012-7-11 20:05:51

楼主以SYSTEM用户做导出操作，使用参数owner=username导出指定用户的数据

回复只看该作者道具举报

紫恒

9^#

发表于 2012-7-11 10:26:12

会7楼，指定tables参数之后出现全线错误。。汗死
Export: Release 10.2.0.1.0 - Production on Wed Jul 11 10:23:35 2012

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit 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 C_PSG_INFO
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
估计要DBA的权限了

回复只看该作者道具举报

chen28

8^#

发表于 2012-7-11 09:59:21

10G的试下expdp看看

回复只看该作者道具举报

pengzhi

7^#

发表于 2012-7-11 09:59:07

如果加上TABLES的参数呢?试一下只EXP一张表看看有没有问题。再授权一个exp_full_database看看

回复只看该作者道具举报

紫恒

6^#

发表于 2012-7-11 09:14:35

在群中，有群友说加上direct=y, 还是不行
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user
About to export 's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. 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.

回复只看该作者道具举报

紫恒

5^#

发表于 2012-7-11 08:51:00

必须有表
SQL> select table_name from dba_tables where owner='DIP';

TABLE_NAME
------------------------------
TMP_PNR
CZ_PNR_PSG
CZ_PNR_INFO
PNR_PERSONDETAIL
PNR_TRAVELINFO
C_PNR_SEG
PNR_XML
C_PNR_XML
TOAD_PLAN_TABLE
C_PNR_SEG2
C_PSG_INFO_TMP

TABLE_NAME
------------------------------
C_PSG_INFO

12 rows selected.

回复只看该作者道具举报