By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

Question about init file

P: n/a
FC
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
Sep 4 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"FC" <fc*****@NOJUNKcomcast.net> wrote in message
news:5-********************@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
Sep 4 '05 #2

P: n/a
Hi FC,

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

HTH,

Roel Hogendoorn
More information on Oracle can be found on
http://www.altasen.com

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.