Title: Message
I've
gone to using the thin driver exclusively, as (counter-intuitively, I know) it
performs better than the OCI driver. Plus it's easier to
port...
-Original Message-From: Rick Stephenson
[mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 7:29
AMTo:
Title: RE: DBLink to SQL Server problem
Surround your column and table names with double-quotes (select mpp_id from...). I suspect that your SQL Server table was specified with lower-case columns.
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent:
Title: RE: Oh Dear, Mr. Ellison's at it again
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 02, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Oh Dear, Mr. Ellison's at it again
Ellison: Linux Will Wipe Microsoft
Title: Message
OLTP =
Normalize
OLAP/DSS = DeNormalize
End of
discussion. We figured this out what, 10 years ago?
-Original Message-From: Stephane
Paquette [mailto:[EMAIL PROTECTED] Sent: Tuesday,
March 25, 2003 7:24 AMTo: Multiple recipients of list
ORACLE-LSubject:
Dinosaurs or What?
It
is often not so cut and dried. There are degrees of normalization and
hybrid databases. Wish it was that easy. I think you
oversimplified the matter and honestly that doesn't help the data modeling
efforts.
Oracle OCP DBA
-Original Message-Fr
Title: RE: 9000x faster than Oracle?
This kind of design has already been implemented in a number of apps I've worked on; in fact, CMP EJB's sorta work the same way.
However, the comment optionally saving the whole system to disk every now and then (late at night, for example). hides one of
Title: Message
If the
ladies can't find you handsome, at least let them find you
handy!
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:54
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
RE: Value of OCP
Red Green,
Title: RE: ERWIN vs Designer
Assuming you can't just use the Access Relationships editor to do this (if all you're doing is drawing the diagrams, I'd use the diagram that's already there), ERWin has a much easier learning curve. It's bloated, but it works.
-Original Message-
From:
Title: RE: Server Recommendations
From: Tom Schruefer [mailto:[EMAIL PROTECTED]]
I have a question, I have to make a decision on the purchase
of a new web server for a multiteir Oracle based system. So
here are my two remaining options, all other things remaining
equal, on a
Title: RE: Sequence as column default
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Alan - You are correct. However, apparently that isn't easy
to do with J2EE / EJB, hense the trigger. Don't ask me why.
When will they come out with a book titled:
J2EE for the DBA
Dennis,
Title: Message
Does
the freeware version have the debugger now??!!!
If so,
highly cool. Going to check right now.
Hmmm,
no freeware TOAD version explicitly offered on website. Can download "trial"
version of "Xpert Edition" (gotta love marketing and their liberal misuse of
english)...
Title: RE: Is there any user group forum for SQL Server?
From: Jared Still [mailto:[EMAIL PROTECTED]]
A group like this one?
Not likely. :)
Jraed
Given that you've misspelt yer own name, I'd not be too uppity ;-)
- Jerremy
Title: RE: Sharing data between sessions
From: Chuck Hamilton [mailto:[EMAIL PROTECTED]]
One of my developers wants to share data between sessions
inside a package. Specifically he wants to set some sort of
global variable in a package that session 1 executes, and
when sessions
Title: RE: Purely for your amusement
Heh. 6 tables, 2 where statements, one of which is an outer. Gotta love it.
I'm thinking of building a tool that intercepts dumb SQL and emails back a raspberry. Whaddya think, is there a market for such a utility?
-Original Message-
From:
Title: RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Quoting [EMAIL PROTECTED]:
Lyndon,
I take it from your reply that 1) your not the primary DBA and
I work with Oracle and PostGreSQL, but not as a DBA. I'm a
Title: RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Quoting DENNIS WILLIAMS [EMAIL PROTECTED]:
Lyndon
To me, being a DBA is more an attitude than an HR
position. Study
what DBAs do and that will carry you forward.
I
Title: Message
Man,
what a buzz-kill you are.
-Original Message-From: Ed Bittel
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003
6:53 AMTo: Multiple recipients of list ORACLE-LSubject:
Size of a Long Field
How do you determine the size, in
bytes, of
Title: RE: Oracle License for Training
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Maria - Actually, I would think the best time to contact
Oracle sales is when you don't have money. Good sales people
can smell money. ;-)
Heh.
Some software companies are very liberal
Title: RE: Export / Import
exp -help
-Original Message-
From: Scott Stefick [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Export / Import
Hello,
OS Version: HP-UX 11i
DB Version: Oracle 8.1.7.4 and
Title: RE: Re[4]: undo tablespace
I think it might be a typo, or I've not had enuf coffee yet today, but the nologging on b.table2 wouldn't impact the redo logging; nologging on a.table1 would, tho...
-Original Message-
From: Breno A. K. Magnago [mailto:[EMAIL PROTECTED]]
Sent:
Title: Getting started with OLAP/multi-dimensional databases
I'm more and more getting involved with OLAP projects, and I have to admit I'm not at all familiar with such things as star schemas, clustered tables, reporting cubes, and the like. Since I'd like to rectify this situation, and
Title: Message
In
many cases, if you create a CSV file (comma-delimited) Excel will execute and
read it properly. Excel generally sets itself as the default editor for .csv
files.
I
don't know of any way to do this for Access.
-Original Message-From: Boivin, Patrice
J
Title: Message
Nobody
can. As with just about anything, it will depend on what size the app will be,
what the access pattern will be, and how available it has to
be.
-Original Message-From: Amos KABORE
[mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 9:04
AMTo:
Title: RE: simple question on DDL
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: simple question on DDL
Actually, DB2 (pardon my French) doesn't issue a commit
after a DDL. I'm not
Title: RE: over-normalized?
From: Saira Somani [mailto:[EMAIL PROTECTED]]
Is there such thing as an over-normalized database design?
Sure. But usually that would be in the case of doing olap-type reporting in a transactional app.
What defines over-normalization? And what are its
Title: RE: SqlServer and Oracle on the Same NT Box
Of course.
I've ran a few development boxes that had SQL Server, Oracle in 2 versions, and DB2 all installed on them. I wouldn't run them all, mind you, but running a single Oracle instance along with a SQL Server database isn't all that
Title: Freeware tool to browse data in Oracle tables?
TOAD
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21,
2003 12:04 AMTo: Multiple recipients of list
ORACLE-LSubject: Freeware tool to browse data in Oracle
tables?
Hi!
Title: RE: To Anyone involved in Web apps
From: Regina Harter [mailto:[EMAIL PROTECTED]]
Hi
I have a question for any of you involved in Web
applications. I would
like to know how many of you go for the single Oracle user
for everyone
approach,
Define everyone. Everyone
Title: RE: Date data type
Because in the second select, you are using the wrong mask. Try 'mmyy'.
-Original Message-
From: Sony kristanto [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 8:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Date data type
Hi
Title: Message
Revoke
the create table privileges.
-Original Message-From: Webber Valerie H
[mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003
11:50 AMTo: Multiple recipients of list ORACLE-LSubject:
Protecting schema changes
In a n-tier system that connects
Title: RE: STRANGE
Probably because it would take only minimal effort on your part to FIND OUT YOURSELF.
-Original Message-
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: STRANGE
Title: Message
I
don't like feeding an OT too much, but...
People
wonder why I am completely self-taught. I wonder where they were taught, because
the time I spent in primary and secondary school was a complete and utter waste
of time. It wasn't until I took a few classes of "higher"
Title: RE: PL/SQL Date Format
Not good, Jared. Try this:
SQL select df1('01-JAN-03') from dual;
DF1('01-J
-
03-JAN-01
Oops! I don't know how you could do this other than to parse the string like you did and look for invalid_num exceptions. Or force the app software to handle the
Title: Message
Tehe, don't worry, Bob, the
developers here work for me, so I can be as un-diplomatic as I wanna be.
I don't know how you would do it in
Micro$oft; perhaps some kind of component (.NET? DCOM?) could do this for them.
I can do it in Java and Perl. Can't
imagine that
Title: RE: Row Migration
Gaaa!! Neither did I!!!
(I've been looking for a better way to do that query for years...)
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 6:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:
Title: RE: PMON seems to not close sessions in a timely manner eg Max processes(50) reached
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like
Title: RE: Java to Database Basics
From: Alex [mailto:[EMAIL PROTECTED]]
First do you know how to program? Really program; not talk
about how to
program but actually type in code and get what you want.
If you do then learning 85% of java or any language won't
take too long.
I
Title: RE: Object relational features and performance
From: Stephane Paquette [mailto:[EMAIL PROTECTED]]
Is this the future ???
I know one big bank where the development is object
oriented and the database (DB2 UDB in this case) is
used as a big flat file. The development is using
Title: Cardinality of indexed columns... how to discover? What is the magic number?
I'm constantly finding, in the database that I'm developing/supporting, b-tree indexes on columns with low-cardinality. I generally re-create said index as a bitmap; however I'd like to go through the entire
Title: RE: Cardinality of indexed columns... how to discover? What is the ma
From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
The answer to the question you asked is to
check the dba_indexes view for columns
distinct_keys and num_rows.
Jeeez, guess I hadn't looked hard enough. Thx...
Title: How do I find Oracle's product roadmap?
I'm back in a development house that is focused on Oracle development, along with J2EE and various other strains. I've become (by default) the resident guru for PL/SQL development and technical implementation support for our professional services
Title: RE: How do I find Oracle's product roadmap?
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Jeremy - In his OpenWorld Guru session I believe Ken Jacobs
debunked this
myth
http://www.oracle.com/oracleworld/online/sanfrancisco/index.ht
ml?chats.html
Title: RE: Methods to get DDL
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
Im wondering what methods people are using?
I'd like a quick way to get the ddl for say... One index
TOAD
listen up: For better April 1'st - add another
record to dual. That is known to cause a deteriorating effect on
developers.
:-)
Yechiel AdarMehish
- Original Message -
From:
Jeremy Pulcifer
To: Multiple
recipients of list ORACLE-L
Sent: Monday
Title: RE: db block Size for Indexes Tablespaces in 9.2 ?
Can you specify db_block_sizes at the tablespace level in 9?
*blink*
-Original Message-
From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 8:29 AM
To: Multiple recipients of list ORACLE-L
.Net
is not an OS. The developer (here it comes) doesn't know what he's talking
about.
-Original Message-From: Barbara Baker
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 17, 2002
3:34 PMTo: Multiple recipients of list ORACLE-LSubject:
Oracle Application Server on .net
Title: RE: DUAL
Careful. We are listening.
;-)
(that woulda messed me up for a while)
-Original Message-
From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DUAL
Thanks
Title: RE: Oracle 8i (8.1.7) for Windows XP Home Edition
Didn't try 8.1.7, but 9i went in just fine.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 3:54 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle 8i (8.1.7)
Title: RE: ORA-600 error(solution for all of them).
So, Joe, are you pointless for a reason, or is there a joke I'm not aware of.
-Original Message-
From: JOE TESTA [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 7:29 AM
To: Multiple recipients of list ORACLE-L
Subject:
Title: Active sessions chewing up a huge amount of RAM
I have a customer that is reporting that each of the connections our Weblogic appserver uses is using something on the order of 100+MB of RAM on the db server, ostentatiously the Snnn processes are frickin' HUGE. I've never seen that kind
Title: RE: Active sessions chewing up a huge amount of RAM
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
How big is the SGA?
Dunno specifics, but it's on the order of a gig.
On Unix at least, each DB process
appears to be taking
a huge chunk'o'virtual memory (as seen from Glance
Title: RE: Active sessions chewing up a huge amount of RAM
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Jeremy - How many connections is Weblogic creating?
20-30 per appserver. 4 appservers.
Are you using Oracle MTS?
No. At least they're not supposed to be.
I'm also
Title: RE: RE: a PL/SQL design question.
I'd like to add a point here as well...
Because DBMS_JOBS are asynch, ie not transaction bound and not read-consistent, by design they should not be allowed to be fired from triggers or other event-driven mechanisms _if_ they are to accomplish some
Title: RE: Oracle FM interpretation of locking behavior
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
my ribs are still tender from repeated reverse peristalsis.
Remember the good ol' days when we just called barf spew?
Title: RE: Increase size of data files and rollback segments
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Alright guys, just because you know Jeremiah better than me
so you can take
his joke.
I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you
Title: RE: a PL/SQL design question.
An easy way to do this is using DBMS_JOB. That way you can get asynchronous execution, and it isn't tied to the transaction.
This is clipped from a fix I just did for a customer. It ain't complete, but hopefully you can follow the logic:
Title: RE: List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema
SELECT table_name,column_name
FROM user_tab_columns
WHERE nullable = 'N';
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 1:55 PM
To: Multiple
Title: RE: sys login -probably a dumb question
Any chance that instance 2 is 9i, and instance 1 isn't?
-Original Message-
From: John Shaw [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
Subject: sys login -probably a
Title: RE: Import Table from Full Backup
From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]]
I'd agree that you can achieve the same result. I think I'd
argue that it's
not a feature of RMAN though.
I can also take that restored table, spool it a text file and
edit it using
Title: RE: Are Oracle courses required for Oracle Certification now?
From: Kieran Murray [mailto:[EMAIL PROTECTED]]
Hey people!
A friend of mine was just asking me about getting Oracle certified (I
completed the Oracle 8i cerfication exams last year),
he told me that to his
Title: RE: Export from Oracle 8 to Oracle 7
Just use an Oracle7 client to do the exp
-Original Message-
From: Bartolo, David [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Export from Oracle 8 to Oracle 7
The
answer to your problem: The Red Button. You're welcome!
-Original Message-From: Tinu !@#!^%
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 3:29
AMTo: Multiple recipients of list ORACLE-LSubject:
HELP
-From: Jeremy Pulcifer
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 02,
2002 15:54To: Multiple recipients of list
ORACLE-LSubject: 9i database create script - My, how things have
changed
...since 8.1.7. I've always ran the database creation
utility, then swiped
Title: RE: ORA-1653: unable to extend table - Why?
It just depends on what your definition of it is...
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1653:
Title: 9i database create script - My, how things have changed
...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the
65 matches
Mail list logo