Re: General question regarding external database deployment

AJ wrote:

> *** post for free via your newsreader at post.newsfeeds.com ***
>
> Hi all,
> I have been a dba/developer for a couple of years, but recently changed
> employer. From administrating "in-house" databases, I'm now dealing with
> one database which is part of a software product that is sold to
> customers.
>
> My question is regarding how I should deal with tablespaces, datafiles
> etc.
> Should I put all objects in the TOOLS tablespace or should I do what I am
> used to (splitting indexes and tables into different tablespaces etc.)?
>
> What is the common way to deal with such things when developing a database
> that is deployed "out-of-house"?
>
> AJ
>
> **** Post for FREE via your newsreader at post.newsfeeds.com ****
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** Newsfeeds.com - The #1 Usenet Newsgroup Service on The Planet! ***
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> http://www.newsfeeds.com | http://www.newsfeeds.com
> |
> * Anonymous posting server! | * Totally Uncensored!
> * SUPER Servers! | * Over 80,000 Newsgroups!
> * BINARIES ONLY Servers! | * 16 seperate Newsgroup Servers!
> * SPAM FILTERED Server! | * Instant access!
> * ADULT ONLY Server! | * Multiple OC 3's and OC 12's!
> * MP3 ONLY Server! | * 99% Article Completion!
> * MULTIMEDIA ONLY Server! | * Months of Retention!
> * 7 UNCENSORED Newsgroup Servers | * Lightning FAST downloads!
> |
> http://www.newsfeeds.com | http://www.newsfeeds.com
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> **** Point your newsreader to post.newsfeeds.com ****
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

I'd go with the rule of thumb: divide and conquer. Think of the troubleshooting/fixing errors:
It's easier to drop a tablespace and then rebuild 1 or 2 database objects (indexes, procedures)
than to rebuild an entire application. Received on Wed Dec 20 2000 - 15:52:00 CET