Oracle7 Server Application Developer's Guide

CHAPTER 4. Managing Schema Objects

This chapter discusses the procedures necessary to create and manage the different types of objects contained in a user's schema. The topics included are as follows:

managing tables

managing views

modifying a join view

managing sequences

managing synonyms

managing indexes

managing clusters

listing information about schema objects

Note: Procedures, functions, and packages are discussed in Chapter 7; dependency information is in Chapter 11. If you are using symmetric replication, you should refer to Oracle7 Server Distributed Systems, Volume II for additional information on managing schema objects, such as snapshots. If you are using Trusted Oracle, there are additional privileges required and issues to consider when managing schema objects; refer to the Trusted Oracle7 Server Administrator's Guide.