您好,欢迎光临! 请 |

Can objects of the same Schema reside

Can objects of the same Schema reside in different tablespaces?

The answer is YES. For example ,if  one user have a table and a index schema,he/she can put the table and index into respective  tablespaces. 下载本文的PDF版本, 方便离线阅读转载

What is SYSTEM tablespace and whe

What is SYSTEM tablespace and when is it created?

Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. 下载本文的PDF版本, 方便离线阅读转载

What are the components of logical data

What are the components of logical database structure of Oracle database?

There are tablespaces and database's schema objects. Generally,the logical database structure can be divided into TABLESPACES,SEGMENTS,EXTENTS,BLOCKS. 下载本文的PDF版本, 方便离线阅读转载

What is the schema ?

What is the schema ?

A schema is a collection of database objects owned by a specific database user,or schema objects.Schema has the same name as that user,every user has a single schema,so the two terms(Schema,User) are synonymous. Schema objects include the segments(tables,indexes..etc) as we can see in the tablespaces as well as t......