10g: BIGFILE Type Tablespaces Versus SMALLFILE Type (Doc ID 262472.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document explains why a new type of tablespaces in a 10g version database and the precautions to be taken when using BIGFILE type tablespaces.

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

Scope

The document is intended for

Database administrators to know about the new type of BIGFILE tablespaces, how to use this new type.
Developers to be aware of incorrect results they can retrieve when using inappropriately the new type of tablespace for objects stored in different types of tablespaces.

Details

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

10g: BIGFILE Type Tablespaces Versus SMALLFILE Type (Doc ID 262472.1)

Applies to:

Purpose

Scope

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!