Re: 40 gig big oracle database can be done smaller ?

On May 22, 2:56 pm, "Ed Yin" <vraa..._at_hotmail.nl> wrote:
> Hello,
>
> Can someone answere my questions about a hypothetical case..
>
> Let say i run a 9.* oracle database on a unix platform about 40 gig big with
> employee data in it and i want to chop it into peaces what would be the
> smartest thing to do if possible.
>
> what do i want to accomplish with this action:
>
> let say an error ocurred and i need to stop/restart the database all
> database users have to logout or something equal. or i need to add
> tablespaces or add or change datafiles.
>
> if i have "in my words" more then 1 database let say emp names A and B in
> DB1, C and D emp names in DB2 and i have a problem within DB1 should the
> users using DB2 not be influenced by the DB1 error ?
>
> And can some explain if it is possible and how it is done for example to
> make 1 connection or do 1 update form a application to the 1 record in DB1
> or DB2 all in relation to the questions above.
>
> sorry for bad english i hope i wrote my idea in understandable english :)
>
> thanks Ed

I concur with the others. I'd add, you may want to look at the high availability options if you truly have such a need. http://www.oracle.com/database/high-availability.html (of course, they are going to talk about 10g, but there are slightly less functional equivalents in 9i).

While you can add tablespaces and such with users on, you should do it during times of light load, since those things often put a noticeable drag on everything.

jg

--
@home.com is bogus.
I never watched it, but I can't help but wonder if those people
shipping tons of nuts to strangers have considered some people have
nut allergies?  http://www.savejericho.info/savingjericho.html#nuts