| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating tablespaces automatically
A copy of this was sent to dolans_at_stripe.Colorado.EDU (Sean Dolan)
(if that email address didn't require changing)
On 2 Mar 99 16:17:17 GMT, you wrote:
> We have a development machine that needs to be reformatted and rebuilt every so often.
Since we go through the same process every time, we would like to have a
"script" that does it for us. Is this possible?
> What we currently do is go through NT Instance manager, create a new one, go into
Storage manager, create our tablespaces, rollbakc segments, etc. and on and
on... can this be done through a script? Is a script being created as I do
this anyways right now? If so, could I use that one to recreate it later?
>Last question: once I have a script (.SQL) how do you run it or laod it?
>
>Thanks for your help,
>Sean Dolan
>sean_at_3si.com
Why not just take a full cold backup of a 'starter' database -- after you create the new ne, create the tablespaces, etc -- shutdown the database, copy the control, redo, init, and datafiles elsewhere. When you want to 'reset', get rid of your current control, redo, init and datafiles, put back the ones you copied and you are done.
Yes, you can just script it, but this will be *much* faster....
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |