Re: Database DBSpace
Posted in 1998
mbaumgartner@cardhealth.com wrote:
>
> I have a database created in a non-root dbspace. I would like to relocate the
> database, not any tables, to another dbspace without unloading/exporting the
> database. Is it possible to relocate a database to another dbspace?
>
> Mark Baumgartner
> Cardinal Health
--
onunload and onload can help you
Usage: onunload [-l] [-t <tape device>] [-b <block size>] [-s <tape
size>]
<database>[:[<owner>.]<table>]
Usage: onload [-l] [-t <tape device>] [-b <block size>] [-s <tape size>]
[-d <DBspace>] <database>[:[<owner>.]<table>]
[{-i <old index name> <new index name>}]
[{-fd old-DBspace-name new-DBspace-name}]
[{-fi index-name old-DBspace-name new-DBspace-name}]
Francoise