You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for tablespace


1 to 20 of 2600 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference, 12c Release 1 (12.1)

DROP TABLESPACE

DROP TABLESPACEPurpose Use the DROP TABLESPACE statement to remove a tablespace from the database. When you drop a … tablespace, Oracle Database does not place it in the recycle bin. Therefore, you cannot … subsequently either purge or undrop the tablespace. See Also: CREATE TABLESPACE and ALTER TABLESPACE

Database SQL Language Reference, 12c Release 1 (12.1)

CREATE TABLESPACE

CREATE TABLESPACEPurpose Use the CREATE TABLESPACE statement to create a tablespace, which is an allocation of space … in the database that can contain schema objects. A permanent tablespace contains persistent schema … objects. Objects in permanent tablespaces are stored in data files. An undo tablespace is a type of … permanent

Database SQL Language Reference, 12c Release 1 (12.1)

ALTER TABLESPACE

ALTER TABLESPACEPurpose Use the ALTER TABLESPACE statement to alter an existing tablespace or one or more of its … data files or temp files. You cannot use this statement to convert a dictionary-managed tablespace to … a locally managed tablespace. For that purpose, use the DBMS_SPACE_ADMIN package, which is … Guide and CREATE

Database Concepts, 12c Release 1 (12.1)

Logical Storage Structures

Tablespace ModesThe tablespace mode determines the accessibility of the tablespace.

Database Concepts, 12c Release 1 (12.1)

Logical Storage Structures

Tablespace File SizeA tablespace is either a bigfile tablespace or a smallfile tablespace. These tablespaces are … temp files. The difference is as follows: A smallfile tablespace can contain multiple data files or … temp files, but the files cannot be as large as in a bigfile tablespace. This is the default … tablespace

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Space for Schema Objects

19.1 Managing Tablespace AlertsOracle Database provides proactive help in managing disk space for tablespaces by alerting you when available space is running low.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.2.7 Temporary Tablespace Groupscontains information about space usage for each temporary tablespace. The information includes the space … 250609664 249561088 13.2.7 Temporary Tablespace Groups A temporary tablespace group is a tablespace group … that is assigned as the default temporary tablespace for the database.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.6 Altering Tablespace AvailabilityYou can take an online tablespace offline so that it is temporarily unavailable for general use … bring an offline tablespace online to make the schema objects within the tablespace available to … database users. The database must be open to alter the availability of a tablespace. To alter the … availability of

Database Concepts, 12c Release 1 (12.1)

Glossary

tablespaceA database storage unit that groups related logical structures together. The database data files are stored in tablespaces.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.13 Migrating the SYSTEM Tablespace to a Locally Managed TablespaceUse the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure to migrate the SYSTEM tablespace … must be met: The database has a default temporary tablespace that is not SYSTEM. There are no rollback … segments in the dictionary-managed tablespace. There is at least one online rollback segment in a … locally managed tablespace,

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Undo

16.5.3 Dropping an Undo TablespaceUse the DROP TABLESPACE statement to drop an undo tablespace. The following example drops the undo … tablespace undotbs_01: DROP TABLESPACE undotbs_01; An undo tablespace can only be dropped if it is … not currently used by any instance. If the undo tablespace contains any outstanding

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Space for Schema Objects

19.1.1 About Managing Tablespace Alertsmanaged tablespace —When you create a new locally managed tablespace, it is assigned the default … later in this section. Dictionary managed tablespace —When you create a new dictionary managed … tablespace, it is assigned the threshold values that Cloud Control lists for \"All others\" in the metrics … categories

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.11 Managing the SYSAUX TablespaceThe SYSAUX tablespace was installed as an auxiliary tablespace to the SYSTEM tablespace when you … now occupy the SYSAUX tablespace. If the SYSAUX tablespace becomes unavailable, core database … functionality will remain operational. The database features that use the SYSAUX tablespace

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.8.3 Altering a Bigfile TablespaceYou can resize or autoextend a bigfile tablespace. Two clauses of the ALTER TABLESPACE statement … you resize the single data file in a bigfile tablespace to an absolute size, without referring to … the data file. For example: ALTER TABLESPACE bigtbs RESIZE 80G; AUTOEXTEND (used outside of the ADD … DATAFILE clause):

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Undo

16.5.1 Creating an Undo TablespaceAlthough Database Configuration Assistant (DBCA) automatically creates an undo tablespace for new … installations, there may be occasions when you want to manually create an undo tablespace.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Undo

16.5.2 Altering an Undo Tablespace16.5.1.3 Using the CREATE UNDO TABLESPACE Statement The CREATE UNDO TABLESPACE statement is the … same as the CREATE TABLESPACE statement, but the UNDO keyword is specified. The database determines … most of the attributes of the undo tablespace, but you can specify the DATAFILE clause. This example … creates

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.14.1 Tablespace Data Dictionary Viewstablespaces of a database. View Description V$TABLESPACE Name and number of all tablespaces from the … . DBA_TABLESPACE_GROUPS Displays the tablespace groups and the tablespaces that belong to them. DBA_SEGMENTS … . DBA_TEMP_FREE_SPACE Displays the total allocated and free space in each temporary tablespace. V$DATAFILE … Information

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Creating Transportable Tablespace Sets

27 Creating Transportable Tablespace SetsThis chapter explains how to use RMAN to create transportable tablespace sets by restoring backups … . This discussion assumes that you are familiar with the transportable tablespace procedure described … for generating transportable tablespace sets.This chapter contains the following sections: Overview … of Creating Transportable

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Creating Transportable Tablespace Sets

About Setting Initialization Parameters for the RMAN Auxiliary InstanceDESTINATION argument to TRANSPORT TABLESPACE is set). RMAN creates Oracle managed control files and … inappropriate value in the auxiliary instance parameter file can cause TRANSPORT TABLESPACE to fail. If you

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Creating Transportable Tablespace Sets

Overview of Creating Transportable Tablespace SetsThis section explains the basic concepts and tasks involved in creating transportable tablespace sets from RMAN backups.