Oracle - What Is an Oracle Tablespace in Oracle

What Is an Oracle Tablespace in Oracle

Q

What Is an Oracle Tablespace in Oracle?

✍: FYIcenter.com

A

An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes.

Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.

⇒Oracle Database Basic Concepts

⇒⇒Oracle Database Tutorials

2016-10-17, 295👍, 0💬

Popular Posts:

Verifying SQL Server...

How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

DATEDIFF() - Calcula...

How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...

Is SQL Server Transa...

Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...