Advertisement

Schema Object

Last updated: February 15, 2017

What Does Schema Object Mean?

A schema object in an Oracle database is a structure that describes how a database is stored. It includes information on tables, clusters, indexes, views, database links, functions and other important parts of a database. A schema object is associated with each database user and is stored in the tablespace of a database.

Advertisement

Techopedia Explains Schema Object

In Oracle databases, a schema object defines the structure of a database. It is associated with an individual user. The schema object is a logical structure, but does not have a one-to-one correspondence with files on the physical disk. A database may span multiple files on multiple drives. The schema is stored with the tablespace of each database. A schema object can be created and manipulated with SQL.

Advertisement

Share this Term

  • Facebook
  • LinkedIn
  • Twitter

Related Reading

Tags

Software DevelopmentDatabase / DBMSEnterprise IT

Trending Articles

Go back to top