473,698 Members | 2,426 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4979

"FC" <fc*****@NOJUNK comcast.net> wrote in message
news:5-*************** *****@comcast.c om...
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
1682
by: Hunter Hou | last post by:
Hi, I have this program, compiling is passed, but when i wanted to get the executable file(g++ -o output input.o), it fails. Who can lead me where the error is? Thanks, Hunter ===
3
1533
by: John Ratliff | last post by:
I'm trying to overload the << and >> operators to serialize a class to disk. It writes things correctly, but it doesn't read them back correctly. Can someone tell what I'm doing wrong? Here is an example demonstrating my problem. ------- tmp.cc -------------- #include <cstdlib> #include <ctime> #include <fstream>
5
7027
by: Gelios | last post by:
Hello All! I am going to crazy and feeling myself so stupid but I don't understand such behaviour. I have code: public int getNextAgentId() { Int32 agent_id = 0; IDataReader dr = dbap.DBDataReader("SELECT MAX(agent_id) FROM Agents"); if(dr.Read()) { agent_id = dr.GetInt32(0);
0
1202
by: D Steward | last post by:
I am attempting to build a dll from some functions that were written in C, but I am running into some compiler errors. I am writting code in the dll as follows: #include <stdlib.h> #include <string.h> #include <math.h> #include <stdio.h> #include "stdafx.h"
2
1102
by: Craig Buchanan | last post by:
I have three classes: Core Assembly Application - creates instances of User using Activator.CreateInstance Item - marked MustInherit; has an Init method UserPlugin Assembly User - Inherits Item, has an Init method I would like to be able to call the Init method from the Application where
13
1719
by: Eric_Dexter | last post by:
All I am after realy is to change this reline = re.line.split('instr', '/d$') into something that grabs any line with instr in it take all the numbers and then grab any comment that may or may not be at the end of the line starting with ; until the end of the line including white spaces.. this is a corrected version from http://python-forum.org/py/viewtopic.php?t=1703
10
1411
by: iu2 | last post by:
Hi all I've got three files: file a1.py: ======== the_number = None file a2.py: ========
2
526
by: FC | last post by:
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...
2
4248
by: Christof Warlich | last post by:
Hi, I'm working on a (template) library that is up to now entirely implemented in header-files. This makes the library quite convenient to use as no extra object code needs to be linked when using the library. But now, the library needs to run some initialization code at system startup. Usually, this initialization code would be called from a .cc file once at system startup, e.g. by assigning the init function to a global variable:
0
8675
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8604
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9029
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7729
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6521
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5860
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2331
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.