Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL Loader question

SQL Loader question

From: vipul desai <desaivipul_at_usa.net>
Date: 14 Sep 00 00:09:46 MDT
Message-Id: <10618.116938@fatcity.com>


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



Get free email and a permanent address at http://www.netaddress.com/?N=3D= 1

 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


Received on Thu Sep 14 2000 - 01:09:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US