今天在做exp的時候,該用戶的密碼為Rdy)Jl!S。在做exp的時候總是報錯:
$ exp testuser/Rdy/)Jl!S@hbreport owner=testuser
LRM-00116: syntax error at ')' following 'testuser/Rdy'
EXP-00019: failed to PRocess parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
用了引號也不行:
$ exp "testuser/Rdy)Jl!S" owner=testuser
LRM-00116: syntax error at ')' following 'testuser/Rdy'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
雖然遇到這樣的情況,我們可以用不含)密碼的dba權限用戶來導出,或者用parfile,但是如果直接用命令行,我們應該怎么做呢?
win下,用/:
D:/>exp testuser/Rdy/)Jl!S@oralocal owner=testuser
Export: Release 9.2.0.1.0 - Production on 星期三 7月 11 16:34:56 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
連接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
已導出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即將導出指定的用戶...
. 正在導出 pre-schema 過程對象和操作
. 正在導出用戶 TESTUSER 的外部函數庫名稱
. 導出 PUBLIC 類型同義詞
. 導出私有類型同義詞
. 正在導出用戶 TESTUSER 的對象類型定義
即將導出 TESTUSER 的對象 ...
. 正在導出數據庫鏈接
. 正在導出序號
. 正在導出群集定義
. 即將導出 TESTUSER 的表通過常規路徑 ...
. . 正在導出表 KK 915 行被導出
(以下省略)
unix下,用”"和/:
$ exp "testuser/Rdy/)Jl!S" owner=testuser
Export: Release 9.2.0.6.0 - Production on Wed Jul 11 17:05:08 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TESTUSER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TESTUSER
About to export TESTUSER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TESTUSER's tables via Conventional Path ...
. . exporting table KKK 8 rows exported
……
新聞熱點
疑難解答