Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SQL Loader question
Hi friends,
I wanted to upload a ASCII file into the database using sql*loader. The=
format of the file is mixed, by that i mean first 10 fields are of fixed
length and last 10 are of variable length having the delemiter as << star=
t and
>> end.
Using single control file i want to upload the data into the database.
One more thing if there is any exception or error in uploading data to =
the
database it should insert the same row into other table with one field of=
the
type logn. I mean without breaking into various fields it should append t=
he
record into other table.
Can any one help on the same. If this is not possible through SQL*Loade=
r and
u are suggesting UTL_FILE then i think it would not be good option for me=
because filesize si 20 MB and processing with the UTL_FILE whould decreas=
e the
speed.
Thanks
-Vipul
From: AlexP <apot_at_canadawired.com>
Date: Mon, 13 Sep 1999 22:58:54 -0700
Subject: Oracle on W2K install failed - please help
Dear listers!
I got the following error while installing Oracle 8.1.6 Server on W2K
(member server in domain):
Creating and starting Oracle Instance ..... OK Copying Data Base files ...... OK Initializing database .... at 90% : ORA 12638: Credential retrieval failed, Ignore/Abort?
And if Ingore, it just hangs.
What could be the problem?
Thank you,
Alex
From: Paul Drake <paled_at_home.com>
Date: Thu, 14 Sep 2000 02:29:48 -0400
Subject: Re: How many databases do you support? - remote NT
Hi Kip,
[plug]For desktop connectivity for managing remote databases on NT, I use NetOp
from danware.com.[/plug]
Its pretty fast over a 28.8 kbps connection, starts as an NT service, which is
quite handy when you have to do remote reboots. Sweet to have for recovery and
upgrades - but it still doesn't change the tapes 8^).
just a customer, no direct interest ...
Paul
Kip.Bryant_at_Vishay.com wrote:
> How about local vs. remote databases?
>
> Currently I have 12 local databases on unix (6 running that SAP thing) but it
> looks like I'm going to "inherit" 3 or 4 (maybe more) remote databases on NT
> boxes. All of them considered "production." I'm not too happy about this,
> but, oh well.
> Kip
From: Paul Drake <paled_at_home.com>
Date: Thu, 14 Sep 2000 02:58:11 -0400
Subject: Re: Oracle on W2K install failed - please help - ORA-12638 again
recycling the same thing from earlier today ...
Are you using Advanced Security option and Kerberos? If you are not using
them, comment (place a # sign in front of the parameter) or remove the
authentication request parameter:
SQLNET.AUTHENTICATION_SERVICES= (XXX) in the sqlnet.ora file, located in
the Oracle_Home/network/admin directory.
fei
AlexP wrote:
> Dear listers!
> I got the following error while installing Oracle 8.1.6 Server on W2K
> (member server in domain):
>
> Creating and starting Oracle Instance ..... OK
> Copying Data Base files ...... OK
> Initializing database .... at 90% : ORA 12638: Credential retrieval
> failed, Ignore/Abort?
>
> And if Ingore, it just hangs.
> What could be the problem?
>
> Thank you,
> Alex
>
> --
> Author: AlexP
> INET: apot_at_canadawired.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
End Of ORACLE-L Digest -- Volume 2000, Number 258
![]() |
![]() |