Using the UTL_FILE package

The problem of working on a data warehouse project, loading the data via SQL*Loader, and then receiving way too many log files to make sure the data had been loaded correctly is discussed. To solve this dilemma, a procedure can be used that uses the UTL_FILE package that reads from the log files and...

Celý popis

Uložené v:
Podrobná bibliografia
Vydané v:Exploring Oracle Ročník 5; číslo 5; s. 6
Hlavný autor: Christ, Bryan
Médium: Trade Publication Article
Jazyk:English
Vydavateľské údaje: Louisville Element K Journals 01.05.2000
Predmet:
Computer programming
Data warehouses
Guidelines
Systems development
Trouble shooting
United States
US
ISSN:1098-4755, 1539-0292
On-line prístup:Získať plný text
Tagy: Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
Popis
Shrnutí:The problem of working on a data warehouse project, loading the data via SQL*Loader, and then receiving way too many log files to make sure the data had been loaded correctly is discussed. To solve this dilemma, a procedure can be used that uses the UTL_FILE package that reads from the log files and writes the data being looked for into the process_history or error_msg table.
ISSN:1098-4755
1539-0292