[求助]exp備份,不報(bào)錯(cuò),卻找不到文件,在線等,謝謝!

zhangyan@tq.cn

執(zhí)行語句: 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
結(jié)果如下:
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 文件,

請(qǐng)高人指點(diǎn),有什么問題?

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

blue_stone

把執(zhí)行的全部過程拿上來看看, 可能是你沒有輸出一條完成的命令.
如果是沒有輸入一條完整的命令, 則導(dǎo)出的文件在當(dāng)前目錄下.

或者試一下運(yùn)行

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
   

復(fù)制代碼

在unix類操作系統(tǒng)中, 命令的一行以'\'結(jié)尾, 表示這個(gè)命令還沒有結(jié)束, 下一行還是這個(gè)命令的內(nèi)容

managergh

迷糊 大姐你都問到這了 呵呵
咋樣啊 解決沒那