Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
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.
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.