US5873102A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Pluggable tablespaces on a transportable medium
Assignee: Oracle International Corp
•
Filing: 1997-04-29
•
Granted: 1999-02-16
•
Expires: 2017-04-29
Abstract
Abstract A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces. A pluggable set of tablespaces is stored on a transportable medium in which all the disk pointers of the pluggable set is stored in tablespace-relative format. In addition, the pluggable set includes exported associated metadata about objects contained in the pluggable set. The pluggable set is plugged into a target database by making the pluggable set accessible to the target database and importing the associated metadata, without patching any of the disk pointers.
Inventors
- 👤 William H. Bridge, Jr.
- 👤 Jonathan D. Klein
- 👤 J. William Lee
- 👤 Juan R. Loaiza
- 👤 Alex Tsukerman
- 👤 Gianfranco Putzolu
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 16:38
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F16/2282; G06F16/25; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99942; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99955
Claims Analysis
Total Claims: 26
Claim 1
Independent Claim
72 words
A method of creating a pluggable set of tablespaces on a transportable medium, comprising the steps of: storing said pluggable set of tablespaces on said transportable medium in plug-in format, wherein each tablespace of said pluggable set of tablespaces includes a plurality of disk pointers stored in tablespace-relative format and wherein said pluggable set of tablespaces includes saved metadata; and removing said transportable medium from a receptacle accessible to a computer system.
Claim 2
Independent Claim
72 words
A method of creating a pluggable set of tablespaces on a transportable medium, comprising the steps of: storing said pluggable set of tablespaces on said transportable medium in plug-in format, wherein each tablespace of said pluggable set of tablespaces includes a plurality of disk pointers stored in tablespace-relative format and wherein said pluggable set of tablespaces includes saved metadata; and removing said transportable medium from a receptacle accessible to a computer system.
Claim 3
Dependent Claim
36 words
The method of claim 1, wherein the step of storing said pluggable set of tablespaces on said transportable medium in plug-in format further comprises the step of impressing said pluggable set of tablespaces on a CD-ROM.
Claim 4
Dependent Claim
37 words
The method of claim 1, wherein the step of storing said pluggable set of tablespaces on said transportable medium in plug-in format further comprises the step of storing said pluggable set of tablespaces on a magnetic disk.
Claim 5
Dependent Claim
37 words
The method of claim 1, wherein the step of storing said pluggable set of tablespaces on said transportable medium in plug-in format further comprises the step of storing said pluggable set of tablespaces on a magnetic tape.
Claim 6
Independent Claim
86 words
A method of plugging in a pluggable set of tablespaces in plug-in format stored on a transportable medium and having a plurality of disk pointers and saved metadata, into a target database, comprising the computer-implemented steps of: receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database; incorporating said saved metadata into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 7
Independent Claim
86 words
A method of plugging in a pluggable set of tablespaces in plug-in format stored on a transportable medium and having a plurality of disk pointers and saved metadata, into a target database, comprising the computer-implemented steps of: receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database; incorporating said saved metadata into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 8
Dependent Claim
30 words
The method of claim 5, wherein the step of incorporating said saved metadata into said target database, further comprises the step of importing said saved metadata into said target database.
Claim 9
Dependent Claim
65 words
The method of claim 6, further comprising the steps of: determining whether an external name of an object contained in said pluggable set of tablespaces exists in said target database; if said external name of said object contained in said pluggable set of tablespaces exists in said target database, then prompting the user to rename an object within said target database having said external name.
Claim 10
Dependent Claim
21 words
The method of claim 5, further comprising the step of copying said unplugged tablespace from said memory into said target database.
Claim 11
Dependent Claim
45 words
The method of claim 5, wherein the step of receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database further comprises the step of receiving a CD-ROM in a CD-ROM drive accessible to said computer system.
Claim 12
Dependent Claim
47 words
The method of claim 5, wherein the step of receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database further comprises the step of receiving a magnetic disk in a magnetic disk drive accessible to said computer system.
Claim 13
Dependent Claim
47 words
The method of claim 5, wherein the step of receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database further comprises the step of receiving a magnetic tape in a magnetic tape player accessible to said computer system.
Claim 14
Dependent Claim
71 words
A computer readable medium, having stored thereon sequences of instructions for creating a tablespace on a transportable medium, said sequence of instructions including instructions for performing the steps of: storing said tablespace on said transportable medium in plug-in format, wherein said tablespace in plug-in format includes a plurality of disk pointers stored in tablespace-relative format and saved metadata; and removing said transportable medium from a receptacle accessible to a computer system.
Claim 15
Dependent Claim
71 words
A computer readable medium, having stored thereon sequences of instructions for creating a tablespace on a transportable medium, said sequence of instructions including instructions for performing the steps of: storing said tablespace on said transportable medium in plug-in format, wherein said tablespace in plug-in format includes a plurality of disk pointers stored in tablespace-relative format and saved metadata; and removing said transportable medium from a receptacle accessible to a computer system.
Claim 16
Dependent Claim
32 words
The computer readable medium of claim 12, wherein the step of storing said tablespace on said transportable medium in plug-in format further comprises the step of impressing said tablespace on a CD-ROM.
Claim 17
Dependent Claim
33 words
The computer readable medium of claim 12, wherein the step of storing said tablespace on said transportable medium in plug-in format further comprises the step of storing said tablespace on a magnetic disk.
Claim 18
Dependent Claim
33 words
The computer readable medium of claim 12, wherein the step of storing said tablespace on said transportable medium in plug-in format further comprises the step of storing said tablespace on a magnetic tape.
Claim 19
Dependent Claim
97 words
A computer readable medium, having stored thereon sequences of instructions for plugging in a tablespace in plug-in format stored on a transportable medium and having a plurality of disk pointers and saved metadata, into a target database, said sequence of instructions including instructions for performing the steps of: receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database; incorporating said saved metadata into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 20
Dependent Claim
97 words
A computer readable medium, having stored thereon sequences of instructions for plugging in a tablespace in plug-in format stored on a transportable medium and having a plurality of disk pointers and saved metadata, into a target database, said sequence of instructions including instructions for performing the steps of: receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database; incorporating said saved metadata into said target database; and locating a data item associated with any one of said plurality of disk pointers without patching said plurality of disk pointers.
Claim 21
Dependent Claim
32 words
The computer readable medium of claim 16, wherein the step of incorporating said saved metadata into said target database, further comprises the step of importing said saved metadata into said target database.
Claim 22
Dependent Claim
75 words
The computer readable medium of claim 17, wherein said sequence of instructions further comprises instructions for performing the steps of: determining whether an external name of an object contained in said pluggable set of tablespaces exists in said target database; if said external name of said object contained in said pluggable set of tablespaces exists in said target database, then prompting the user to rename an object within said target database having said external name.
Claim 23
Dependent Claim
26 words
The computer readable medium of claim 16, further comprising instructions for performing the step of copying said unplugged tablespace from said memory into said target database.
Claim 24
Dependent Claim
47 words
The computer readable medium of claim 16, wherein the step of receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database further comprises the step of receiving a CD-ROM in a CD-ROM drive accessible to said computer system.
Claim 25
Dependent Claim
49 words
The computer readable medium of claim 16, wherein the step of receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database further comprises the step of receiving a magnetic disk in a magnetic disk drive accessible to said computer system.
Claim 26
Dependent Claim
49 words
The computer readable medium of claim 16, wherein the step of receiving said transportable medium into a receptacle accessible to a computer system that has access to said target database further comprises the step of receiving a magnetic tape in a magnetic tape player accessible to said computer system.
References Cited (Backward Citations)
US5396623A
Cited
US5579516A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-02-15 | 2002-08-17 | 2003-02-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-02-15 | 2006-08-17 | 2007-02-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-02-15 | 2010-08-17 | 2011-02-16 | $7700.00 | Window Closed / Lapsed |