| re: Question about init file
"FC" <fcarpio@NOJUNKcomcast.net> wrote in message
news:5-WdncLKndkd5YfeRVn-1g@comcast.com...[color=blue]
> 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[/color]
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
| 
