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
Transportable Tablespaces → Transportable 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
Using Transportable Tablespaces: Scenarios → The 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
Introduction to Transportable Tablespaces → Introduction 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
Compatibility Considerations for Transportable Tablespaces → When 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
Recovering Transportable Tablespaces → using 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
Archiving Historical Data Using Transportable Tablespaces → Since 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
Using Transportable Tablespaces to Perform TSPITR → You 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
Moving Databases Across Platforms Using Transportable Tablespaces → You 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.
Transportable Tablespaces → The 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
Transportation Using Transportable Tablespaces → Oracle 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
Exporting and Importing Transportable Tablespaces → Using 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
Limitations on Transportable Tablespace Use → limitations 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
Tablespaces → a 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
9.3.3 Using Transportable Tablespaces with a Physical Standby Database → You 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
Transporting Tablespaces Between Databases → topics: 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
Mounting the Same Tablespace Read-Only on Multiple Databases → You 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
Step 2: Pick a Self-Contained Set of Tablespaces → tablespaces 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
Publishing Structured Data on CDs → Transportable 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
Specifying Auxiliary File Locations → 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 NEWNAME in order … locations for transportable tablespace set or auxiliary set datafiles. RMAN restores each datafile for
Purpose of Creating Transportable Tablespace Sets → A 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.