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 60 of 2608 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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 Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

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 Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

About the SYSAUX TablespaceThe SYSAUX tablespace is always created at database creation. The SYSAUX tablespace serves as an … auxiliary tablespace to the SYSTEM tablespace. Because it is the default tablespace for many Oracle … of tablespaces required by the database. It also reduces the load on the SYSTEM tablespace.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

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 Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Altering a Bigfile TablespaceTwo clauses of the ALTER TABLESPACE statement support data file transparency when you are using … 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): With a bigfile tablespace, you can … use

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Space for Schema Objects

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 Enterprise Manager lists for \"All others\" in the … metrics categories

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

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, 11g Release 2 (11.2)

Managing Undo

Creating an Undo TablespaceAlthough Database Configuration Assistant (DBCA) automatically creates an undo tablespace for new … create an undo tablespace. There are two methods of creating an undo tablespace. The first method creates … the undo tablespace when the CREATE DATABASE statement is issued. This occurs when you are creating … =

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Undo

Altering an Undo TablespaceUndo tablespaces are altered using the ALTER TABLESPACE statement. However, since most aspects of … only attributes you are permitted to alter. If an undo tablespace runs out of space, or you want to … example adds another data file to undo tablespace undotbs_01: ALTER TABLESPACE undotbs_01 ADD DATAFILE … \" Oracle

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Undo

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, 11g Release 2 (11.2)

Managing Tablespaces

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, 11g Release 2 (11.2)

Managing Tablespaces

Making a Tablespace Read-OnlyTABLESPACE statement to change a tablespace to read-only. You must have the ALTER TABLESPACE or MANAGE … TABLESPACE system privilege. Before you can make a tablespace read-only, the following conditions must be … met. The tablespace must be online. This is necessary to ensure that there

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Creating a Default Permanent TablespaceThe DEFAULT TABLESPACE clause of the CREATE DATABASE statement specifies a default permanent … tablespace for the database. Oracle Database assigns to this tablespace any non- SYSTEM users for whom you … do not explicitly specify a different permanent tablespace. If you do not specify this clause, then … the SYSTEM

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Creating a Default Temporary TablespaceThe DEFAULT TEMPORARY TABLESPACE clause of the CREATE DATABASE statement creates a default … temporary tablespace for the database. Oracle Database assigns this tablespace as the temporary tablespace … for users who are not explicitly assigned a temporary tablespace. You can explicitly assign a

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Assigning Tablespace Quotas to Usersobjects the privilege to create the object and a quota (space allowance or limit) in the tablespace … , users only need the privileges to create the objects. No explicit tablespace quota is required to … create these PL/SQL objects. See Also: Oracle Database Security Guide for information about creating users and assigning tablespace

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Altering a Locally Managed TablespaceYou cannot alter a locally managed tablespace to a locally managed temporary tablespace, nor can … managed tablespaces. However, you can use the ALTER TABLESPACE statement on locally managed … tablespaces for some operations, including the following: Adding a data file. For example: ALTER TABLESPACE … lmtbsb ADD

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Limitations on Transportable Tablespace Usedocumented in the Oracle Database Globalization Support Guide. You cannot transport a tablespace to a … destination database that contains a tablespace of the same name. However, before the transport operation … , you can rename either the tablespace to be transported or the destination tablespace. Objects with

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

