通過sqlldr匯入到sys使用者

perfychi發表於2012-11-08
SQL
[oracle@shanxi apache]$ sqlldr 'sys/ether as sysdba' control='apachelog.ctl'  data=/tmp/scanlog.txt  
LRM-00112: multiple values not allowed for parameter 'control'
SQL*Loader: Release 10.2.0.1.0 - Production on Thu Nov 8 13:34:14 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL*Loader-100: Syntax error on command-line
 
 
解決方法一：
[oracle@shanxi apache]$ sqlldr "'sys/ether as sysdba'" control=apachelog.ctl  data=/tmp/scanlog.txt  

解決方法二:
13:29:58 SQL> show parameter O7
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY          boolean     FALSE
13:30:30 SQL> alter system set O7_DICTIONARY_ACCESSIBILITY=true scope=spfile;
System altered.
13:31:17 SQL> startup force
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size                  1220432 bytes
Variable Size             486539440 bytes
Database Buffers         1644167168 bytes
Redo Buffers               15556608 bytes
Database mounted.
Database opened.
13:31:32 SQL> show parameter O7
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY          boolean     TRUE
 
[oracle@shanxi apache]$ sqlldr sys/ether control=apachelog.ctl  data=/tmp/scanlog.txt

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/27042095/viewspace-748686/，如需轉載，請註明出處，否則將追究法律責任。

相關文章