Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-03-06
2007-03-06
Channavajjala, Srirama (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C714S020000
Reexamination Certificate
active
10718009
ABSTRACT:
A technique for recovering a dropped table is provided. One or more table spaces are specified prior to one or more tables being dropped from the specified one or more table spaces. When a table is to be dropped from the one or more specified table spaces, a table identifier, a time stamp, and table definition attributes are stored for the dropped table in a data structure and the table is dropped. Upon receiving a request to restore a table space from the one or more specified table spaces, each of the one or more tables in the table space being restored is recovered using the data structure.
REFERENCES:
patent: 4697266 (1987-09-01), Finley
patent: 5295256 (1994-03-01), Bapat
patent: 5553279 (1996-09-01), Goldring
patent: 5555404 (1996-09-01), Torbjornsen et al.
patent: 5596710 (1997-01-01), Voigt
patent: 5625815 (1997-04-01), Maier et al.
patent: 5646871 (1997-07-01), Cadot
patent: 5802514 (1998-09-01), Huber
patent: 5873102 (1999-02-01), Bridge et al.
patent: 5890167 (1999-03-01), Bridge et al.
patent: 5918225 (1999-06-01), White et al.
patent: 5930795 (1999-07-01), Chen et al.
patent: 5937415 (1999-08-01), Sheffield et al.
patent: 5987472 (1999-11-01), Serafin
patent: 5999192 (1999-12-01), Selfridge et al.
patent: 6003026 (1999-12-01), Bonzi
patent: 6073129 (2000-06-01), Levine et al.
patent: 6112024 (2000-08-01), Almond et al.
patent: 6115704 (2000-09-01), Olson et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6144970 (2000-11-01), Bonner et al.
patent: 6157928 (2000-12-01), Sprenger et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6606617 (2003-08-01), Bonner et al.
patent: 6684225 (2004-01-01), Huras et al.
patent: 6792435 (2004-09-01), Ruddy
patent: 7028022 (2006-04-01), Lightstone et al.
patent: 7031987 (2006-04-01), Mukkamalla et al.
patent: 2001/0051956 (2001-12-01), Bird
patent: 2004/0103109 (2004-05-01), Huras et al.
patent: 2005/0114365 (2005-05-01), Tucker
patent: 2249080 (2001-12-01), None
patent: 2419883 (2004-08-01), None
patent: 1201950 (1998-12-01), None
patent: 0690367 (1996-01-01), None
patent: 1385100 (2004-01-01), None
patent: 2279165 (1994-12-01), None
patent: 61082227 (1986-04-01), None
patent: 63211445 (1988-09-01), None
patent: 3022152 (1991-01-01), None
patent: 3116249 (1991-05-01), None
patent: 4178846 (1992-06-01), None
patent: 4188342 (1992-07-01), None
patent: 5181729 (1993-07-01), None
Sun Hwan Kem et al. “A design and implementation of savepoints and partial rollbacks considering transaction isolation levels of SQL2”, proceedings of the sixth international conference on database systems for advanced applications, Apr. 1999, 10 pages.
“Oracle 7 recovery scenarios and equivalent Oracle 8 recovery manager techniq”, Aug. 26, 1998, 9 pages.
Georg Rehfeld, Installation of Oracle V 7.0.16.4.0 for the linux V 1.2.1, Jul. 21, 1998, 7 pages.
Oracle Database Backup and Recovery advanced user's guide 10g release 1 (10.1) Part No. B10734-01, copyright 2003, 24 pages.
“Recovery manager Oracle database 10g”, feature overview:, Oracle database 10g Recovery manager feature overview, May 2004pp. 1-9.
Huras Matthew Albert
McInnis Dale M.
Ofer Effi
Winer Michael J.
Zheng Roger Luo Q.
Channavajjala Srirama
Davda Janaki K.
Konrad Raynes & Victor LLP
LandOfFree
Method, system, computer product for recovering dropped... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method, system, computer product for recovering dropped..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, computer product for recovering dropped... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3730963