Click the folders below to filter the papers and podcasts by user type or product.
|
 |
Toad® Papers and Podcasts
Training Resources |
Leading Spaces and Their Prevention with Toad for Oracle
A Toad® for Oracle Case Study, by Michael Allen
(from the Cascading Chaos and Risk Due to Corrupt Data series)
All reports are suspect from a database corrupted with leading spaces. Errors caused by leading spaces can vary from insignificant to catastrophic. Consequences depend upon the volume of corruption, the significance of the columns corrupted, and how each individual report or chart uses those corrupted values. Only a detailed, time consuming - and therefore costly - manual analysis of each report or chart can determine with a reasonable degree of certainty the impact on the results.
This case study illustrates how to implment a prevention trigger using Quest’s Toad for Oracle tool to eliminate the instantiation of additional corrupt data with a leading space.
PDF Document, 356 KB
|
|