Re: Table default settings

Thanks for your prompt response Ed.

The versions of Oracle are 9i and 10g, I am developing an application that currently runs on MS SQLServer. I am now in the process of making it compatible with Oracle. My tablespace is locally managed.

Recreating the tablespaces is no big deal for me, because I will have to do this only during new installation of my software. So if you tell me how to change the default settings at that point it will be great.

My unspecified changes will remain unspecified for now because I have to be able to map the MS SQLServer settings Vs. the Oracle settings, then I need to determine which settings are a must. But that is another story.

Why do I want to change the default settings? Because my application runs on systems that already have Oracle installed. Since they may have their own default settings I want to make sure my own defaults are satisfied without interfering with the owner's defaults.

You mentioned the ALTER commands, I am really not very familiar with them (yes, I am a newbie), is there a tutorial or a list that is available online for me to look at?

My problem is that I know what I want but I do not know what the terminology is, so that creates problems when searching for information.

Thanks in advance for your help. Received on Tue Sep 06 2005 - 11:36:24 CDT