[求助]exp备份,不报错,却找不到文件,在线等,谢谢!

zhangyan@tq.cn

执行语句: exp scott/tiger owner=scott rows=y indexes=y compress=n buffer=65536 feedback=100000 file=/home/bak/oraclebak/data1.dmp  log=/home/bak/oraclebak/name1.log
结果如下:
Export: Release 10.2.0.1.0 - Production on Fri Dec 8 17:25:48 2006

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

buffer=65536 feedback=100000 file=/home/bak/oraclebak/data1.dmp


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionslog=/home/bak/oraclebak/name1.log
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                           DEPT          4 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                            EMP         14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                       SALGRADE          5 rows exported
EXP-00091: Exporting questionable statistics.
. 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 with warnings.
[oracle@www ~]$
[oracle@www ~]$ buffer=65536 feedback=100000 file=/home/bak/oraclebak/data1.dmp
[oracle@www ~]$
[oracle@www ~]$ log=/home/bak/oraclebak/name1.log

但是我在/home/bak/oraclebak下却找不到data1.dmp 文件,

请高人指点,有什么问题?

[ 本帖最后由 zhangyan@tq.cn 于 2006-12-8 17:58 编辑 ]

blue_stone

把执行的全部过程拿上来看看, 可能是你没有输出一条完成的命令.
如果是没有输入一条完整的命令, 则导出的文件在当前目录下.

或者试一下运行

1. 
   
2. exp scott/tiger owner=scott rows=y indexes=y \
   
3. compress=n buffer=65536 feedback=100000 \
   
4. file=/home/bak/oraclebak/data1.dmp  log=/home/bak/oraclebak/name1.log
   

复制代码

在unix类操作系统中, 命令的一行以'\'结尾, 表示这个命令还没有结束, 下一行还是这个命令的内容

managergh

迷糊 大姐你都问到这了 呵呵
咋样啊 解决没那