Tham khảo sách 'less07_schema_tb3', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Managing Schema Objects Oracle Database 10g: Administration Workshop I 7- Objectives After completing this lesson, you should be able to do the following: Define schema objects and data types Create and modify tables Define constraints View the columns and contents of a table Create indexes Create views Create sequences Explain the use of temporary tables Use the data dictionary Oracle Database 10g: Administration Workshop I 7- What Is a Schema? HR schema HR user owns > Schema Constraints Indexes Views Sequences Temp Tables Data Dict What Is a Schema? A schema is a collection of database objects that are owned by a particular user. Typically, for a production database, this user does not represent a person, but an application. A schema has the same name as the user that owns the schema. Schema objects are the logical structures that directly refer to database’s data. Schema objects include structures such as tables, views, and indexes. You can create and manipulate schema . | Managing Schema Objects Oracle Database 10g: Administration Workshop I 7- Objectives After completing this lesson, you should be able to do the following: Define schema objects and data types Create and modify tables Define constraints View the columns and contents of a table Create indexes Create views Create sequences Explain the use of temporary tables Use the data dictionary Oracle Database 10g: Administration Workshop I 7- What Is a Schema? HR schema HR user owns > Schema Constraints Indexes Views Sequences Temp Tables Data Dict What Is a Schema? A schema is a collection of database objects that are owned by a particular user. Typically, for a production database, this user does not represent a person, but an application. A schema has the same name as the user that owns the schema. Schema objects are the logical structures that directly refer to database’s data. Schema objects include structures such as tables, views, and indexes. You can create and manipulate schema objects by using SQL or Enterprise Manager. When you use Enterprise Manager, the underlying SQL is generated for you. Note: A schema does not necessarily have to be directly related to a single tablespace. You can define configurations such that objects in a single schema can be in different tablespaces, and a tablespace can hold objects from different schemas. Oracle Database 10g: Administration Workshop I 7- Schemas Full Notes Page What Is a Schema? (continued) When you create the database, several schemas are created for you. Two of particular importance are the following: SYS schema: This contains the data dictionary, as described in the lesson titled “Administering User Security.” SYSTEM schema: It contains additional tables and views that store administrative information. This is described in the lesson titled “Administering User Security.” During a complete installation of an Oracle database, sample schemas are installed automatically. Sample schemas serve the purpose of .
