469,568 Members | 1,506 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

Question about init file

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
2 4766

"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
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.

Similar topics

6 posts views Thread by Hunter Hou | last post: by
3 posts views Thread by John Ratliff | last post: by
5 posts views Thread by Gelios | last post: by
reply views Thread by D Steward | last post: by
2 posts views Thread by Craig Buchanan | last post: by
13 posts views Thread by Eric_Dexter | last post: by
10 posts views Thread by iu2 | last post: by
2 posts views Thread by FC | last post: by
2 posts views Thread by Christof Warlich | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.