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

"FC" <fcarpio (AT) NOJUNKcomcast (DOT) net> wrote

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

Hi FC

what kind of defaults do you mean? Defaults for a column are set i
the create table-command

HTH

Roel Hogendoor
More information on Oracle can be found o
http://www.altasen.co