"FC" <fcarpio@NOJUNKcomcast.netwrote in message
news:5-WdncLKndkd5YfeRVn-1g@comcast.com...
Quote:
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