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 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