CODEWITHSUNDEEP
oracle-database
user149621
user149621

Reputation: 529

Can Oracle schema used size can be greater than tablespace used size?

In Oracle schema used size can be greater than tablespace used size ? If yes how its possible as schema is associated with tablespace ?

Upvotes: 0

Views: 218

Answers (2)

XING
XING

Reputation: 9886

In addition to what @a_horse_with_no_name mentioned, you need to undrstand few basics of orale as well.

Oracle Tablespace -

  • This is a logical structure, meaning that a tablespace is not a physical object
  • A tablespace is made of 1 or more physical structures called datafiles. A datafile is a physical file on disk, just like any other file which sits on a hard disk but in an Oracle format. The datafile is created as part of a tablespace, and only one tablespace
  • Each tablespace can have different characteristics, such as extent size and how the extents are managed
  • They are used to group segments into logical groups. For example, you may have accounting data in one tablespace and reporting data in another.

The Oracle Schema or User

  • Oracle Schema and user are synonymous and the terms are usually used interchangeably
  • There can be thousands of users within one database
  • The schema owns segments and objects (tables, indexes,views, constraints, etc) and each segment/object can belong to only one schema

Upvotes: 1

user330315
user330315

Reputation:

A schema is not "associated" with a tablespace.

A user (=schema) can have a default tablespace, but that does not necessarily mean that all tables that user owns are stored in that default tablespace. If the user has the privileges, tables can be created in other tablespaces as well.

Upvotes: 1

Related Questions