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-00487: COUNT clause required for collection string



SQL*Loader-00487: COUNT clause required for collection string..

Answer / guest

Cause: A VARRAY or NESTED TABLE was defined in the SQL
Loader control file and all of the fields in the VARRAY or
NESTED TABLE are generated by SQL Loader and do not come
from a data file. SQL Loader requires a COUNT clause be
specified so that it knows how many elements to add to the
VARRAY or NESTED TABLE for each row.

Action: Add a COUNT clause to the VARRAY or NESTED TABLE
definition.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06588: number of patterns (number) to DB_FILE_NAME_CONVERT should be even

1 Answers  


PCC-01007: WORKING-STORAGE SECTION not found

1 Answers  


LSX-00331: missing comma

1 Answers  


ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 Answers  


ORA-02288: invalid OPEN mode

1 Answers  


PCC-00147: DBMS=V6 no longer supported; using DBMS=NATIVE

1 Answers  


PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type

1 Answers  


DRG-11425: gist level string is invalid

1 Answers  


SQL*Loader-00429: insufficient number of elements found for varray

1 Answers  


ORA-16135: Invalid LOG_ARCHIVE_CONFIG modification while in protected mode

1 Answers  


IMG-00812: merged area queue initialization failed

1 Answers  


QSM-02163: cannot use object id columns from materialized view log

1 Answers  


Categories