Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


SQL*Loader-00622: Column not found before end of logical
record (use TRAILING NULLCOLS)

Answers were Sorted based on User's Feedback



SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)..

Answer / raju reddy

place the clause TRAILING NULLCOLS in the controlfile, in
the middle like before starting of the column fields.
ex:load data
infile *
insert/append
into
table schemaname."<loc>"
fields terminated by ","
TRAILING NULLCOLS
(<col names>)
begindata
<your data>

Is This Answer Correct ?    11 Yes 3 No

SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)..

Answer / guest

Cause: The logical record ended before all specified fields
were found.

Action: If the missing fields should be loaded as null, use
the TRAILING NULLCOLS clause. Otherwise, correct the data.

Please add more information about this Error

Is This Answer Correct ?    11 Yes 5 No

Post New Answer

More Oracle Errors Interview Questions

PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

1 Answers  


PCC-02041: CMD-LINE: Option does not exist:

1 Answers  


ORA-38480: creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.

1 Answers  


ORA-21526: initialization failed

1 Answers  


SQL*Loader-00601: For INSERT option, table must be empty. Error on table string

1 Answers  


ORA-25264: cant get signature for this queue

1 Answers  


PCB-00576: PLS-number: string

1 Answers  


QSM-02146: see the reason why REFRESH_FAST_AFTER_INSERT is disabled

1 Answers  


KUP-03001: fatal error during library cache pre-loading

1 Answers  


RMAN-06436: enter DROP CATALOG command again to confirm catalog removal

1 Answers  


ORA-02337: not an object type column

1 Answers  


ORA-12509: TNS:listener failed to redirect client to service handler

1 Answers  


Categories