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


Database SQL Language Reference, 11g Release 1 (11.1)

ALTER TABLESPACE

ALTER TABLESPACEPurpose Use the ALTER TABLESPACE statement to alter an existing tablespace or one or more of its … datafiles or tempfiles. 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 documented … Guide

Database SQL Language Reference, 11g Release 1 (11.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, 11g Release 1 (11.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 datafiles. An undo tablespace is a type of … permanent

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

Example 3: Displaying Statistics for Free Space (Extents) of Each TablespaceTo produce statistics about free extents and coalescing activity for each tablespace in the … database, enter the following query: SELECT TABLESPACE_NAME \"TABLESPACE\", FILE_ID, COUNT(*) \"PIECES … DBA_FREE_SPACE GROUP BY TABLESPACE_NAME, FILE_ID; TABLESPACE FILE_ID PIECES MAXIMUM MINIMUM AVERAGE … PIECES shows the number of

Database Administrator's Guide, 11g Release 1 (11.1)

Managing the SYSAUX Tablespace

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 1 (11.1)

Altering Tablespace Availability

Bringing Tablespaces OnlineYou can bring any tablespace in an Oracle Database online whenever the database is open. A … tablespace is normally online so that the data contained within it is available to database users. If a … tablespace to be brought online was not taken offline \"cleanly\" (that is, using the NORMAL clause of … the ALTER TABLESPACE

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

Example 2: Listing the Datafiles and Associated Tablespaces of a DatabaseTo list the names, sizes, and associated tablespaces of a database, enter the following query on the DBA_DATA_FILES view: SELECT FILE_NAME, BLOCKS, TABLESPACE_NAME FROM DBA_DATA_FILES; FILE_NAME BLOCKS TABLESPACE_NAME ------------ ---------- ------------------- /U02/ORACLE/IDDB3/DBF/RBS01.DBF 1536 RBS /U02/ORACLE/IDDB3/DBF/SYSTEM01.DBF 6586 SYSTEM /U02/ORACLE/IDDB3/DBF/TEMP01.DBF 6400 TEMP /U02/ORACLE/IDDB3/DBF/TESTTBS01.DBF

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Tablespace Availability

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 1 (11.1)

Managing the SYSAUX Tablespace

Controlling the Size of the SYSAUX TablespaceThe SYSAUX tablespace is occupied by a number of database components (see Table 2-2 ), and its … workload. The largest portion of the SYSAUX tablespace is occupied by the Automatic Workload … SYSAUX tablespace based on the system configuration and expected load. Parameter/Recommendation … of the SYSAUX tablespace

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Tablespace Alerts

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 1 (11.1)

Managing Tablespace Alerts

Viewing AlertsViewing A lerts You view alerts by accessing the home page of Enterprise Manager Database Control. Description of the illustration alerts_tablespace_full.gif You can also view alerts for locally managed tablespaces with the DBA_OUTSTANDING_ALERTS view. See \"Server-Generated Alerts Data Dictionary Views\" for more information.

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Tablespace Alerts

Limitationsfor such tablespaces after they become read/write or available. When you take a tablespace offline … or put it in read-only mode, you should disable the alerts for the tablespace by setting the … thresholds to zero. You can then reenable the alerts by resetting the thresholds when the tablespace is once … reclaim space that is

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

Example 1: Listing Tablespaces and Default Storage Parametersfollowing query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME \"TABLESPACE\", INITIAL_EXTENT … FROM DBA_TABLESPACES; TABLESPACE INITIAL_EXT NEXT_EXT MIN_EXT MAX_EXT PCT_INCREASE

Database Administrator's Guide, 11g Release 1 (11.1)

Managing the SYSAUX Tablespace

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 … default tablespace, which is SYSAUX. Later you discover that Ultra Search is using up too much space. To … $SYSAUX_OCCUPANTS view to relocate Ultra Search to another tablespace. The move procedure also lets you … move a component

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

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 1 (11.1)

Managing the SYSAUX Tablespace

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 1 (11.1)

Altering Tablespace Availability

Taking Tablespaces OfflineYou may want to take a tablespace offline for any of the following reasons: To make a portion of … offline tablespace backup (even though a tablespace can be backed up while online and in use) To make … application To rename or relocate tablespace datafiles See \"Renaming and Relocating Datafiles\" for … details.

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Tablespace Alerts

Setting Alert ThresholdsSetting Alert Thresh olds For each tablespace, you can set just percent-full thresholds, just free … —Locally Managed Tablespace The following example sets the free-space-remaining thresholds in the USERS … tablespace to 10 MB (warning) and 2 MB (critical), and disables the percent-full thresholds. BEGIN … operator, OPERATOR_GE.

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Tablespaces

Creating a Bigfile TablespaceTo create a bigfile tablespace, specify the BIGFILE keyword of the CREATE TABLESPACE statement … ( CREATE BIGFILE TABLESPACE...). Oracle Database automatically creates a locally managed tablespace … statement is the same as for the CREATE TABLESPACE statement, but you can only specify one datafile. For

Database Administrator's Guide, 11g Release 1 (11.1)

Altering and Maintaining Tablespaces

Altering a Bigfile TablespaceTwo clauses of the ALTER TABLESPACE statement support datafile transparency when you are using … tablespace to an absolute size, without referring to the datafile. For example: ALTER TABLESPACE bigtbs … RESIZE 80G; AUTOEXTEND (used outside of the ADD DATAFILE clause): With a bigfile tablespace, you can … use the

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Tablespaces

Creating a Tablespace GroupYou create a tablespace group implicitly when you include the TABLESPACE GROUP clause in the CREATE … TEMPORARY TABLESPACE or ALTER TABLESPACE statement and the specified tablespace group does not … those groups, each of which has only the specified tablespace as a member: CREATE TEMPORARY

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Undo Tablespaces

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 1 (11.1)

Creating Oracle-Managed Files

CREATE UNDO TABLESPACE: ExampleThe following example creates an undo tablespace named undotbs_1 with a datafile in the directory … /u01/oradata. The datafile for the undo tablespace is 100 MB and is autoextensible with an unlimited … UNDO TABLESPACE undotbs_1; See Also: Oracle Database SQL Language Reference for a description of the CREATE UNDO TABLESPACE

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Oracle-Managed Files

ALTER TABLESPACE: ExampleThis example adds an Oracle-managed autoextensible datafile to the tbs_1 tablespace. The datafile … statement is entered at the SQL prompt: SQL> ALTER TABLESPACE tbs_1 ADD DATAFILE AUTOEXTEND ON MAXSIZE 800M … ; See Also: Oracle Database SQL Language Reference for a description of the ALTER TABLESPACE statement

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Undo Tablespaces

Altering an Undo TablespaceUndo tablespaces are altered using the ALTER TABLESPACE statement. However, since most aspects of … attributes you are permitted to alter. If an undo tablespace runs out of space, or you want to prevent … adds another datafile to undo tablespace undotbs_01: ALTER TABLESPACE undotbs_01 ADD DATAFILE '/u01 … Database

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Undo Tablespaces

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 1 (11.1)

Specifying CREATE DATABASE Statement Clauses

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 1 (11.1)

Creating Oracle-Managed Files

CREATE TEMPORARY TABLESPACE: Examplecreates a tablespace named temptbs_1 with a tempfile in that location. The tempfile is 100 MB and is … /oradata'; SQL> CREATE TEMPORARY TABLESPACE temptbs_1; See Also: Oracle Database SQL Language Reference for a description of the CREATE TABLESPACE statement

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Tablespaces

Identifying a Bigfile TablespaceThe following views contain a BIGFILE column that identifies a tablespace as a bigfile tablespace … : DBA_TABLESPACES USER_TABLESPACES V$TABLESPACE You can also identify a bigfile tablespace by the

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Oracle-Managed Files

CREATE TABLESPACE: ExamplesDatabase SQL Language Reference for a description of the CREATE TABLESPACE statement CREATE … TABLESPACE: Example 1  The following example sets the default location for datafile creations to /u01 … /oradata and then creates a tablespace tbs_1 with a datafile in that location. The datafile is 100 MB and … /oradata'; SQL> CREATE

Database Administrator's Guide, 11g Release 1 (11.1)

Migrating the SYSTEM Tablespace to a Locally Managed Tablespace

Migrating the SYSTEM Tablespace to a Locally Managed TablespaceUse the DBMS_SPACE_ADMIN package to migrate the SYSTEM tablespace from dictionary-managed to … : 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 1 (11.1)

Creating Tablespaces

Assigning a Tablespace Group as the Default Temporary TablespaceUse the ALTER DATABASE...DEFAULT TEMPORARY TABLESPACE statement to assign a tablespace group as the … default temporary tablespace for the database. For example: ALTER DATABASE sample DEFAULT TEMPORARY … TABLESPACE group2; Any user who has not explicitly been assigned a temporary tablespace will now

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying CREATE DATABASE Statement Clauses

Specifying the Default Tablespace TypeThe SET DEFAULT...TABLESPACE clause of the CREATE DATABASE statement to determines the default type … of tablespace for this database in subsequent CREATE TABLESPACE statements. Specify either SET … DEFAULT BIGFILE TABLESPACE or SET DEFAULT SMALLFILE TABLESPACE. If you omit this clause, the default is

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying CREATE DATABASE Statement Clauses

Overriding the Default Tablespace TypeThe SYSTEM and SYSAUX tablespaces are always created with the default tablespace type. However, you … can explicitly override the default tablespace type for the UNDO and DEFAULT TEMPORARY tablespace … during the CREATE DATABASE operation. For example, you can create a bigfile UNDO tablespace in a … database with

Database Administrator's Guide, 11g Release 1 (11.1)

Transporting Tablespaces Between Databases

Limitations on Transportable Tablespace Usetablespace to a target database in which a tablespace with the same name already exists. However, you can … rename either the tablespace to be transported or the destination tablespace before the transport … tablespace set. Encrypted tablespaces have the following the limitations: Before transporting

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Tablespaces

Creating a Bigfile Temporary Tablespacethe CREATE BIGFILE TEMPORARY TABLESPACE statement to create a single-tempfile tablespace. See the … sections \"Creating a Bigfile Tablespace\" and \"Altering a Bigfile Tablespace\" for information about

Database Administrator's Guide, 11g Release 1 (11.1)

Using Read-Only 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 1 (11.1)

Guidelines for Managing Tablespaces

Assigning Tablespace Quotas to Usersobjects the privilege to create the object and a quota (space allowance or limit) in the tablespace … intended to hold the object segment. See Also: Oracle Database Security Guide for information about creating users and assigning tablespace quotas.

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying CREATE DATABASE Statement Clauses

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 1 (11.1)

Creating Tablespaces

Creating a Locally Managed TablespaceCreate a locally managed tablespace by specifying LOCAL in the EXTENT MANAGEMENT clause of the … CREATE TABLESPACE statement. This is the default for new permanent tablespaces, but you must specify the … (the default), or you can specify that the tablespace is managed with uniform extents of a specific … size ( UNIFORM ). If you

Database Administrator's Guide, 11g Release 1 (11.1)

Altering and Maintaining 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 datafile. For example: ALTER TABLESPACE … lmtbsb ADD

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Oracle-Managed Files

ALTER TABLESPACE... ADD TEMPFILE: Exampleadds a tempfile in the default location to a tablespace named temptbs_1. The tempfile initial size is … DB_CREATE_FILE_DEST = '/u03/oradata'; SQL> ALTER TABLESPACE TBS_1 ADD TEMPFILE; See Also: Oracle Database SQL Language … Reference for a description of the ALTER TABLESPACE statement

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying CREATE DATABASE Statement Clauses

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 Backup and Recovery User's Guide, 11g Release 1 (11.1)

Creating Transportable Tablespace Sets

Setting the Location of the Auxiliary Instance Parameter Filerunning TRANSPORT TABLESPACE. You can use the RMAN SET AUXILIARY INSTANCE PARAMETER FILE command in a RUN … block before TRANSPORT TABLESPACE to specify a different location for the auxiliary instance … TRANSPORT TABLESPACE as shown in Example 24-1. The SHARED_POOL_SIZE parameter in /tmp … FILE TO '/tmp/auxinstparams.ora'; TRANSPORT

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

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 … LOG, and IMPORT SCRIPT clauses of TRANSPORT TABLESPACE. The filenames cannot contain full file paths … TABLESPACE fails when it attempts to generate the export dump files. Use the DATAPUMP DIRECTORY … Export. The following scenario

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Creating Transportable Tablespace Sets

Purpose of Creating Transportable Tablespace SetsA transportable tablespace set contains datafiles 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 1 (11.1)

Creating Transportable Tablespace Sets

Troubleshooting Creation of Transportable Tablespace SetsWhen the RMAN TRANSPORT TABLESPACE command fails, the failed auxiliary instance files are left … files in the auxiliary or transportable tablespace sets to have the same name, then RMAN will report … an error during the TRANSPORT TABLESPACE command. To correct the problem, use different values for

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

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 1 (11.1)

Creating Transportable Tablespace Sets

Basic Steps of Creating Transportable Tablespace SetsBefore creating transportable tablespace sets you must meet a number of prerequisites. These … prerequisites are described in the TRANSPORT TABLESPACE entry in Oracle Database Backup and Recovery … Instance\". Execute the TRANSPORT TABLESPACE command. This basic technique is described in \"Creating a … Transportable Tablespace

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

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 24-3. Example 24-3 Specifying an End SCN TRANSPORT TABLESPACE tbs_2 TABLESPACE DESTINATION

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Creating Transportable Tablespace Sets

24 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 the transportable tablespace procedure described in … generating transportable tablespace sets.This chapter contains the following sections: Overview of … Creating Transportable Tablespace

Database Backup and Recovery User's Guide, 11g Release 1 (11.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.

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

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 24-1 illustrates

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Creating Transportable Tablespace Sets

Creating a Transportable Tablespace SetThis section describes the use of TRANSPORT TABLESPACE in the most basic and automated case. Refer … to \"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 … Database Administrator's

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Creating Transportable Tablespace Sets

Specifying Auxiliary File Locationscommand in a RUN block to specify filenames for use in TRANSPORT TABLESPACE. The SET NEWNAME commands … '/oracle/dbs/tbs_11.f' TO '/bigdrive/auxdest/tbs_11.f'; TRANSPORT TABLESPACE tbs_2 TABLESPACE … locations for transportable tablespace set or auxiliary set datafiles. RMAN restores each datafile for … you want

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Creating Transportable Tablespace Sets

Setting Initialization Parameters for the Auxiliary InstanceTRANSPORT TABLESPACE is set). RMAN creates Oracle-managed control files and online logs in this location … argument to TRANSPORT TABLESPACE is set). RMAN creates control files in this location. By default … the auxiliary instance parameter file can cause TRANSPORT TABLESPACE to fail. If you encounter a

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Creating Transportable Tablespace Sets

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

