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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Exploring Oracle Jg. 5; H. 5; S. 6
1. Verfasser: Christ, Bryan
Format: Trade Publication Article
Sprache:Englisch
Veröffentlicht: Louisville Element K Journals 01.05.2000
Schlagworte:
Computer programming
Data warehouses
Guidelines
Systems development
Trouble shooting
United States
US
ISSN:1098-4755, 1539-0292
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Abstract 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.
AbstractList 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.
Author Christ, Bryan
Author_xml – sequence: 1
  givenname: Bryan
  surname: Christ
  fullname: Christ, Bryan
BookMark eNrjYmDJy89LZWLgNDQ1ttQ1MLI0YgGyDSwtdE3MTU05GLiKi7MMDIyMDQ3NORmkQosz89IVSjJSFUJDfOLdPH1cFQoSk7MT01N5GFjTEnOKU3mhNDeDoptriLOHbkFRfmFpanFJfFFqQX5RSXG8kYGFiYmhpZmlMTFqAINOK7w
ContentType Trade Publication Article
Copyright Copyright ZD Journals May 2000
Copyright_xml – notice: Copyright ZD Journals May 2000
DBID 3V.
7XB
8AL
8FE
8FG
8FK
ABUWG
AFKRA
ARAPS
AZQEC
BENPR
BGLVJ
CCPQU
DWQXO
GNUQQ
HCIFZ
JQ2
K7-
M0N
P5Z
P62
PHGZM
PHGZT
PKEHL
PQEST
PQGLB
PQQKQ
PQUKI
PRINS
Q9U
DatabaseName ProQuest Central (Corporate)
ProQuest Central (purchase pre-March 2016)
Computing Database (Alumni Edition)
ProQuest SciTech Collection
ProQuest Technology Collection
ProQuest Central (Alumni) (purchase pre-March 2016)
ProQuest Central (Alumni)
ProQuest Central UK/Ireland
Advanced Technologies & Computer Science Collection
ProQuest Central Essentials
ProQuest Central
Technology Collection
ProQuest One Community College
ProQuest Central
ProQuest Central Student
SciTech Premium Collection
ProQuest Computer Science Collection
Computer Science Database
Computing Database
Advanced Technologies & Aerospace Database
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Central Premium
ProQuest One Academic
ProQuest One Academic Middle East (New)
ProQuest One Academic Eastern Edition (DO NOT USE)
ProQuest One Applied & Life Sciences
ProQuest One Academic (retired)
ProQuest One Academic UKI Edition
ProQuest Central China
ProQuest Central Basic
DatabaseTitle Computer Science Database
ProQuest Central Student
Technology Collection
ProQuest One Academic Middle East (New)
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Central Essentials
ProQuest Computer Science Collection
ProQuest Central (Alumni Edition)
SciTech Premium Collection
ProQuest One Community College
ProQuest Central China
ProQuest Central
ProQuest One Applied & Life Sciences
ProQuest Central Korea
ProQuest Central (New)
Advanced Technologies & Aerospace Collection
ProQuest Computing
ProQuest Central Basic
ProQuest Computing (Alumni Edition)
ProQuest One Academic Eastern Edition
ProQuest Technology Collection
ProQuest SciTech Collection
Advanced Technologies & Aerospace Database
ProQuest One Academic UKI Edition
ProQuest One Academic
ProQuest Central (Alumni)
ProQuest One Academic (New)
DatabaseTitleList Computer Science Database
Database_xml – sequence: 1
  dbid: BENPR
  name: ProQuest Central
  url: https://www.proquest.com/central
  sourceTypes: Aggregation Database
DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISSN 1539-0292
ExternalDocumentID 52345536
Genre Instructional Material/Guideline
GeographicLocations United States
US
GeographicLocations_xml – name: US
– name: United States
GroupedDBID 29G
3V.
5GY
7XB
8AL
8FE
8FG
8FK
8FW
8R4
8R5
ABUWG
AFFHD
AFKRA
AGGLG
ALMA_UNASSIGNED_HOLDINGS
ARAPS
AZQEC
BENPR
BGLVJ
BPHCQ
CCPQU
DWQXO
GNUQQ
HCIFZ
JQ2
K6V
K7-
M0N
P62
PHGZM
PHGZT
PKEHL
PQEST
PQGLB
PQQKQ
PQUKI
PRINS
PROAC
Q2X
Q9U
ID FETCH-proquest_reports_2084419693
IEDL.DBID K7-
ISSN 1098-4755
IngestDate Wed Dec 24 02:36:25 EST 2025
IsPeerReviewed false
IsScholarly false
Issue 5
Language English
LinkModel DirectLink
MergedId FETCHMERGED-proquest_reports_2084419693
PQID 208441969
PQPubID 34280
ParticipantIDs proquest_reports_208441969
PublicationCentury 2000
PublicationDate 20000501
PublicationDateYYYYMMDD 2000-05-01
PublicationDate_xml – month: 05
  year: 2000
  text: 20000501
  day: 01
PublicationDecade 2000
PublicationPlace Louisville
PublicationPlace_xml – name: Louisville
PublicationTitle Exploring Oracle
PublicationYear 2000
Publisher Element K Journals
Publisher_xml – name: Element K Journals
SSID ssj0023117
Score 2.4939585
Snippet 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...
SourceID proquest
SourceType Aggregation Database
StartPage 6
SubjectTerms Computer programming
Data warehouses
Guidelines
Systems development
Trouble shooting
Title Using the UTL_FILE package
URI https://www.proquest.com/docview/208441969
Volume 5
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwpV1LSwMxEB609eCpPrGrlgheA41JNpuTqOyisCyLVCheFvMQRNhqW_39Jmm2CKIXL7kEkiEh8_q-yQCcM2W4oVpgqTzMqLMn9-YIwdqwCy3GZpyqUChciqrKplNZR27OItIqO50YFLWZaZ8jd0F65iy3TOXl2zv2TaM8uBo7aGxCn_jqIY_JCryOtygJDXeJ_zKTCc5_qNtgQ4rBP3ffgaGzK8aib4k2dLW6913YsO0eDLoWDSi-2H1IAiUAOS8PPUzKprgrc-Si5FenRQ7grMgnN7e4E6WJ-EGzFoMeQq-dtfYIUGo0VYwq5wtwpjIhn6kiJlOMCGNlqoaQ_L5O8tfkMWyvCs89ve8Eesv5hz2FLf25fFnMR9C_zqv6fhTO3I01f_wCJi6QwQ
linkProvider ProQuest
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwxV1bS8MwFD7MTtCnecXVWwR9s7A26SUPIl5aVlbLkAp7K-YiiNDpNpX9e5NehiAqPvmccBKSk-_ccwCOCROuwNy3KNNhRh7cqzdn2xYXxOF-T_Q8VhYKJ36aBqMRHbZg3tTC6LTKBhNLoBZjrn3kykgPlOSmHj1_frF00ygdXG06aFRcMZDzd2WxTc_ia3W9J44ThdlV32rI5bUXPl-QwmrOErR1cSUxoH0ZpsPbhbWG7bJdr60_3CS-634B61ICRZ1_3PsadJVEExJ9cvGhi4rj1qEliw3oNM0hUI0Vm2CWyQhI6ZfoLkvyKE5CpOzzJ4VfW3D067rbYBTjQu4A8gTHjGCmtBCXsMCnD5jZImDE9oWkHuuC-T0d86fBQ1jpZzdJnsTpYBdWq_J3nWS4B8Zs8ir3YZm_zR6nk4P61hCc_uXgPgCgA8dQ
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Using+the+UTL_FILE+package&rft.jtitle=Exploring+Oracle&rft.au=Christ%2C+Bryan&rft.date=2000-05-01&rft.pub=Element+K+Journals&rft.issn=1098-4755&rft.eissn=1539-0292&rft.volume=5&rft.issue=5&rft.spage=6&rft.externalDocID=52345536
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1098-4755&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1098-4755&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1098-4755&client=summon