26 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, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Purpose of Creating Transportable Tablespace SetsA transportable tablespace set contains data files for a set of tablespaces and an export file … Export. One use of transportable tablespace sets is to create a tablespace repository. For example, if … sets for these tablespaces for storage in a tablespace repository. Subsequently, versions of the … tablespace

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Basic Concepts of Transportable Tablespace SetsYou create a transportable tablespace set by connecting RMAN to a source database as TARGET and … then executing the TRANSPORT TABLESPACE command. The source database contains the tablespaces to be … use by RMAN that can be recovered to the target point in time for the TRANSPORT TABLESPACE … operation. Figure 26-1 illustrates

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Basic Steps of Creating Transportable Tablespace SetsFigure 26-1 RMAN Transportable Tablespace from Backup: Architecture Description of \"Figure 26-1 … RMAN Transportable Tablespace from Backup: Architecture\" The process shown in Figure 26-1 occurs in … required for the tablespace transport but which are not themselves part of the transportable tablespace … stores

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Setting Initialization Parameters for the Auxiliary InstanceRMAN defines the basic initialization parameters in Table 26-1 for the automatic auxiliary instance.

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Creating a Transportable Tablespace Set at a Specified Time or SCNYou can specify a target time or SCN with the TRANSPORT TABLESPACE command. During the tablespace … transport operation, RMAN restores the tablespace at the auxiliary instance with backups from before … Example 26-3. Example 26-3 Specifying an End SCN TRANSPORT TABLESPACE tbs_2 TABLESPACE DESTINATION

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Specifying Auxiliary File LocationsAUXILIARY DESTINATION clause of the TRANSPORT TABLESPACE command and let RMAN manage all file … TABLESPACE SET NEWNAME FOR DATABASE See \"Using SET NEWNAME for Auxiliary Data Files\". CONFIGURE AUXNAME … specify names for data files. AUXILIARY DESTINATION clause of the TRANSPORT TABLESPACE command As … commands in a RUN block

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Customizing Initialization Parameters for the Auxiliary Instancevalues should work for nearly all TRANSPORT TABLESPACE cases, especially if you specify the … AUXILIARY DESTINATION option on the TRANSPORT TABLESPACE command. RMAN can also use an auxiliary instance

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Table 26-1 Default Initialization Parameters for the Auxiliary Instance(only if the AUXILIARY DESTINATION argument to TRANSPORT TABLESPACE is set). RMAN creates Oracle … TABLESPACE to fail. If you encounter a problem, then try returning the initialization parameter to

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Setting the Location of the Auxiliary Instance Parameter Filerunning TRANSPORT TABLESPACE. To specify a different location for the auxiliary instance parameter file … TRANSPORT TABLESPACE command. As with the default location of the auxiliary instance parameter file, the … initialization parameter file with TRANSPORT TABLESPACE as shown in Example 26-1. The SHARED_POOL_SIZE … { SET AUXILIARY

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Troubleshooting the Creation of Transportable Tablespace SetsWhen the RMAN TRANSPORT TABLESPACE command fails, the failed auxiliary instance files are left … tablespace sets to have the same name, then RMAN reports an error during the TRANSPORT TABLESPACE command. To

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Transportable Tablespace Set ScenariosThis section contains the following topics: Creating a Transportable Tablespace Set at a Specified

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Creating a Transportable Tablespace SetThis section describes the use of TRANSPORT TABLESPACE in the most basic and automated case. See … \"Transportable Tablespace Set Scenarios\" for variations on the basic case. It is assumed that you … have met the prerequisites described in the TRANSPORT TABLESPACE entry in Oracle Database Backup and … Database Administrator's

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

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.

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Creating Transportable Tablespace Sets

Specifying Locations for Data Pump Filesdirectory to which they are written. By default, these files are stored in the tablespace destination … export log in a different directory by using the DATAPUMP DIRECTORY clause of the TRANSPORT TABLESPACE … these files with the DUMP FILE, EXPORT LOG, and IMPORT SCRIPT clauses of TRANSPORT TABLESPACE. The … names specify file

Database SQL Language Reference, 11g Release 2 (11.2)

SQL Statements: ALTER TABLE to ALTER TABLESPACE

12 SQL Statements: ALTER TABLE to ALTER TABLESPACEThis chapter contains the following SQL statements: ALTER TABLE ALTER TABLESPACE

Database Reference, 11g Release 2 (11.2)

V$TABLESPACE

V$TABLESPACEdisplays tablespace information from the control file. Column Datatype Description TS# NUMBER … Tablespace number NAME VARCHAR2(30) Tablespace name INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3) Indicates … whether the tablespace is included in full database backups using the BACKUP DATABASE RMAN command … ( YES ) or

Database Backup and Recovery Reference, 11g Release 2 (11.2)

TRANSPORT TABLESPACE

TRANSPORT TABLESPACEPurpose Use the TRANSPORT TABLESPACE command to create transportable tablespace sets from RMAN … creating transportable tablespace sets described in Oracle Database Administrator's Guide apply to … SYSAUX tablespace must not be part of the recovery set, which is the set of tablespaces to be … transported. RMAN

Database Installation Guide for Linux, 11g Release 2 (11.2)

Optimal Flexible Architecture

Tablespace Required DescriptionEXAMPLE No The EXAMPLE tablespace used to store the Sample Schemas SYSAUX Yes Auxiliary tablespace … to the SYSTEM tablespace SYSTEM Yes Data dictionary segments TEMP Yes Temporary segments UNDOTBS1 … segments that can be dropped are allowed in the SYSTEM tablespace. See Also: \"Reviewing Tablespaces and

Database Installation Guide for Linux, 11g Release 2 (11.2)

Getting Started with Oracle Database

Tablespace Data File Descriptionan auxiliary tablespace to the SYSTEM tablespace. Some products and options that previously used the … SYSTEM tablespace now use the SYSAUX tablespace to reduce the load on the SYSTEM tablespace. SYSTEM … DISTINCT, then you may have to expand this tablespace. UNDOTBS UNDOTBS01.DBF Stores

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Increasing the Size of a TablespaceYou can increase the size of a tablespace by either increasing the size of a data file in the … tablespace or adding one. See \"Changing Data File Size\" and \"Creating Data Files and Adding Data Files … to a Tablespace\" for more information. Additionally, you can enable automatic file extension

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Altering a Locally Managed Temporary TablespaceNote: You cannot use the ALTER TABLESPACE statement, with the TEMPORARY keyword, to change a … locally managed permanent tablespace into a locally managed temporary tablespace. You must use the CREATE … TEMPORARY TABLESPACE statement to create a locally managed temporary tablespace. You can use ALTER

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Diagnosing and Repairing Locally Managed Tablespace ProblemsDiagnosing and Repairing Lo cally Managed Tablespace Problems Oracle Database includes the … state of the segments in a tablespace in which migration was stopped TABLESPACE_MIGRATE_FROM_LOCAL … Migrates a locally managed tablespace to dictionary-managed tablespace TABLESPACE_MIGRATE_TO_LOCAL … Migrates a dictionary-managed

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Specify the Tablespace for Each IndexIndexes can be created in any tablespace. An index can be created in the same or different … tablespace as the table it indexes. If you use the same tablespace for a table and its index, it can be more … convenient to perform database maintenance (such as tablespace or file backup) or to ensure … index in the

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Making a Read-Only Tablespace WritableUse the READ WRITE keywords in the ALTER TABLESPACE statement to change a tablespace to allow write … operations. You must have the ALTER TABLESPACE or MANAGE TABLESPACE system privilege. A … prerequisite to making the tablespace read/write is that all of the data files in the tablespace,

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Monitoring Occupants of the SYSAUX TablespaceThe list of registered occupants of the SYSAUX tablespace are discussed in \"About the SYSAUX … Tablespace\". These components can use the SYSAUX tablespace, and their installation provides the means … of establishing their occupancy of the SYSAUX tablespace. You can monitor the occupants of the SYSAUX … tablespace

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Controlling the Size of the SYSAUX TablespaceThe SYSAUX tablespace is occupied by several database components, and its total size is governed by … largest portion of the SYSAUX tablespace is occupied by the Automatic Workload Repository (AWR). The space … of space for its AWR data. The following table provides guidelines on sizing the SYSAUX tablespace … Oracle Database

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Undo

Sizing a Fixed-Size Undo Tablespacetablespace. If you decide to use a fixed-size undo tablespace, the Undo Advisor can help you estimate … available immediately. In such cases, continue to use the default auto-extending undo tablespace until … size of the undo tablespace. The advisor just returns a recommendation. You must use ALTER DATABASE

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Creating a Locally Managed SYSTEM Tablespacemanaged SYSTEM tablespace. The COMPATIBLE initialization parameter must be set to 10.0.0 or higher for … default the database creates a dictionary-managed SYSTEM tablespace. Dictionary-managed tablespaces … are deprecated. If you create your database with a locally managed SYSTEM tablespace, and if you are … DEFAULT TEMPORARY

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Multiple Temporary Tablespaces: Using Tablespace GroupsA tablespace group enables a user to consume temporary space from multiple tablespaces. Using a … tablespace group, rather than a single temporary tablespace, can alleviate problems caused where one … tablespace is inadequate to hold the results of a sort, particularly on a table that has many … partitions. A

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Shrinking a Locally Managed Temporary TablespaceLarge sort operations performed by the database may result in a temporary tablespace growing and … temporary tablespaces and release unused space. You use the SHRINK SPACE clause of the ALTER TABLESPACE … statement to shrink a temporary tablespace, or the SHRINK TEMPFILE clause of the ALTER TABLESPACE … statement

Database Concepts, 11g Release 2 (11.2)

Logical Storage Structures

Tablespace ModesNote: You cannot make a default temporary tablespace permanent. You can specify a user-named … default temporary tablespace when you create a database by using the DEFAULT TEMPORARY TABLESPACEtablespace is not defined at database creation, then SYSTEM is the default temporary storage. However … , the database

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Moving Occupants Out Of or Into the SYSAUX Tablespacetablespace, you can use the move procedure for that component, as specified in the V$SYSAUX_OCCUPANTS … view, to perform the move. The move procedure also lets you move a component from another tablespace into the SYSAUX tablespace.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Undo

Managing Space Threshold Alerts for the Undo TablespaceOracle Database also provides proactive help in managing tablespace disk space use by alerting you … when tablespaces run low on available space. See \"Managing Tablespace Alerts\" for information on … how to set alert thresholds for the undo tablespace. In addition to the proactive undo space alerts … . When the alert is generated,

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Using Automatic Undo Management: Creating an Undo TablespaceAutomatic undo management uses an undo tablespace. To enable automatic undo management, set the … in an undo tablespace and is managed by Oracle Database. To define and name the undo tablespace … yourself, you must include the UNDO TABLESPACE clause in the CREATE DATABASE statement at database … creates a default

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

Creating a Read-Only Tablespace on a WORM DeviceFollow these steps to create a read-only tablespace on a CD-ROM or WORM (Write Once-Read Many … ) device. Create a writable tablespace on another device. Create the objects that belong in the tablespace … and insert your data. Alter the tablespace to make it read-only. Copy the data files of the … tablespace

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Creating Data Files and Adding Data Files to a TablespaceYou can create data files and associate them with a tablespace using any of the statements listed … specifically described: SQL Statement Description Additional Information CREATE TABLESPACE Creates a … tablespace and the data files that comprise it \"Creating Tablespaces\" CREATE TEMPORARY TABLESPACE Creates

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Moving a Table to a New Segment or Tablespacepartition of a partitioned table into a new segment, and optionally into a different tablespace for … important reason to move a table to a new tablespace (with a new data file) is to eliminate the … the hr.admin_emp table to a new segment and tablespace, specifying new storage parameters: ALTER … ) TABLESPACE

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Performing Complete Database Recovery

Performing Complete Recovery of a Tablespace… You want to restore and recover the damaged tablespace while leaving the database open so that the … rest of the database remains available. This scenario assumes that database trgt has lost tablespace … users. To restore and recover a tablespace: Start RMAN and connect to a target database. If the … command to take

Database Installation Guide for Microsoft Windows, 11g Release 2 (11.2)

Installation Guide

Tablespace Data File Descriptionas an auxiliary tablespace to the SYSTEM tablespace. Some products and options that previously used … the SYSTEM tablespace now use the SYSAUX tablespace to reduce the load on the SYSTEM tablespace … DISTINCT, then you must expand this tablespace. UNDOTBS UNDOTBS01.DBF Stores undo information.

Database Concepts, 11g Release 2 (11.2)

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