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


21 to 40 of 2289 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


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