Move a database to another dbspace
Hi family,
is there a way to move a database to a new dbspace?
I would rather not use dbexport/dbimport.
Of course I could simply alter fragment on all non-catalogs in the
database and move those into the desired dbspace, leaving the catalogs
in the old dbspace. But then anyone creating a new table in that
database would still (by default) creating it in the old dbspace.
Since this is also easily corrected after the fact - another alter
fragment - it's not so bad.
My objection to the dbexport/dbimport is that I don't want to deal with
recreating the sysnonyms, stored procedures and triggers, all of which
are already in place. I also wanto to move the catalogs out of the old
dbspace.
Is there a simpler means?
Thanks.
--
+---- Jacob Salomon -- DBA Barnes & Noble Booksellers -------------+
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
If you do a dbexport you get all the synonyms, etc. Running the export
brings them in automatically. We use it all the time.
Jacob Salomon wrote:
> Hi family,
>
> is there a way to move a database to a new dbspace?
>
> I would rather not use dbexport/dbimport.
>
> Of course I could simply alter fragment on all non-catalogs in the
> database and move those into the desired dbspace, leaving the catalogs
> in the old dbspace. But then anyone creating a new table in that
> database would still (by default) creating it in the old dbspace.
>
> Since this is also easily corrected after the fact - another alter
> fragment - it's not so bad.
>
> My objection to the dbexport/dbimport is that I don't want to deal with
> recreating the sysnonyms, stored procedures and triggers, all of which
> are already in place. I also wanto to move the catalogs out of the old
> dbspace.
>
> Is there a simpler means?
>
> Thanks.
> --
> +---- Jacob Salomon -- DBA Barnes & Noble Booksellers -------------+
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Hi...
> My objection to the dbexport/dbimport is that I don't want to deal with
> recreating the sysnonyms, stored procedures and triggers, all of which
> are already in place. I also wanto to move the catalogs out of the old
> dbspace.
Try dbexport <database> -ss
With this, you hav all triggers, stored procedures, extent sizes, lock
modes etc.
[]ao
LEO Cardoso
---