How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
DROP TABLESPACE → Purpose 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
CREATE TABLESPACE → Purpose 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
ALTER TABLESPACE → Purpose 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
Tablespace Modes → The tablespace mode determines the accessibility of the tablespace.
Tablespace File Size → A 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
19.1 Managing Tablespace Alerts → Oracle Database provides proactive help in managing disk space for tablespaces by alerting you when available space is running low.
13.2.7 Temporary Tablespace Groups → contains 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.
13.6 Altering Tablespace Availability → You 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
tablespace → A database storage unit that groups related logical structures together. The database data files are stored in tablespaces.
13.13 Migrating the SYSTEM Tablespace to a Locally Managed Tablespace → Use 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,
16.5.3 Dropping an Undo Tablespace → Use 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
19.1.1 About Managing Tablespace Alerts → managed 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
13.11 Managing the SYSAUX Tablespace → The 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
13.8.3 Altering a Bigfile Tablespace → You 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):
16.5.1 Creating an Undo Tablespace → Although 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.
16.5.2 Altering an Undo Tablespace → 22.214.171.124 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
13.14.1 Tablespace Data Dictionary Views → tablespaces 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
27 Creating Transportable Tablespace Sets → This 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
About Setting Initialization Parameters for the RMAN Auxiliary Instance → DESTINATION 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
Overview of Creating Transportable Tablespace Sets → This section explains the basic concepts and tasks involved in creating transportable tablespace sets from RMAN backups.