exp的问题

紫恒

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

aks5201314

你的导出语句贴出来看看，看导出日志没有发现错误。

紫恒

exp username/passwd log=dmp.log file=dip.dmp就这个
理论上应该是会导出的，而且我在exp交互中选择 export table data 是y也不可以

pengzhi

该用户下是否没有表呢?select table_name from user_Tables看看有没有属于该用户的表.

紫恒

必须有表
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.

紫恒

在群中，有群友说加上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.

pengzhi

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

chen28

10G的 试下expdp看看

紫恒

会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的权限了

aks5201314

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

pengzhi

exp_full_database权限就可以了