Shulou(Shulou.com)06/01 Report--

How to import to sys users through sqlldr, I believe that many inexperienced people are at a loss about this. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

[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

Solution 1:

[oracle@shanxi apache] $sqlldr "'sys/ether as sysdba'" control=apachelog.ctl data=/tmp/scanlog.txt

Solution 2:

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

After reading the above, have you mastered how to import to sys users through sqlldr? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.