Alexander E Hwang

US Patent:

8554806, Oct 8, 2013

Filed:

Oct 14, 2004

Appl. No.:

10/966679

Inventors:

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.

US Patent:

20050256908, Nov 17, 2005

Filed:

Oct 15, 2004

Appl. No.:

10/966961

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 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.