First page Back Continue Last page Graphics
Introduction
All successful DBAs must have a solid command of the data dictionary
Must know how to query
Answer to many questions are in the dictionary
Notes:
So many of the questions you will be faced with as an administrator will be answered by querying the data dictionary. For example, a simple question such as “what tables are in the USERS tablespace?” is answered with the query:
SELECT owner, table_name
FROM dba_tables
WHERE tablespace_name='USERS'
Thus, it is imperative that we have a solid command of the data dictionary.
(If you are not sure what a tablespace is, don’t worry, you will learn all about tablespaces later in this course. However, if you are not sure what a table is, before you continue with this course attend an Introduction to Oracle class or read Part II of Oracle9i A Beginner’s Guide by Michael Abbey. ISBN 0-07-219279-8.)