April 25th, 2004 by Mark Rittman
"Versions 8i and 9i of Oracle have altered the facts behind several common
beliefs of DBAs. Find out why these five cherished beliefs about working with
the database may no longer be true and how the changes enhance your options."
writes Bob Watkins
in an article titled
"Rethink five outdated ideas about Oracle" for TechRepublic.com. And what
are these outdated beliefs?
- Block size is fixed
- Single extent tables are faster
- Export and import are the only way to reorganise tables
- Columns can’t be dropped
- Stored procedures always run as the owner.
If you found the article useful, Bob Watkins has also produced a follow-up,
More Things To Unlearn About Oracle". According to Bob, "In
article, I described five things about Oracle that DBAs widely believed but
which were no longer true. As I continue to teach Oracle 9i, I find more DBAs
running current versions of the software but still living within the limitations
of older versions. Here are five more things that it s time to unlearn about the
Oracle database.". And they are?
- Only the DBA can recover data
- Oracle can t store fractions of seconds
- A corrupted block requires dropping an object
- Columns can t be renamed or reorganized
- Only the owner of a table can grant permission to use it