I will gladly post such a thing to my web site.
Considering that I will soon be herding Oracle on NT,
rounding up a few NT pointers is not a bad idea.
We *do* have a goal of consolidating databases to Sun.
This NT stuff should be good for a few war stories,
Jared
On Monday 11 June 2001
The default is 20m in 8.1.5 = 8.1.7.
You can change it to 1m in 8.1.5, and '0' in 8.1.6
(which will default to 32k)
hth
connor
--- DEMANCHE Luc (Cetelem) [EMAIL PROTECTED]
wrote: Hi Ramesh
The java_pool_size is use want you work with the
JServer. Do you have a
Java stored proc, EJB or
but if the tables already contains dup records, how can u
make a unique constraint ? (even with enable novalidate)
--
From: Anshumn[SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 12:30 PM
To: Rahul
Subject: Re: Enforced Costraints ??
Hi Rahul,
Hi All,
Simple question...
How many columns one table will allow.. and why only that number of
columns are allowed.
Thank in Advance
S.S.Rao
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sambasivarao_Potla
INET: [EMAIL PROTECTED]
Fat City Network
i think the solution is to .
(on a table with non-unique values in a PK candidate column)
1) create a non-unique index on the pk candidate colunm
2) create the pk using enable novalidate clause
this way the existing data will NOT checked for uniqueness, the constraint
will be enforced for
am I missing something here ?? Why would you ever need to be in that
situation (a table with non-unique values in a PK column) ?
Apologies if this is a no-brainer.
Lee
-Original Message-
Sent: 12 June 2001 09:41
To: Multiple recipients of list ORACLE-L
i think the solution is to
Hi
We are exploring the possibility of generating ER diagram from the
Oracle 8i database. We want to know how it can be done.
Thanks Regards
Magesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: magesh
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hi,
We run our databases on NT and we face this problem once in a while. For the
benefit of our consultants working on the client side I had prepared a
document.
This has worked perfectly for me as well as for our consultants on the
client side.
I am aware that the present problem is removing one
Hi Gurus!
What can be wrong when I receive the following error message?
ORA-12545: Connect failed because target host or object does not exist
We use WinNT, Oracle 8.1.7 and Oracle Application Server.
Any Idea?
Thanks in advance
Gyula
--
Please see the official ORACLE-L FAQ:
On Jun 12, 2001 at 12:30:51AM, Sambasivarao_Potla wrote:
Hi All,
Simple question...
How many columns one table will allow.. and why only that number of
1000. Internal limit.
columns are allowed.
Do you need more?
--
Vladimir Begun | I wouldn't ever write the
DSS !
--
From: Robertson Lee - lerobe[SMTP:[EMAIL PROTECTED] ]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 4:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Enforced Costraints ??
am I missing something here ?? Why would you
O'Neill, Sean wrote:
Is there some way to calculate or make a realistic guestimate as to what
size an Export dump file will be for a given schema or indeed a whole
database. I've not come across anything on this topic before. If result is
dependant on O.S. I'm particularily interested in
hi magesh,
you can hire a product called ERWin 3.5 from Platinum corporation.
it's very handy tool to generate script/database from ERdiagrams and vice
versa.
it'll definitely solve ur search.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Ken and Kirti,
Oracle MetLink DOC ID: 75061.1 deals with cleaning ALL Oracle products from
a machine. Ken I suspect you could adopt this to your needs. I have used
this document and found it to be sound enough except for one minor caveat.
For Windows NT at Step 3, I'd make a note of the Oracle
254 in O7
how many datafiles allowed in O8 and why ? :))
--
From: Vladimir Begun[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 4:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Quer
On Jun 12, 2001 at
Title: RE: Oracle 8i database ER diagram
Hi Magesh,
We use ER-Win to manage our ER diagram. You can do a Reverse Engineer to create your first ER diagram. After that, you make changes in your ER Diagram and apply this changes by ER-Win.
Luc
-Message d'origine-
De: magesh
Not good enough ! According to various documents, you should add your own
primary key (surrogate key), which also makes it easier to keep track of
history and combine various sources. I agree with Lee: you should never
implement a PK with non-unique values.
Remco
-Oorspronkelijk
Hi all,
I accidentally rm all my control file, I forgot do
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
do you have any idea how to recover my control files ?
This is just a test server so I do not perform any backup datafiles nor
control files...,
Or do you have unix (Solaris 7) way
What about to use Oracle Designer?.
Regards.
Miguel Urosa.
12/06/2001 11.00
magesh
[EMAIL PROTECTED]
12/06/2001 11.01
Por favor, responda a [EMAIL PROTECTED]
Hello,
Yes you can. see
http://www.unal-bilisim.com/qa/discus/messages/20/42.html?9923410 for Unix.
I don't know NT. But, pipe mechanism is generic mechanism for Operating Systems
Theory. There should be a way for NT to create pipes. By pipes, you can
calculate.
regards...
"O'Neill, Sean"
These types errors are the errors which are casued by other errors. are
there any other errors including alert.log ?
[EMAIL PROTECTED] wrote:
Hi Gurus!
What can be wrong when I receive the following error message?
ORA-12545: Connect failed because target host or object does not exist
We
You may well be OK. All you need to do is fetch the database up in nomount
mode
startup nomount from svrmgrl.
SVRMGR startup nomount
ORACLE instance started.
Total System Global Area 6892912 bytes
Fixed Size 60784 bytes
Variable
DBAs,
I am working for a web developing and hosting company. My boss came out with
an idea of putting all the DB in a massive(!!) server so that we dont need
to have seperate server for each DB. He argues this is better idea than
having DB server for each site.
I am not sure how this will
Hi,
Oracle 8 datafile limits:
The maximum number of files at Oracle 8 is OS dependant but usually it's 1022
per tablespace and 65533 per database.
As with any program, the values of variables are held in control structures and
it's up to the developer to arrive at sensible maximum limits for
Ladies and Gents,
I'm off for a holiday in the sun for a week, in around 30 minutes, so
thought I'd say see you - and you all think of me sunning it on the beach,
while your slogging over a database :)
Bye Bye, and I'll have a drink for ALL of you :)
Mark
--
Please see the official ORACLE-L
A roughie (assuming your stats are up to date) would
be
select sum(num_rows * avg_row_len) * 1.1
from dba_tables
where owner in ( list to be exported )
added to
select sum(length(text))
from dba_source
where owner in ( list to be exported )
This doesn't take into account many things (view
You have to startup nomount and issue a 'create
controlfile' command listing all the bits and pieces
(that you can remember)
hth
connor
--- Sinardy Xing [EMAIL PROTECTED] wrote: Hi
all,
I accidentally rm all my control file, I forgot do
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Magesh,
You could use either of the following tools to build your ERD through
reverse engineering.
1. Oracle Designer
2. ERWIN
In my company we use both the above products. I personally prefer using
Oracle Designer due to many reasons (My reasons are irrelevant here for the
purpose of
I disagree. A simple reason for a non-unique index to
enforce a primary key are is to allowing a temporary
state of non-uniqueness to be permitted during a
transaction. eg insert a batch of new records (some
of which may be duplicates), then remove the bad ones,
then commit. (with deferred
Hi DBA's,
Greetings...
In some of application tables, i found not null columns are appeared at the
last.
So, how can i re-arrange by the way i can make the not null columns are in
the earliest of the table.
Is the only way to re-create the tables accordingly, or any other best
methods are
The documentation states Earlier versions of the Oracle database may work,
but only Oracle 8i 8.1.7 (Release 3) is supported.
The important thing is to have Oracle's Apache HTTP server, which comes with
either 8.1.7 or 9iAS. I have it installed under 9iAS with an 8.1.7 database
and it seems
Hi All,
Can someone explain pros/cons to using surrogate keys(i.e.,sequences) vs
non-surrogate keys?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Hi,
It allows you to have up to 1000 columns. If it allows more than this
then there will be performance issues. BTW, How much column you want to
have as max?
Muthaiah
At 12:30 AM 6/12/01 -0800, you wrote:
Hi All,
Simple question...
How many columns one table will allow.. and why only
Raj,
Your bosses idea might be OK with the following conditions.
1. If your database size is small (what is small is relative term. I
consider a database small if it is less than 200 GB)
2. If the number of users accessing the database is less (around 50 users).
3. If you have big server
Sean,
Thanks for posting the Doc Id. I do have access to Meatlink. I will take a
look.
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 5:16 AM
To:
Rick,
I use surrogate keys when the obvious primary key value has the possibility
of being updated by the application.
For example, you would think that a Social Security number might be a
candidate for use as a primary key in a college database. What we found
upon study is that, the Soc Sec #
I think there are a number of ways to implement something like that (like
catching exceptions), and choosing solutions like permitting temporary
states of non-uniqueness is asking for trouble. As long as I can see any
other option to return the same result, I would take it. This also prevents
the
In a DSS environment, it is a standard practice to create surrogate keys for
primary key. I never had experience with this (having duplicates in PK).
Perhaps a list member could tell what probs might arise.
Rao
-Original Message-
Sent: Tuesday, June 12, 2001 6:26 AM
To: Multiple
Cons
Primary Key has no bearing on data
Primary involves a sequence
Pros
Primary key will never risk change
Primary key will never risk being null
Multiple columns will not migrate to other tables on relationships
Very simple to implement
More efficient index use (as you don't have to use
I agree with not putting your multiple databases on one NT box - single
point of failure.
If you have to upgrade something or add a new driver, you may have to reboot
the machine. It's not so bad if you only have one db on it, it only
inconveniences those users.
If ALL your databases are on
Title: RE: Enforced Costraints ??
Well, here's one problem - there is no guarantee that Social Security Number will indeed be unique. SS#'s are reassigned, just like phone numbers are.
IMHO, surrogate keys are always a good idea. Has anyone got an example of when a surrogate key is NOT a
Title: RE: what's wrong with this...DBMS_SQL
Lisa,
You don't need DBMS_SQL.EXECUTE, when running other then DML
statements. DBMS_SQL.PARSE is enough.
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED]
- Original Message -
From:
Koivu, Lisa
To: Multiple
Title: SMP/MPP and PQO
Hello everyone,
I was reading up on the differences between SMP, MPP and how they may affect PQO (Parallel Query).
My understanding is that MPP is a host with defined domains (like an e10k with virtual machines on it). SMP is a standalone host with no domains and
Listers,
Since there was some discussion about the next platform on which 9i might be
released, I thought some might be interested in knowing that 9i for HP-UX is
now available on TechNet.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
Absolutely do not use ssn for a primary key. I ran into that as a
concern when I created a report. The ssn can be assummed by another
person, and you would have two persons with the same ssn. Plus the
already mentioned recycle of the ssn. I know of cases where the ssn
is taken by a person
You can enable constraint exceptions into exceptions clause.
Take a look at the enable constraints script on my site if want to see a
case of it.
ANTISPAMFILTERS(http://www.vampired.net)/ANTISPAMFILTERS
Walking on water and developing software from a specification are easy if
both are frozen.
You can reverse engineer with the evaluation copy of ERWin 4.0. I have
Designer but don't (can't) use it since it chokes when trying to reverse
engineer the entire database. I can do it a table at a time but it takes
forever. Don't like it one bit. Much prefer ERWin.
HTH
--
Please see the
Hi Nirmal,
Unfortunately, a table re-org (one way of the other) is the only solution
to do this. We use a third party tool that unloads, drops, creates, loads
the table. It also takes care of all the grants etc. Just a short cut to all
the manual steps.
Not sure if 9i has anything to address
Primary key is NOT NULL and UNIQUE.
Otherwise it isn't a primary key or a primary key canidate
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 12, 2001 5:00
It makes no difference in performance where the not null columns are placed. Why do
you want to go to the headache of modifying the table structure for something so
trivial?
[EMAIL PROTECTED] 06/12/01 08:45AM
Hi DBA's,
Greetings...
In some of application tables, i found not null columns
I had a friend a few years back that started receiving SS checks and he was in his
30's. It turned out that someone that had just retired had the same SSN as he did and
was wondering where his checks were.
-Original Message-
From: dan williams [mailto:[EMAIL PROTECTED]]
Sent:
When is your last holiday ?
-Original Message-
Sent: Tuesday, 12 June 2001 7:31 PM
To: Multiple recipients of list ORACLE-L
Ladies and Gents,
I'm off for a holiday in the sun for a week, in around 30 minutes, so
thought I'd say see you - and you all think of me sunning it on the
There's also a tool from Embarcadero called ER Studio, which is my personal
recommendation at the moment. I used to recommend ERWin, but then CA
bought it and it has only been lackadaisically maintained since then.
I think there are others...basically any decent ER modelling tool (and
Visio is
Would you mind explaining to me how to go about reverse-engineering a
database with Designer please. I downloaded Designer6i a couple of weeks
ago, and have been trying ever since to figure out how to reverse-engineer
our database into an ER diagram, but the docs for Designer are absolutely
I believe ERWin is now a CA product, so you could go to CA's web site to check it out.
You can also use Oracle's Designer which is a more high end product and cost more
money.
Visio can also reverse engineer your db and generate a simple ER diagram if that's all
you need.
Richard Ji
[EMAIL
Hi Robertson,
Your procedure is work for me,
When this database created, the creator kept the create database scripts, so
I able to retrieve some information from there,
(is in $ORACLE/assistants/dbca/jlib/SIDrun.sh)
Thank you, you are really brilliant
Sinardy
-Original Message-
Hi Harvinder!
Sorry - no, you can't use these commands inside PL/SQL.
set feedback on|off and alike are not SQL statements, but extensions
outside SQL ( indicated by SQL*PLUS )
only available in the SQL*PLUS executables , but not in the PL/SQL or SQL
engines of your
Oracle clients or
True and not true,
If the database is partitioned and using a local index. then you may want to
use the business key as a prefixed index. This way you could avoid the
additional index on the table.
NOTE: The table is partitioned by the surrogate key and the all foreign keys
in the child
Title: RE: what's wrong with this...DBMS_SQL
Parse
doesn't execute DDL in oracle 7. The parse call uses 'dbms_sql.v7' so I
would guess that even if the d/b is 8 it will use the 7
semantics.
Regards
David
Lord
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]]Sent:
I have no real solid design experience, but in the current model that I am
working on I created this table...
AUDIT DENIED LOGONS
| ADL Userid |
| ADL DateTime |
||
||
The two columns
Yes, 9i you can move modify drop add anything having to do with a table.
Pretty impressive.
Now to see it work and stand up the test of time. The ultimate test.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
Use Visio or Embarcadero client server tools.
At 01:00 AM 6/12/01 -0800, you wrote:
Hi
We are exploring the possibility of generating ER diagram from the
Oracle 8i database. We want to know how it can be done.
Thanks Regards
Magesh
--
Please see the official ORACLE-L FAQ:
Igor, read the docs more carefully.
it states that you should do the execute because the parse is NOT guaranteed
to work that way in the future.
Do does it work without the execute, yes, will in work in the future, maybe,
just do the execute and don't worry about it :)
right out of
We are about to move a production database to an HP XP256. Does anyone have
any experiences they would like to share?
Initially I was going the traditional route (split indexes and data, etc.)
and then was told *everything* would be RAID-5. Then I discovered SAME but I
don't think I can fully
Wow, I'v always been thinking that Oracle docs are rather good including
Designer. And I found them that.
You need at least two steps
1. In design editor generate-capture design of-server model-fill in
appropriate fields
2. In repository object navigator utilities-table to entity rettrofit-
and
Couldn't it also depend on whether or not it is a development box or a 24/7
box? Personally, we do developement here and I have multiple db's on single
NT servers. However, I have seen way too many crashes to imagine
attempting this with a 24/7 environement.
Just curious, what is
Then again, everything on one box cluster is less breakable parts.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 12, 2001 10:05 AM
To: Multiple recipients
One more cons : If the surrogate keys are populated from a single sequence, then the primary key index of that table becomes right hand index. Meaning all the new values will go in to the right most leaf block of the index due to the nature of the monotonically increasing or decreasing values. If
One possibility caould be database going down while you are connected.
We experienced similar thru perl couple of times coupled with ORA 3113
-Rahul
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 5:35 AM
Hi Gurus!
testing connection.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
yeah, I noticed that, I was quite surprized.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 12, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Embarcadero's ERStudio works pretty well (I like it better than ERWin).
You can download a demo copy from their website.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Biggest problem in Surrogate keys is partitions elimination does not work.
Usually the selection criteria is defined on the natural keys. So when
joining the dims and fact on the surrogate keys, Oracle can not do a good
job deciding up front which partition it needs. On the other hand it ends
Thanks to Lisa and others who replied.
I cannot use EXECUTE IMMEDIATE as my Oracle version is 7.2.2.That is the
reason I am using DBMS_SQL.
At the beginning, I used DBMS_SQL.EXECUTE(CUR1), it gave errors, hence I
dropped.
Now I have used it again after your suggestion and noticed the error
Hi All,
I'll add some points about NT backup to this list of steps...
1.a. Backup all drives, sample command could be
ntbackup backup c:\ d:\ /B /V /L D:\FULLBACKUP.LOG /D FULL SYSTEM
BACKUP
/B would backup registry.
1.b. Create one repair disk by typing command rdisk at command prompt.
But using DBMS_SQL.EXECUTE only solved my problem,
Suren
-Original Message-
Sent: Tuesday, June 12, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L
Thanks Igor for setting me straight. I don't see that in the doco but I am
looking at 8.1.7.
-Original
If you remove the datetime column you are going to get errors that the
unique constraint on the primary key is violated once someone tries to login
more than once and is denied.
Composite primary keys are fine, since you will not be updating these
columns. there is no need in this case for an
Yex,
Start Up designer.
Click on Repsitory Object Navigator
Select Application Systems
Click the Green Plus Icon (left menu bar) and create an application system
(name it something you like to identify it as your application).
Noe, go back to the Oracle Designer startup panel and Click on the
Another thing to consider is what happens if two people login at the same time with
the same userid. Your primary key will fail, but a sequence would not.
[EMAIL PROTECTED] 06/12/01 11:07AM
If you remove the datetime column you are going to get errors that the
unique constraint on the
Chris,
The question was, can you shuffle the order of the columns in 9i? Or add
new columns after/before a particular column?
- Kirti
-Original Message-
From: Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 11:07 AM
To: Multiple recipients of list
I beg to differ.
Storage as well as performance is effected if nulls are not at the end of a
table.
Although it is not a HUGE concern, it is certainly fine tuning.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Hi All,
If I have fields defined as NUMBER(2,0) and NUMBER(7,0) how much storage
does Oracle used if fields are NULL or the
fields do not use entire width.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
INET: [EMAIL PROTECTED]
SSN's are not recycled.
From the SSA OIG's testimony on SSN use and misuse before congress -
The SSN is a unique identifier
If its for application developers ease in INSERT etc. then how about
creating
a view which has columns in proper order?
-Rahul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 8:45 AM
Hi DBA's,
Greetings...
In some of
Actually I think Oracle recommends that NULL columns should be placed at the
end of the row for optimal storage of the row in the block.
- Ethan Post
-Original Message-
Sent: Tuesday, June 12, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L
It makes no difference in performance
Just a comment.
I am not a NT fan, and dispise using it for Oracle.
But I will repeat something I said many times.
For the $10,000-$20,000 budget, I can make an NT server out perform any unix
box on similar budget.
NT's problem is NOT that it is slow, I beg to differ, it can hold up with
most
SSN is great primary key for job security though.
Just think of all the happy cobol programmers during the new year?
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent:
Title: RE: what's wrong with this...DBMS_SQL
Did you try it?
Iam not sure about v7.
But under 8.1.5 it works.
And why 'parse' should necessarily use 'dbms_sql.v7' ?
Here is an example, which proves, that for DDLit's
enough to call 'parse' without 'execute':
SQLWKS declare cur1 integer;
2
At one point in time (96-98), I remember Digital Unix
(OSF) used to be the platform of choice for Oracle.
I recently had an interview at some place and the guy
was telling me that all the HA stuff comes out for HP
first since they're supposed to be a more reliable
platform than Sun. It sounds
Title: RE: ORA-12545
Well, then hope that your ip addresses don't change, and if they do, I hope your network admins will tell you. (do they always?) dns aliases are a nice way to shield your users from unexpected changes like this. You may want to follow up with your network admin to figure
In this particular application, every user has an assigned specific
userid.
So what are the odds that a specific userid will be denied a logon
more then once a second?? Hmmm..another item to be paranoid about...
Chris
-Original Message-
Sent: Tuesday, June 12, 2001 11:37 AM
To:
Yosi
I have tested and found CTAS use rollback.
Thanks
-Seema
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: rollback use query
Date: Mon, 11 Jun 2001 13:20:27 -0800
I'd hate to argue with Anita, but I'm pretty sure
Ok, so I was over analyzing the PK on this table. (big grin)
I still don't see a need for a surrogate key for this table.
Chris
-Original Message-
Sent: Tuesday, June 12, 2001 11:08 AM
To: Multiple recipients of list ORACLE-L
If you remove the datetime column you are going to get
Hi!
This errors happened me two weeks ago, and i solved writing IP address into
tnsnames.ora instead the dns name.
E.g:
PP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = 00.0..00)(Port = ))
)
(CONNECT_DATA =
(SID =PP)
)
)
regards
Hi
I have problem in starting the oracle8i database. It
is installed in intel solaris 8. After booting solaris
I am able to start databse. However when I shutdown
and start the database it gives the error that reco
background process did not start. The databse doesnot
even go to nomont stage.
SET ORACLE-L DIGESTIVE
=
Hamid Alavi
4268 Flintlock LN
Westlake Village 91631
PH: 818-8790966
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the
If user id is unique, not null, and never will be or will not change, then
no need for surrogate or datetime.
Surrogate keys are great because they are no hassle and easy. They do not
mutate 10 columns of a primary key into other tables everytime you have a
relationship with them. Although as
Yeh - but having co.uk in your email tells us all
that's the ONLY week of sun you'll see all year...
Signed
Disgruntled Aussie based in UK
--- Mark Leith [EMAIL PROTECTED] wrote: Ladies
and Gents,
I'm off for a holiday in the sun for a week, in
around 30 minutes, so
thought I'd say see
WHY NOT JUST SET ORACLE-L APERITIF?
-Original Message-
Sent: Tuesday, June 12, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L
SET ORACLE-L DIGESTIVE
=
Hamid Alavi
4268 Flintlock LN
Westlake Village 91631
PH: 818-8790966
__
I'm no fan of Designer, but here's how:
Start Designer 6i
Log into your Repository database and select (or create) your workarea.
Click on Design Editor
Choose Server Model
Select a container
Choose the Run the Design Capture utility
Give Designer the username, password, and connect string for
1 - 100 of 267 matches
Mail list logo