Inventors:
Wanli Yang - San Mateo CA, US
Bipul Sinha - Foster City CA, US
Amit Ganesh - San Jose CA, US
Wei Hu - Palo Alto CA, US
Alok Pareek - Brisbane CA, US
Alexander H. Hwang - Orinda CA, US
Steven Charles Wertheimer - Kentfield CA, US
Francisco M. Sanchez - San Carlos CA, US
Dmitry Mikhailovich Potapov - Emerald Hills CA, US
Juan R. Loaiza - Redwood City CA, US
William H. Bridge - Alameda CA, US
J. William Lee - Redwood Shores CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 7/00
Abstract:
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.