Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure
US7188124B2 · kind B2 · utility
2Cited by
28References
18Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 19, 2003 |
| Grant date | Mar 6, 2007 |
| Priority date | — |
| Expiry date | Nov 3, 2024 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.