Database Reference
In-Depth Information
data from any database on the network. Lastly, when the need for total speed is there, nothing but C will do (if you ask
me). So I also have a Pro*C command-line unloading tool to generate flat files. All of these tools are freely available
at http://tkyte.blogspot.com/2009/10/httpasktomoraclecomtkyteflat.html , and any new tools developed for
unloading to flat files will appear there as well.
Summary
In this chapter, we explored the important types of files used by the Oracle database, from lowly parameter files
(without which you won't even be able to get started) to the all-important redo log and data files. We examined the
storage structures of Oracle from tablespaces to segments and extents, and finally down to database blocks, the
smallest unit of storage. We briefly reviewed how checkpointing works in the database, and we even started to look
ahead at what some of the physical processes or threads of Oracle do. We also covered many optional file types such
as password files, change-tracking files, Data Pump files, and more. In the next chapter we are ready to look at the
Oracle memory structures.
 
Search WWH ::




Custom Search