Question about init file

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • FC
    #1

    Question about init file

    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
    Tags: None
    • Mark C. Stock
      #2
      Re: Question about init file


      "FC" <fcarpio@NOJUNK comcast.netwrot e in message
      news:5-WdncLKndkd5YfeR Vn-1g@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


        Comment

        • Altasen.com
          #3
          re:Question about init file

          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


            Comment

            Previous template Next
            Working...