Question about init file - Oracle Database

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

Subscribe Post Reply

4961

Mark C. Stock

"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

Altasen.com

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

Similar topics

one overload question

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 ===

C / C++

file I/O question

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

C / C++

IDataReader Read() methid question

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

C# / C Sharp

Question about using math functions

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

.NET Framework

inheritance question

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

Visual Basic .NET

newbe's re question

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

Python

import from question

by: iu2 | last post by:

Hi all I've got three files: file a1.py: ======== the_number = None file a2.py: ========

Python

Question about init file

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

Oracle Database

init code in header-only library

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

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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

General

Changing the language in Windows 10

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

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

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

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA