Most of the applications I deal with run with a dedicated database. This makes management and configuration easier, and allows for finer-grained performance tuning.
Adding a prefix to the table names shouldn't be too hard, though, and from the other thread it sounds like almost everything has been done. Anyone volunteer to finish things up? -James On Tue, 2004-11-23 at 07:20 -0800, Richard Emberson wrote: > Our application has both tables that we have created and tables from > more than one external application, such a Slide. So how to keep table > names from colliding? One way of course is to create a different > database per section of one's application. Another is for each > creator of tables to assume that they will exist in a federated > system and thus they should take the effort as a good citizen of that > federation to make sure their table names are unique - one way to > do this is with a "namespace" suffix. > > Some in our group believed that they were the center of the universe > a could pick whatever table names they wished. Those with more > experience with integrating multiple separate software parts into > a whole knew that such belief were folly and lead to madness. > > Richard > > James Mason wrote: > > Not that I know of. That particular issue was resolved by creating the > > tables with a non-system user. In Oracle, that puts the tables in the > > default schema of the user (versus the System schema). > > > > Is this a feature that you need? > > > > -James > > > > On Mon, 2004-11-22 at 13:30 -0800, Richard Emberson wrote: > > > >>A little while ago someone was suggesting that they were working on > >>adding a feature that would allow one to specify a database table > >>prefix (to be used by all Slide tables) which would be used both by the > >>initialization sql and the java code. > >> > >>Is that work happening? > >> > >>Thanks. > >> > >>Richard > >> > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
