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


Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Transportable TablespacesTransportable tablespaces are the fastest way for moving large volumes of data between two Oracle … . Transportable tablespaces entirely bypass the unload and reload steps. Using transportable … export, transportable tablespaces provide a mechanism for transporting metadata

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

Transporting Tablespaces Between Databases

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

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

Transporting Tablespaces Between Databases

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

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

Transporting Tablespaces Between Databases

Compatibility Considerations for Transportable TablespacesWhen you create a transportable tablespace set, Oracle Database computes the lowest compatibility … transportable set. Beginning with Oracle Database 11 g, a tablespace can always be transported to a … a different platform. The database signals an error if the compatibility level of the transportable

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

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

Transporting Tablespaces Between Databases

Archiving Historical Data Using Transportable TablespacesSince a transportable tablespace set is a self-contained set of files that can be imported into any … transportable tablespace procedures described in this chapter. See Also: Oracle Database Data Warehousing Guide for more details

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

Transporting Tablespaces Between Databases

Using Transportable Tablespaces to Perform TSPITRYou can use transportable tablespaces to perform tablespace point-in-time recovery (TSPITR). See … Also: Oracle Database Backup and Recovery User's Guide for information about how to perform TSPITR using transportable tablespaces

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

Transporting Tablespaces Between Databases

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

Original Export and 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 … transportable tablespace metadata. TABLESPACES TRANSPORT_TABLESPACE See TABLESPACES

Database Data Warehousing Guide, 11g Release 1 (11.1)

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

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

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

Transporting Tablespaces Between Databases

Limitations on Transportable Tablespace Uselimitations include the following: Advanced Queues  Transportable tablespaces do not support 8.0-compatible … Be aware of the following limitations as you plan to transport tablespaces: The source and target … partitioned tables) are not transportable unless all of the underlying or contained objects are in the

Database Data Warehousing Guide, 11g Release 1 (11.1)

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

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 … about transportable tablespaces, see Oracle Database Administrator's Guide. … plug it in to another Oracle database, essentially moving tablespaces between the databases. To … move or copy a set

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

Transporting Tablespaces Between Databases

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 Administrator's Guide, 11g Release 1 (11.1)

Transporting Tablespaces Between Databases

Mounting the Same Tablespace Read-Only on Multiple DatabasesYou can use transportable tablespaces to mount a tablespace read-only on multiple databases. In … transportable set in the source database, put the transportable set onto a disk that is accessible … already exists, you make the tablespace read-only, generate the transportable set, and then import the

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

Transporting Tablespaces Between Databases

Step 2: Pick a Self-Contained Set of Tablespacestablespaces in the transportable set to be checked for self containment. You can optionally specify if … User's Guide. Note: The default for transportable tablespaces is to check for self containment rather … There may be logical or physical dependencies between objects in the transportable set and those

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

Transporting Tablespaces Between Databases

Publishing Structured Data on CDsTransportable tablespaces provide a way to publish structured data on CDs. A data provider can load … a tablespace with data to be published, generate the transportable set, and copy the transportable … example, suppose on a Windows NT machine D: drive is the CD drive. You can import a transportable

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

Creating Transportable Tablespace Sets

Specifying Auxiliary File Locationsone-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 NEWNAME in order … locations for transportable tablespace set or auxiliary set datafiles. RMAN restores each datafile for

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