Re: Question about init file

"FC" <fcarpio_at_NOJUNKcomcast.net> wrote in message news:5-WdncLKndkd5YfeRVn-1g_at_comcast.com...
> Hello all:
> I am fairly new the Oracle and SQL and I am trying to find out how can I
> achieve the following: I have a program that uses a database (schema for
> Oracle?) and I am creating NEW tables on an existing database. How can I
> set the defaults for my tables regardless of what the defaults for the
> database are? I am talking about the defaults that are set from the
> init.ora file. In other words, can I have my newly created tables go by a
> different init.ora (say init2.ora) file than the rest of the original
> tables in the database? How do I link my newly created tables to a
> different init.ora file?
>
> I want to make sure that the standard settings for my tables are met
> regardless of what the standard settings for the database are. Please
> help.
>
> FC

the init.ora file contains parameters for starting up the instance, not table-level parameters

you may want to look into default tablespace for the user, and default storage settings for the tablespace

++ mcs Received on Sun Sep 04 2005 - 23:57:27 CEST