Wei Hu - Palo Alto CA, US Alexander Hwang - Orinda CA, US Alok Pareek - Brisbane CA, US Dmitry Potapov - Emerald Hills CA, US Francisco Sanchez - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 7/00 G06F 17/30
US Classification:
707809, 707803, 707802, 707790
Abstract:
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.
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 Hwang - Orinda CA, US Steven Wertheimer - Kentfield CA, US Francisco Sanchez - San Carlos CA, US Dmitry Potapov - Emerald Hills CA, US Juan Loaiza - Redwood City CA, US William Bridge - Alameda CA, US J. Lee - Redwood Shores CA, US
International Classification:
G06F007/00
US Classification:
707200000
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.