Oracle International Corporation

Francisco Sanchez

Dmitry Mikhailovich Potapov

Alok Pareek

Wei Ming Hu

Wanli Yang

Alexander Hwang

Shen-Ban Meng

Benoit Dageville

Amit Ganesh

Juan R Loaiza

Tirthankar Lahiri

Lik Wong

Karl Dias

Mohamed Ziauddin

James William Stamos

Gary C Ngai

Bipul Sinha

Mark Charles Ramacher

William Bridge

Alex Tsukerman

J William Lee

Vasudha Krishnaswamy

Sujatha Muthulingam

Graham Wood

Gianfranco Putzolu

Benny Souder

Leng Leng Tan

Hung Viet Tran

Steven Wertheimer

Sushil Kumar

Richard Sarwal

Vishwanath Karra

Hsiao-te Su

Stored data are transported between different systems having different platforms by converting the format of the stored data into a common format either before or after transmitting the stored data from the source database system to the target database system. The common format may be a format that is universal in that the common format is not machine dependent. The stored data may be kept in the common format at the target database system and never converted to another format. Optionally, the stored data may be converted from the common format to a format associated with the target database system, thereby facilitating backward compatibility. A tool may be provided for performing the conversion.

Cross platform transportable tablespaces

To export source tablespaces, an auxiliary database system is created and started with a minimum configuration. Copies of versions of the source tablespaces are restored from database backups to the auxiliary database system. A copy of a version of a tablespace is referred to herein as a tablespace instance. The tablespace instances restored from database backups are recovered to a particular point-in-time. A script is then generated. The script can be executed by a database server of the destination database to import the tablespace instances.

Online tablespace recovery for export

A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.

Cross-platform transportable database

An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

Self-managing database architecture

Growing community of inventors

San Carlos, CA, United States of America

Francisco Sanchez