Title: RE: char vs. varchar in a data warehouse
Makes no sense at all. The 'developers' don't want to deal with the space when manipulating that value? If it ain't there, they do nothing.
All of the space management will be up to you, not the developers.
Jon
-Original Message-
Title: RE: MySQL versus Oracle
Also depends what you are doing. The first person to do a read causes a TABLE LOCK. No row level locking. MySQL way to assure the data you see back is what it really is.
But MySQL does have one nifty little feature, you can load tables into memory exclusively.
Title: RE: MySQL versus Oracle
MySQL is ANSI 88 compliant, so they claim. As far as ANSI 92, they mislead by saying they Follow ANSI SQL 92 requirements
Jon
-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 6:14 PM
To: Multiple recipients
Title: RE: Brainbench Oracle certifications
About the only value for it is a non-IT recruiter to see if you at least know how to spell Oracle.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 6:09 PM
To: Multiple recipients of
Reply Separator
Author: Jon Baker [EMAIL PROTECTED]
Date: 4/2/2002 8:03 AM
I believe as long as it is only stand-by, no additional licensing
required.
Only one system is functional at a time.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Title: RE: License standby database?
I believe as long as it is only stand-by, no additional licensing required. Only one system is functional at a time.
Jon
[EMAIL PROTECTED]
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:28
Title: RE: Oracle Hungry for Money
separate option.
you can choose not to install it from OUI.
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Hungry for Money
http://nscpcw.physics.upenn.edu/db2_docs/
could be useful. i'm still trying to get a free trial copy of db2...
-Original Message-
Sent: Thursday, March 07, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
Hi there,
Does anybody know if there's a list such as this
Title: RE: Oracle Hungry for Money
You're supposed to take the Clinton approach. DENY, DENY, DENY
And always remember, it's not illegal until you get caught.
Jon
[EMAIL PROTECTED]
-Original Message-
From: Scott Canaan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March
Title: RE: Oracle Hungry for Money
No, not included. But need Enterprise Edition to get Partitioning.
Jon
[EMAIL PROTECTED]
-Original Message-
From: James Howerton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 3:12 PM
To: Multiple recipients of list ORACLE-L
Subject:
Title: RE: Oracle Hungry for Money
Actually, if you are found using items during audit, I believe you pay for the licensing and then pay another fee of 200% costs for illegal usage.
In other words, cost something like 3 times normal if found during audit.
jon
[EMAIL PROTECTED]
Title: Message
http://nscpcw.physics.upenn.edu/db2_docs/
could
be useful. i'm still trying to get a free trial copy of
db2...
-Original Message-From: Cunningham, Gerald
[mailto:[EMAIL PROTECTED]]Sent: Thursday, March 07, 2002
4:14 PMTo: Multiple recipients of list
Title: RE: How's the job market?
for database admin types, it's pretty good. i think it is either second or third on the top five hottest IT jobs. security engineers are tops for those that can break in and lock down systems.
-Original Message-
From: Smith, Ron L. [mailto:[EMAIL
Title: RE: How's the job market?
yea, you are right, it still depends on location, location, location.
-Original Message-
From: bill thater [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: How's the job market?
Title: RE: Clash of the DBs in eWeek
I agree. I've been following MySQL for a while and it does have it's place, but would not want a data warehouse on it.
http://www.eweek.com/article/0,3658,s=708=18266,00.asp
Another article on MySQL from same source.
Jon
-Original
' versions of MySQL.
Jon Baker
Database Architect
[EMAIL PROTECTED]
www.netsec.net
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 3:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Tangetially ON Topic... ANSI SQL and Reusing
FULL Export dump. I guess you can then
do a FULL Import and get the captured hash. But why do you need it now
that you have the FULL Database with you anyway ?
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
Jon Baker [EMAIL PROTECTED] 22/02/2002 02:08 PM
Sent
work on the new machine.
A non Oracle example would be to perform the following at the unix prompt:
echo 'some test string' | md5
With the hash, you could create several variations and test against the known or 'captured' hash. Again, brute force method.
Jon Baker
Database Architect
[EMAIL
Title: RE: Oracle Licensing - Concurrent users
I too went through this mess (twice). A CPU license gets you unlimited. If it's on the web, they don't like the idea of using an application server that utilizes one connection with internal login/logout capability/security. Why twice? Second
Title: RE: whitespaces
use the rtrim function.
rtrim(char[,set]) - char, with final characters removed after the last character not in set. set defaults to ' '.
i.e.:
update table set field=rtrim(field);
Jon Baker
Database Architect
[EMAIL PROTECTED]
www.netsec.net
Title: User Forums for MS SQL Server
http://www.openitx.com/
they
have several small db mail lists. light traffic for an email
list.
Jon Baker
Database Architect [EMAIL PROTECTED] www.netsec.net
-Original Message-From: Ari, Rama
[mailto:[EMAIL PROTECTED]]Sent: Wednesday
to ignore. Glad to hear I am not the only one.
Jon Baker
-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 2:50 PM
To: Multiple recipients of list ORACLE-L
Subject: is it f*ing f*day yet? / ORACLE-L Digest -- Volume 2002, Number
032
Title: RE: RE: Linux taking over at Oracle
I think you can figure just from the text that this was a hoax. red hat acquiring microsoft? now that would take some serious capitalization.
Jon Baker
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Friday, February
and understanding of how the database interacts or is utilized by the application (whether it be COTS or a local beast).
The DBA has more responsibility, usually more experience (this usually translates into higher pay as well) than Apps DBA.
Jon Baker
Database Architect
[EMAIL PROTECTED
Title: RE: mystery cartesian join
are the joins themselves correct?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:21 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: mystery cartesian join
It's impossible to
database like MySQL or PostgreSQL would do here.
Perhpas for job portability learning SQL Server or DB2 would be good.
Jon Baker
Database Architect
[EMAIL PROTECTED]
www.netsec.net
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002
Title: RE: Firing order of triggers
can you combine the code of all three into one trigger?
you can then easily programmatically determine what gets done in what order.
-Original Message-
From: Browett, Darren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 27, 2001 4:25 PM
Title: RE: Win XP
Oracle claims that they will only support Oracle 9i Lite on Windows XP. They will produce a client as well. Due sometime soon, I believe November.
How the OS is built, however, should allow you to install and run. And I am sure Oracle will eventually bend and pick up
Try
this url for a start:
www.datamodel.org
I
believe they have the methods of building and then the steps to
normalize.
At
least it's a start.
Jon
-Original Message-From: Saravana Kumar
[mailto:[EMAIL PROTECTED]]Sent: Monday,
October 29, 2001 4:20 AMTo: Multiple
Title: RE: Win XP
yea, sun should not develop solstice or java. ;-)
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Win XP
I have not seen win2K yet!
It's amazing
Title: interesting floating point problem with oracle
I got
a big fat 1 from 8.1.7.
Guess
I'll check the doc for affected version.
-Original Message-From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 25, 2001
11:35 AMTo: Multiple
Title: RE: Visio for ERD's ?
It ain't fun. Can only used for graphical representation. I guess better than using pen and paper.
-Original Message-
From: Ken Janusz [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Title: RE: STOP THE PRESS!!
Hm, yet terrorism is a global issue just as WWII was. Many countries have been hit by these bastards. Hit and run attempts to knock out capabilities. Several innocent lives lost, even before yesterday.
I'll get back to fixing Oracle issues after I apply some
Title: RE: Interesting News..
That's HP-OpenVMS to you, buddy!!! ;-)
I miss VMS. Ah, the days.
Jon
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:
Title: RE: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY
yep. is the list selling our email's to ease the financial woes? ;-)
-Original Message-
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:16 PM
To: Multiple recipients of list
Title: RE: MySQL anyone?
Attached is a note from another list member, Guy Hammond.
I agree with most of what Guy says, except that MySqueel does have master-slave replication (though slave cannot be a writeable slave). And I'd add no point-in-time recovery, no incremental backup capability,
Title: awk, sed, windoze, sql*loader, other fun stuff
try
perl.
www.activestate.com
www.cpan.org
www.perl.com
it's
free and easy to load.
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29, 2001
2:27 PMTo: Multiple recipients of list
FreeBSD and OpenBSD are not supported by Oracle.
-Original Message-From:
Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent:
Monday, August 20, 2001 10:46 AMTo: Multiple recipients of list
ORACLE-LSubject: linux
Hi Friends,
I have small clarification to be made.
Title: RAID or NOT to RAID? What's the diff???
one is
mirrored stripes while the other is stripped mirrors.
;-)
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 13, 2001
12:06 PMTo: Multiple recipients of list ORACLE-LSubject:
RAID or
Title: RE: computer history stories - Now: Age discrimination?
okay fellow geezershaven't you adopted the I'm only 29 phrase yet?
It also gets you alot of 30th birthday parties where you can continue to claim 29, just have to change jobs alot.
Jon
-Original Message-
From:
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
-Okay, who remembers Fractured Fairy Tales and the Professor and his
-boy Sherman?
On black and white TV!! :(
and was the screen round and did the tv have legs built
Title: RE: Oracle vs. MySQL
- provides master-slave replication only. only 1 master, but i think up to 1000 slaves.
- uses only one port for transactions, so you can easily flood that port if you have large emounts of data
- no referencial integrity. that all has to be built into your
Title: RE: import table from SQL server To Oracle
Try looking at Oracle Migration Workbench
No cost. Can download from OTN.
-Original Message-
From: Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L
Subject:
Title: RE: Largest Oracle Databases
In theory, Oracle can handle 512 Picobytes (or roughly 512,000 Terabytes) for Oracle 8i.
Have not heard if this has been increased for 9i.
-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:00
: Largest Oracle Databases
"picobytes"? lol.
Attoboy!
-Original Message-----From: Jon Baker
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 31, 2001 10:56
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Largest Oracle Databases
In theory, Oracle
Title: RE: Update ALL colums without knowing their name??
Are you just trying to totally refresh table1 from table 2?
how about:
1. TRUNCATE table1;
2. INSERT INTO table1 SELECT * FROM table2;
(assuming structures of the two tables are compatible)
Or am I just totally missing the
Title: RE: [Q] which desugner tool better?
oracle designer over embarcadero any day. cheaper and more robust, with additional useful products (they are all bundled into the Internet Developer Suite). and it is not tied to the nic card for licensing.
i've heard cases supporting both sides in
Title: RE: Sizing a new server - the Alpha Chip
Only
the support issue would bother me. From two standpoints: 1) Compaq and 2)
Oracle.
Compaq
has made many promises with it's Digital acquisition, but has not really lived
up to them. TheOpenVMS developmentand alpha development has
greatly
Title: RE: Rename alert log
same here.
jon
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rename alert log
I am running 8.1.7 and just last week renamed my
Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: jon baker
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
on this. But if you found it on the
web, it must be okay =)
Jon Baker
Database Engineer (1/5)
[EMAIL PROTECTED]
www.netsec.net
-
Jonathan Gennick wrote:
I'd like to follow up on this, because I wrote
help works for sqlplus, if you installed, but if there is a script for
building sql command structure, please pass that on. At least 'help
index' is only showing the sqlplus commands.
Jon Baker
Database Engineer (1/5)
[EMAIL PROTECTED]
www.netsec.net
contents is
prohibited. If you have received this transmission in error,
please notify us immediately by telephone at (703) 561-0420,
or by electronic mail at [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: jon baker
INET: [EMAIL PROTECTED]
Fat City
http://www.uk.research.att.com/vnc/
is up and running for me.
Jon Baker
Database Engineer (1/5)
[EMAIL PROTECTED]
www.netsec.net
[EMAIL PROTECTED] wrote:
Does anyine have a current link to the VNC binaries for AIX
54 matches
Mail list logo