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

ORA-00209: control file blocksize mismatch, check alert log for more info

1 Answers  


ORA-19590: conversation already active

1 Answers  


TNS-01077: Opened parameter file: string

1 Answers  


ORA-16589: Data Guard Connection process detected a network transfer error

1 Answers  


ORA-31619: invalid dump file "string"

1 Answers  


ORA-07229: slcpuc: error in getting number of CPUs.

1 Answers  


ORA-16598: Data Guard broker detected a mismatch in configuration.

1 Answers  


NNO-00308: server will restart in number seconds

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  


ORA-30731: scope constraint not allowed on nested table column when the nested table is being created

1 Answers  


LSX-00333: literal "~S" is not valid with respect to the pattern

1 Answers  


NNL-00260: Server-generated requests now do not require authoritative answers

1 Answers  


Categories