Database Administrator's Guide, 11g Release 1 (11.1)

Diagnosing and Repairing Locally Managed Tablespace Problems

Scenario 3: Fixing Bitmap Where Overlap is ReportedThe TABLESPACE_VERIFY procedure reports some overlapping. Some of the real data must be sacrificed based on previous internal errors. After choosing the object to be sacrificed, in this case say, table t1, perform the following tasks: Make a list of all objects that t1 overlaps. Drop table t1. If necessary, follow up by calling the SEGMENT_DROP_CORRUPT procedure. Call the SEGMENT_VERIFY procedure

Database Administrator's Guide, 11g Release 1 (11.1)

Diagnosing and Repairing Locally Managed Tablespace Problems

Scenario 1: Fixing Bitmap When Allocated Blocks are Marked Free (No Overlap)The TABLESPACE_VERIFY procedure discovers that a segment has allocated blocks that are marked free in the bitmap, but no overlap between segments is reported. In this scenario, perform the following tasks: Call the SEGMENT_DUMP procedure to dump the ranges that the administrator allocated to the segment. For each range, call the TABLESPACE_FIX_BITMAPS procedure with the TABLESPACE_EXTENT_MAKE_USED

Database Administrator's Guide, 11g Release 1 (11.1)

Diagnosing and Repairing Locally Managed Tablespace Problems

Scenario 5: Migrating from a Dictionary-Managed to a Locally Managed TablespaceUse the TABLESPACE_MIGRATE_TO_LOCAL procedure to migrate a dictionary-managed tablespace to a … locally managed tablespace. This operation is done online, but space management operations are blocked … existing extent sizes in tablespace tbs_1 are 10, 50, and 10,000 blocks (used, used, and free). The … MINIMUM EXTENT. The statement