When performing an inter-platform migration operation, due to natural OS incompatibilities, the most commonly used method is a regular export/import (exp/imp or the Data Pump version). This approach happens not to be a scalable solution. The amount of data to transfer is directly proportional to the time taken to complete. Day by day databases are growing larger and the maintenance windows are becoming narrower, so a logical data transfer may leave us in a very uncomfortable situation. If the database is 10g Release 1 or higher, the DBA can take advantage of the inter-platform transportable tablespace feature. The total amount of time it takes to have the database migrated to the target platform is equal to the time it takes to prepare all tablespace metadata to be exported, plus the time it takes to copy the datafiles to the target platform, plus the time to apply the inter-platform datafile conversion, plus the time it takes to have the metadata imported...
Oracle 10g/11g Data and Database Management Utilities
Oracle 10g/11g Data and Database Management Utilities
Overview of this book
Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface
Free Chapter
Data Pump
SQL*Loader
External Tables
Recovery Manager Advanced Techniques
Recovery Manager Restore and Recovery Techniques
Session Management
Oracle Scheduler
Oracle Wallet Manager
Security Management
Database Configuration Assistant
Oracle Universal Installer
Enterprise Manager Configuration Assistant
OPatch
Customer Reviews