Contents
What are the schema objects in Oracle?
A schema is a collection of schema objects. Examples of schema objects include tables, views, sequences, synonyms, indexes, clusters, database links, procedures, and packages. This chapter explains tables, views, sequences, synonyms, indexes, and clusters. Schema objects are logical data storage structures.
What are the different schema objects that can be created using PL SQL?
Schema objects can be created and manipulated with SQL and include the following types of objects:
- Clusters.
- Database links.
- Database triggers.
- Dimensions.
- External procedure libraries.
- Indexes and index types.
- Java classes, Java resources, and Java sources.
- Materialized views and materialized view logs.
What are the schema objects?
Schema objects are logical structures created by users. Objects such as tables or indexes hold data, or can consist of a definition only, such as a view or synonym. Objects in the same schema can use storage in different tablespaces, and a tablespace can contain data from different schemas.
What do the schema objects comprise of in SQL?
A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects:
How to manage schema objects in Oracle Enterprise Manager?
The underlying SQL is generated for you by Oracle Enterprise Manager. This section contains the following topics: To explore and manage the schema objects in your database, open the Database Administration property page (see Figure 5-2, “Database Administration Page”) and click one of the links in the Database Objects section.
How to search for objects in a schema?
To view tables: In the Administration page, click Tables. The Tables property page appears. In the Schema box, enter the name of a schema. For example, enter SYS. Leave Object Name blank to search for all tables in a schema. Alternatively, enter an object name or click the flashlight icon to search for one. Click Go.
How long does a schema object name have to be?
In addition to being unique within a schema, a schema object name cannot be longer than 30 bytes and must begin with a letter. If you attempt to create an object with a name that violates any of these rules, then the database raises an error. You can create and manipulate schema objects with SQL or with SQL Developer.