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


1 to 20 of 1299 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

Managing Tablespaces

Using Transportable Tablespaces: ScenariosThe following sections describe some uses for transportable tablespaces: Transporting and Attaching … -Only on Multiple Databases Archiving Historical Data Using Transportable Tablespaces Using … Transportable Tablespaces to Perform TSPITR Transporting and Attaching Partitions for Data

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

Managing Tablespaces

Introduction to Transportable TablespacesIntroduction to Transpo rtable Tablespaces You can use the Transportable Tablespaces feature to … standard block size. Moving data using transportable tablespaces is much faster than performing either an … Release 1, you must use Data Pump for transportable tablespaces.

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

Managing Tablespaces

Compatibility Considerations for Transportable TablespacesWhen you create a transportable tablespace set, Oracle Database computes the lowest compatibility … the transportable set. Beginning with Oracle Database 11 g, a tablespace can always be transported to … transportable set is higher than the compatibility level of the destination database. The following

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

Performing User-Managed Recovery: Advanced Scenarios

Recovering Transportable Tablespacesusing the transportable tablespace feature Like normal tablespaces, transportable tablespaces are … The transportable tablespace feature of Oracle Database enables a user to transport a set of … tablespaces from one database to another. Transporting a tablespace into a database is like

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

Managing Tablespaces

Moving Databases Across Platforms Using Transportable TablespacesYou can use the transportable tablespace feature to migrate a database to a different platform by … tablespaces. See Oracle Database Backup and Recovery User's Guide for more information. You cannot … manually on the destination database, or use Data Pump to transport the objects that are not moved by transportable tablespace.

Database Utilities, 11g Release 2 (11.2)

Original Export

Transportable TablespacesThe transportable tablespace feature enables you to move a set of tablespaces from one Oracle … database to another. Note: You cannot export transportable tablespaces and then import them into a … transportable tablespace metadata. TABLESPACES TRANSPORT_TABLESPACE See \"TABLESPACES\"

Database Utilities, 11g Release 2 (11.2)

Original Import

Transportable TablespacesThe transportable tablespace feature enables you to move a set of tablespaces from one Oracle … database to another. Note: You cannot export transportable tablespaces and then import them into a … Administrator's Guide for details about managing transportable tablespaces Oracle Database

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Transportation Using Transportable TablespacesOracle transportable tablespaces are the fastest way for moving large volumes of data between two … Oracle databases. Previous to the introduction of transportable tablespaces, the most scalable data … , these files were loaded or imported into the target database. Transportable tablespaces

XML DB Developer's Guide, 11g Release 2 (11.2)

Exporting and Importing XMLType Tables

Exporting and Importing Transportable TablespacesUsing the transportable tablespace feature, you can move a set of tablespaces from one Oracle … transportable tablespaces mode, only the metadata for tables (and their dependent objects) within a specified … the source database to the target database. You cannot export transportable tablespaces

Spatial GeoRaster Developer's Guide, 11g Release 2 (11.2)

GeoRaster Operations

3.22 Using Transportable Tablespaces with GeoRaster DataYou can use the Oracle Database transportable tablespaces feature with GeoRaster data. If a … avoid such foreseeable conflicts before you use such transportable tablespaces in the source … , and validate again. For detailed information about transportable tablespaces and transporting

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

Managing Tablespaces

Transporting Tablespaces Between Databases: A Procedure and Example, place the set of tablespaces in read-only mode and generate a transportable tablespace set. A … transportab le tablespace set (or transportable set ) consists of data files for the set of tablespacesTablespaces There may be logical or physical dependencies between objects in the transportable

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

Managing Tablespaces

Transporting Tablespaces Between Databasestopics: Introduction to Transportable Tablespaces About Transporting Tablespaces Across Platforms … Limitations on Transportable Tablespace Use Compatibility Considerations for Transportable Tablespaces … Transporting Tablespaces Between Databases: A Procedure and Example

Database Data Warehousing Guide, 11g Release 2 (11.2)

Physical Design in Data Warehouses

Tablespacesa tablespace is the coarsest granularity for backup and recovery or the transportable tablespaces … , tablespaces are containers for physical design structures. Tablespaces need to be separated by … separated from large tables. Tablespaces should also represent logical business units if possible. Because

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing Physical and Snapshot Standby Databases

9.3.3 Using Transportable Tablespaces with a Physical Standby DatabaseYou can use the Oracle transportable tablespaces feature to move a subset of an Oracle database and … site to plug the tablespace into the standby database. For more information about transportable tablespaces, see Oracle Database Administrator's Guide. … plug it in to another Oracle database, essentially moving tablespaces

Spatial Developer's Guide, 11g Release 2 (11.2)

What's New in Oracle Spatial?

Cross-Endian Operations Supported for Transportable Tablespaces Containing Spatial IndexesFor the SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS procedure (documented in Chapter 32 ), transportabletablespaces containing spatial indexes are now supported across endian format platforms (big-endian to

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 … you have a database with some tablespaces used for quarterly reporting, you can create transportable … reports. Another use for transportable tablespaces is in an Oracle Streams environment.

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

Creating Transportable Tablespace Sets

Specifying Auxiliary File Locationsbest used with one-time operations. If you expect to create transportable tablespaces from backup … regularly for a particular set of tablespaces, then consider using CONFIGURE AUXNAME instead of SET … persistent locations for transportable tablespace set or auxiliary set data files. RMAN restores each data

Database Concepts, 11g Release 2 (11.2)

Glossary

transportable tablespaceA tablespace that you can copy or move between databases. Oracle Data Pump provides the infrastructure for transportable tablespaces.

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Transportable Tablespaces Example Suppose that you have a data warehouse containing sales data, and…transported. Additionally, in a given transportable-tablespace operation, multiple tablespaces can be … . Note, however, that the transportable tablespace feature can only transport a set of tablespaces … especially created to temporarily store data for use by the transportable tablespace features. Following

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

Backing Up the Database

Backing Up Tablespaces and Datafiles with RMAN/write or read-only. Note: Transportable tablespaces do not have to be in read/write mode for backup … You can back up one or more tablespaces with the BACKUP TABLESPACE command or one or more datafiles … with the BACKUP DATAFILE command. When you specify tablespaces, RMAN translates the tablespace name … internally