Bruce et all myself and a couple of workmates will also be in Sydney early
evening, and will be finding a place for a beer so maybe we can catch up
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical Consultant
On Wed, 22 May 2002, Santosh Varma wrote:
I wanted to know what is this RedHat, its significance and its features. Any
links/doc's on that ???
Thanks and regards,
Santosh:
This is a bit off-topic, so we should probably keep it short. RedHat is a
commercial company which created a
I've seen some really bizarre job postings in the last year or so (Requires 10 years
Oracle DBA
experience with 2 years Oracle9i production experience on IBM SP2 ... $50-60k), but
this one has
some unique aspects...
Candidate should be able to travel 100% and be local to the DFW or Austin, TX
To steal a quote from Matt Adam's white board (sorry Matt!):
You gotta stop thinking logically, and start thinking Oracley - Jim Droppa
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 2:00 PM
IBM mainframe. Nothing beats these dinosaurs.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 6:08 AM
Our data warehouse box is nearing it's max capacity so we are looking for
options for an upgrade. The
Upgrade to 9iR2 today.
Rename column does not work in 9.0.1.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 9:30 PM
If those times are right... its a functionality you
should not live without, its a
The accompanying messgage is
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of rollback segment (0))
ORA-01594: attempt to wrap into rollback segment (0) extent (1) which is
being
freed
-Message d'origine-
De: DENNIS
hi !
Did anyone successfully use the USE_SHARED_SOCKET env variable with Oracle
8.1.7 on NT?
If so , how do you overcome the bug 1566794 , please ?
Thanks a lot in advance
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
Or you can go straight into damagement. It requires no technical skills, no people
skills and the innate ability to royally screw things up. Upon completion of screwing
things up, leaving a mess for the DBA to cleanup, you then are promoted to a higher
level damagement position with a pay
Stephane
How do we make the character set French?(WE8ISO8859P15) on our test
database?
(Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?).
Is this something that has to be done when installing Oracle, or when
creating the database(SID)? If so, how do we specify that we want this
I am looking for the address of oracle news server.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
It looks like you only have 1 extent within the system rollback segment
anyway?
Why are you trying to shrink it? Do you have other rollback segments in
place?
-Original Message-
Gilbert
Sent: 23 May 2002 11:48
To: Multiple recipients of list ORACLE-L
The accompanying messgage is
alter
Hello everybody,
I was wondering if anybody has real hands-on experience with either a
combination of both RAC and NAS or just running 9i on an NAS. What are the
pros and cons ? Does anybody have some input on this topic ? Maybe some
helpful links besides technet ?
TIA
Stefan
--
Please see
Hi
Character set is choosen at database creation time (create database
statement).
It can not be changed later unless export recreate import is an option
Jack
Use a cursor. Select the data into the cursor from 'x' and then insert it
into 'y'.
---
CREATE TABLE Y (
Y_IDNUMBER(10),
Y_LONG LONG,
);
--
cursor x_cursor is
select
X_ID
, X_LONG
from X;
--
BEGIN
For Y_ROW IN X_CURSOR LOOP
INSERT
Dennis,
I have on my desk, all in varying stages of being read:
Inmon's book Building the Data Warehouse (very understandable)
Kimball's articles from his site and from the Intelligententerprise.com
site (somewhat understandable, I think you need a base from which to
read his articles). His
I am trying to do this.
alter rollback segment SYSTEM shrink;
alter rollback segment R01 shrink;
alter rollback segment R02 shrink;
alter rollback segment R03 shrink;
alter rollback segment R04 shrink;
alter rollback segment SYSTEM shrink
*
ERROR at line 1:
ORA-01595: error freeing extent (1) of
if travel is 100% why does it matter WHERE you are local to?
--- Tim Gorman [EMAIL PROTECTED] wrote:
...and you have to share a single motel room with 11 other people (3
shifts
of four), surrender accumulated frequent-flyer miles to the client,
provide
your own chair, laptop, and printer,
Mladen,
You? Sarcastic? Never :)
--- Mladen Gogala [EMAIL PROTECTED] wrote:
O
if you are enthusiastic and are adaptable and can express that to a
prospective employer you might get into what you want. I think
attitude
My advice to those who want to become DBAs is that they
I think in 8i there is a command for altering characterset. Look in docu for
alter database or alter instance. You should be careful when doing this.
regards
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Jack van Zanen
I'd never have thought that this was possible
in Advanced Replication
Hemant K Chitale
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, 23 May, 2002 12:48 AM
At last something that I have experience in.
Just do the following:
On the
Nope. .4 is supposed to be the last PSR (patchset release)
for 8.1.7
Hemant K Chitale
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, 23 May, 2002 4:33 AM
I hear that .5 is right around the corner.
Vinny
--- Ruth Gramolini
An upgrade wouldn't cost anything. It would be free
as part of your support contract.
Hemant K Chitale
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, 23 May, 2002 2:41 AM
Kevin,
I appreciate your testing efforts. Now to convince the
How large are the rollback segments?
The ORA-01594 error states:
attempt to wrap into rollback segment (string) extent (string) which is
being freed
Cause: Undo generated to free a rollback segment extent is attempting to
write
into the same extent due to small extents and/or there are too
On 2002.05.23 07:08 Yechiel Adar wrote:
I am looking for the address of oracle news server.
metalink.oracle.com
--
Mladen Gogala
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Ok i blew away rh 7.2 on laptop last night, did a plain install of rh
7.3
did the install of 9ir2 afterwards
here is the only issue i've come up with:
Problem: Context option would not link, click ignore and let the installer
go on its merry way
Solution:
1. As root, cd /lib
2. rm
The Oracle Store lists two products which allow connections
from Oracle to DB2 on a mainframe, Enterprise Integration Gateway and
Mainframe Integration Gateway. The latter costs more than twice as
much as the former. Can anyone who has used these products tell me
how I can determine which one I
On 2002.05.23 02:23 Santosh Varma wrote:
I wanted to know what is this RedHat, its significance and its
features. Any
links/doc's on that ???
Thanks and regards,
Santosh
Red hat is a piece of clothing which makes a fashion statement. It is
very
impractical during the hot summer days
A question has been posed to me, when to switch from NT to unix for
oracle.
Is it when the NT box starts getting out of memory issues, number of
transactions, size of db?
just looking for some ball park answers.
thanks, joe
We are running Oracle 8.1.7.3.2 on W2K/NT.
We have experienced a problem while applying Oracle Apps patches that CPU
shot to 100% for 4 threads. The weird part is that the patch had aborted
so nothing was running in the database. Bouncing database cleared the
problem.
Continued with more
On 2002.05.23 07:03 Farnsworth, Dave wrote:
Or you can go straight into damagement. It requires no technical
skills, no people skills and the innate ability to royally screw
things up. Upon completion of screwing things up, leaving a mess for
the DBA to cleanup, you then are promoted to a
because they use vans instead of airplanes?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 7:23 AM
if travel is 100% why does it matter WHERE you are local to?
--- Tim Gorman [EMAIL PROTECTED] wrote:
...and you have
It should be noted that this only alters a character set that is a *SUBSET*
of the current character set. You cannot do something like change from a
Russian character set to a Japanese one for instance.
There is a document that provides a compatibility matrix - something like
Oracle National
-- Santosh Varma [EMAIL PROTECTED]
I wanted to know what is this RedHat, its significance and its features.
Any links/doc's on that ???
It is the most common corporate Linux distribution out
there. The people at RH worked with Oracle, IBM, Sybase,
and other package vendors to help them port
Title: RE: ORA_ENCRYPT_LOGIN
Hmm...after trying to verify password being passed as plain text, I went back to
do some research on metalink, and it looks like encryption of passwords is done
by default in 8.1.5 (Net8) and higher. Only confusion now is whether I need to
set ORA_ENCRYPT_LOGIN =
I heard that too, but I think that they'll be weighing their options.
If 8.1.7.4 is messed up badly, they'll probably give us 8.1.7.5 for
Christmas.
On 2002.05.23 09:33 Hemant K Chitale wrote:
Nope. .4 is supposed to be the last PSR (patchset release)
for 8.1.7
Hemant K Chitale
-
Does any one have or know of any documents on the Web that contain screen
shots of the Oracle installer in action(Preferably 8i Enterprise Edition on
AIX)?
I need to to include these in some documentation, but don't really want to
do an install just to get some screen shots?
--
Please see
Hemant,
The price I am referring to is the cost involved with moving from a
Dell server on Novell to a Compaq OpenVMS server. There are a lot of
company sided issues that have to be addressed and cases made for the
move. In this case the software is not an issues as you stated, the
issues
Mary,
We've been very happy with our mix of HP-9000 series UNIX servers and EMC
disk arrays. Right now the 1TB warehouse is running on a K570 with 4 processors
and 2 GB of RAM. The server supports two database instances with no problems.
We're going to upgrade to a L2000 4 way class
Title: TEST
TEST
Title: RE: ORA_ENCRYPT_LOGIN
Here is what the docs have to say...
By setting the following values, you can require that the password used to verify a connection always be encrypted:
Set the ORA_ENCRYPT_LOGIN environment variable to TRUE on the client machine.
Set the
John Dunn
Hey Joe:
I generally switch from NT to Unix when availability becomes a central
issue. When you can look at the
performance monitor in NT and see that the box is not scaling properly is
another cautionary flag.
Additionally, people switch when they get frustrated with the
Or unless the old characterset is US7ASCII and the new characterset is a
superset of that, like UTF8, WE8ISO8859Px, etc., and you're database is at
least v8.x.
Then you can follow MetaClink article 66320.1, where you just need a few
ALTER DATABASE commands and a few instance bounces.
Rich Jesse
Do you know any web based query tool for end users except oracle
solutions
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Brio.
Dick Goulet
Reply Separator
Author: Arslan Bahar [EMAIL PROTECTED]
Date: 5/23/2002 7:13 AM
Do you know any web based query tool for end users except oracle
solutions
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
BDY.RTF
Description: RTF file
Hi
Are these patch sets cumulative? If I am at 8.1.7.0 can I
just apply the 8.1.7.4 patch set or do I have to apply
them all in order. Thanks.
-Original Message-
Travis
Sent: May 22, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
Is there such a thing as being TOO knowledgable and
well-read? I don't think so!
/jack
Dennis,
I have on my desk, all in varying stages of being
read:
Inmon's book Building the Data Warehouse (very
understandable)
Kimball's articles from his site and from the
I don't know. I've gotten several messages from this 'techiedude' over the last
couple of days that were not addrressed to the list. I think he/she is just a
spammer.
Dick Goulet
Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date:
Does anyone know if these are available for download off of Technet? I've
looked and can't seem to find them. Second question, is online
requisitioning part of Procurement? Any urls or info would be
appreciated.
Thanks,
Sean
-.-..-.-..-.--..-
Heavyweight Internet Consulting
Get Oracle News at the Oracle newsroom www.oracle.com/newsroom/
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 05/23/02 09:53AM
On 2002.05.23 07:08 Yechiel Adar wrote:
I am looking for the address of oracle news server.
metalink.oracle.com
--
Mladen Gogala
--
Please see the official ORACLE-L FAQ:
Yeah, been there...attached is the presentation I created, which is purely
composed of screen shots of the Oracle installer screens. It was for an
Oracle install on Windows NT.
HTH
-Original Message-
Sent: Thursday, May 23, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Does
Hi all:
We are running oracle 8.1.7.2 in parallel mode.
A DBA on my team noticed that when he moves a table
into a new tablespace via:
alter table XXX move tablespace YYY;
the table XXX's NEXT extent is being changed to its
original value (the one table was created with). Even
when he tried
LOL - Mladen, you are bad!
-Original Message-
Sent: Thursday, May 23, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
On 2002.05.23 02:23 Santosh Varma wrote:
I wanted to know what is this RedHat, its significance and its
features. Any
links/doc's on that ???
Thanks and
Rachel
- Glad Inmon's book is working for you. I have only read (or more
correctly attempted to read) his articles, which can be found at
http://www.datawarehousing.com/, or at least they previously were available.
- Just be aware that when you switch from reading Inmon or one of his
When you get started. Never, in my book, use NT for anything other than a
sandbox.
Dick Goulet
Sworn ANTI MicroSoft warrior.
Reply Separator
Author: JOE TESTA [EMAIL PROTECTED]
Date: 5/23/2002 5:48 AM
A question has been posed to me, when to
No, you can't download them but you can buy them for £28 plus delivery from
the CD Packs section of the Oracle Store.
Cheers
Mike
-Original Message-
Sent: 23 May 2002 16:09
To: Multiple recipients of list ORACLE-L
Does anyone know if these are available for download off of Technet?
As a side note, please please please become familiar with OpenVMS and more
importantly Oracle on OpenVMS before tackling this. At least as far up as
8i, Oracle has really done themselves a disservice by bastardizing their own
install on OpenVMS. There is no OFA on OpenVMS. It is VERY difficult
You can do it at anytime if the character set you are changing to is a
supset of the current set. If it is not, you will have to export and import
you database for the changes to take place.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Joe,
Please locate the flack jacket and wrap it security around your
body. You are about to get a barrage of comments ranging from ASAP, to
fix what you have.
I would suggest that sense you asked the question that there must be
something in the wind at your location that would cause you to
Been there, Done that, Works in production.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 3:33 PM
I'd never have thought that this was possible
in Advanced Replication
Hemant K Chitale
-
Oh yeah...oh yeah!! Oracle Data Warehousing 101 coming up
-Original Message-
Sent: Thursday, May 23, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L
Outdated?
Dennis,
I have on my desk, all in varying stages of being read:
Inmon's book Building the Data Warehouse (very
read my electrons here:
I AM NOT WRITING ANOTHER BOOK.
--- Grabowy, Chris [EMAIL PROTECTED] wrote:
Oh yeah...oh yeah!! Oracle Data Warehousing 101 coming up
-Original Message-
Sent: Thursday, May 23, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L
Outdated?
That's not panicking, just common sense.
Too many data warehouse projects went down the drain
so you need to learn all you can before starting such project.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002
Stefan - By NAS, I assume you mean Network Attached Storage. We use a Net
Appliance on our test server and it works well for the purpose. Basically we
have about a dozen Oracle instances which are used infrequently, so it
provides tons of cheap storage that isn't used that much. I found out the
Rich,
I thank you for the heads up. I have read the install and release
notes for Oracle on OpenVMS and will approach with a lot of caution. I
am very familiar with the Unix world commands and expected actions but,
the OpenVMS commands I have to learn and try to understand before I
attempt the
So have you tried increasing this?
-Original Message-
Gilbert
Sent: 23 May 2002 15:44
To: Multiple recipients of list ORACLE-L
50K
-Message d'origine-
De: Mark Leith [mailto:[EMAIL PROTECTED]]
Date: jeudi 23 mai 2002 15:59
À: Multiple
comp.databases.oracle.server
comp.databases.oracle.tools
comp.databases.oracle.misc
comp.databases.oracle.marketplace
I access these via groups.google.com
-Joe
--- Yechiel Adar [EMAIL PROTECTED] wrote:
Sorry, I wish that e-mails had a way to attach what I wanted
to say.
I meant news group
First things first Joe - forget NT and use Win2K!!
When memory needs become greater than 3gig,.
When reliability is *essential* (24*7).
Security is essential (yea yea they *say* it's secure - but...)
Mark
===
Mark Leith | T: +44
Alex - the reg is the place:, hlocal soft oracle all_homes last_home.
hth,
gene
[EMAIL PROTECTED] 05/22/02 12:53PM
Looks like no takers, except one whos great advice was to find it somewhere
in the registry.
Alex Hillman
-Original Message-
Hillman
Sent: Monday, May 20, 2002
I know. That's my nature. I even advised a young lady from LA to do the
same.
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RedHat
LOL - Mladen, you are bad!
Actually... I thought it was rather good.
-Original Message-
Sent: Thursday, May 23, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
LOL - Mladen, you are bad!
-Original Message-
Sent: Thursday, May 23, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
On
Hello Joe
I think that the main reason is response
time.
An NT machine can get only 4 CPUs.
If you have all the CPUs and memory and the NT does
not carry the load
then it is time to consider a change.
A change can be to Unix or to
clustering.
If you are all NT shop then I would consider
Maybe we should birth a new catch phrase -
DAFGS
(Do a **Fine** Google Search)
-Original Message-
Wells
Sent: Thursday, May 23, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Actually... I thought it was rather good.
-Original Message-
Sent: Thursday, May 23, 2002
Sorry, I wish that e-mails had a way to attach what I wanted
to say.
I meant news group on the subject of oracle.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 3:53 PM
On 2002.05.23 07:08 Yechiel
They have royally messed up the library cache,
We are applying applying .. work arounds for this 8.1.7,Each time we
call up they come back saying that there is a work around for this.
We have very heavy contentions on library cache, the sql which are using
bind variables are not getting
The patchsets _are_ cumulative. You can
go direct from 8.1.7.0 to 8.1.7.3 or to 8.1.7.4
[we normally don't go to the latest patchset level
but wait a few weeks or a couple of months to
see that no major issues are reported with the
latest patchsetlevel].
Hemant K Chitale
- Original
The bane of trying to keep up with technology.
But why OpenVMS and not Tru64, then.
We have a large number of Tru64 Oracle Databases
(we do have OpenVMSs for Promis databases
used in manufacturing, I believe).
Hemant K Chitale
- Original Message -
To: Multiple recipients of list
Hi all,
I did some testing on sorts. I sorted a table of 269 MB. I did set the
sort_area_size to a minimum value of 10k. I set event 10032 to level 1 and
looked after the initial runs to be able to calculate a good value for
sort_area_size. Once this done, I did run the statement with event
vms is a great os, if only dec ported it to the intel chip, then ms would not be what
it is today. ohh well, that's history. for installs on vms use oracleins not the gui
installer. they give you 2 choices, guess b/c the gui doesn't work :). wish they
would bring back orainst /c for unix!
Number of users. I have a 170G Oracle 8.1.6 database running on WinNT 4.0
with 3xx of RAM just fine, as long as there are no more than 2 users. Jump
up to about 16 users and response time goes down the tube.
So I guess that transactions are the answer. I don't have any benchmarks.
Just my
I can add to Jesse's comments. VMS has always been the bastard of Oracle
Platforms even though it was written for VMS initially. Remember that Larry
first wrote Oracle on the VMS platform.
The installation process is actually very clean as compared to many other
environments. Yes, it does
Thanks Joe
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 23, 2002 6:23 PM
comp.databases.oracle.server
comp.databases.oracle.tools
comp.databases.oracle.misc
comp.databases.oracle.marketplace
I access
Ron:
There's a list at
iouga-vms-l
The traffic is very-very-very-very light. However, when I've needed help,
the responses have been exceptional.
Good luck!
Barb
--
From: Ron Rogers[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, May
Dennis,
We are active participants in the process. We are also making an offer
to someone with an extensive background in developing data warehouses,
which will help me to sleep much more comfortably at night :)
Rachel
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Rachel
- Glad Inmon's book
Here are my 0.02EUR
Turn this reasoning around: Why would anyone use NT for a serious Oracle
DB-server?
Okay, for some minor development perhaps, but for an production environment?
b.t.w., ever considered a switch to VMS?
Arno Disser
--
Please see the official ORACLE-L FAQ:
As suggested by Frank, turning on Cached option of Quick I/O really helped
the reads (at the same time with some negative impact on writes). At this
point I have enabled cache quick i/o on data file systems. This is on a sun
e10k with 28 cpu and 28g ram.
If anyone who has used cached quick i/o
I have done OPS/RAC on 7.x, 8.x, 8i and 9i w/IBM SP,
RS/6000 and Sun.
Believe it or not you can encounter database hangs on
OPS/RAC on any of these versions that you do not
encounter on non-OPS/RAC solutions (or as Oracle likes
to put it in some cases slows down so much that it
appears hung).
Hermat - We are on Tru64 and I couldn't be more pleased. However, I believe
that HP/Compaq has decided to eventually withdraw Tru64. My guess is that is
so they can support HPUX. However, they were pretty clear that OpenVMS would
continue. My guess is that Ron is hinting that there are other
Sort area size is used to sort, but so is the temporary table space. Can
increase your sort area size? Both sort_area_size and
sort_area_retained_size need to be looked into.
sort_area_retained_size specifies in bytes the maximum amount of the user
global area (UGA) memory retained after a
The readme added today on 8.1.7.4 patch says:
Post Release Issues Issues that are discovered after release of this
patch set are documented on the Oracle Metalink website. Customers
should check here for the latest status prior to installing this patch
set in a production environment.
To see
Hemant,
Being an ol unix admin I would like very much to use Tru64 but we
have a lot of applications written for OpenVMS that would have to be
converted and then there would be the issue of sysadmin training or hire
and licensing issues and costs. These all cost $$$ and we are an
institution
Thanks, Barb.
From the traffic on this issue I think that there is quite a few VMS
users on the list. They have been quiet and do not generate a lot of
traffic. Does this mean that I have to watch all of the other traffic
and think to myself why not convert to VMS and not have the
problems?
Hi List,
I faced with an strange problem, I have an query some times when I run this
query I got error ORA-01722 invalid number and then when I rebuild the table
then rerun the query it's running OK, anybody have any idea what should be
wrong.
Same table same query failed first time then when I
Rachel,
This was just received from the SearchDatabase email and I thought
it might be of interest to you.
.
TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2)
By William McKnight, SearchCRM Expert
Another question I received [last week at the Data Warehousing
VMS uses logicals as much as Unix uses environment variables. I use vms logicals and
unix env variables in my db create scripts. VMS logicals also work for init.ora
params (eg. control_files) whereas in Unix, you must spell it out.
gene
*used vms b4 dos was around :)*
[EMAIL PROTECTED]
Here is an informative article entitled Sane SAN, by James Morle that
describes the use of SAN and NAS from a database performance perspective.
Good reading...
http://miracleas.dk/DBF/Morle/Sane_SAN_WP.pdf
HTH,
david
David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Ron - I have my VMS env set similar to my unix env. I use vms symbols to match unix
aliae's/cmds, vms logicals to match unix env variables, vms dcl scripts to match unix
ksh scripts. Even have a crontab dcl script that works much like unix cron (well
almost :)). I have 1 dcl script for all
Do this:
$define/system sys$error nla0:
and everything will be working fine. Those pesky error messages will be
gone. Just kidding. There is, however an open source project called
FreeVMS
which wants to do exactly that: to create a free version of OpenVMS for PCs,
much like Linux. The home
1 - 100 of 165 matches
Mail list logo
