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.
Share this Term
Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
Latest Articles
By: Brad Rudisail | Contributor
By: Claudio Buttice | Data Researcher, Contributor
By: Amy Parker | Technology Consultant
By: Claudio Buttice | Data Researcher, Contributor
