Re: ***Urgent Question***

2001-02-01 Thread Bunyamin K.Karadeniz
My group leader tells that rownum may give wrong results . Do not use it... Really ??? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 31, 2001 3:00 PM try this: select * from (select emid, deptid from dept order by deptid

RE: when did that happen ... (really like to know)

2001-02-01 Thread Suhen Pather
Leslie, Try looking at dba_objects/user_objects, there is a column called created Suhen Hi, Is there a way to find out when was a database created and also when was an individual object in a database created? Thanks in advance. Leslie __

RE: sql query

2001-02-01 Thread Suhen Pather
Ravindra, Try this query select a.id,a.value from test1 a,test2 b where a.id=b.a_id and a.value=b.value / Suhen Hi, I am having problem in writing a query.May be this is a elementary Q but I need help Table 1: id value -- -- a 3 b 3 c 3 d 3 e 3

RE: newbie: problem in dynamic SQL

2001-02-01 Thread paquette stephane
Hi, One of the reason I'm saying that is that I just tuned a batch job where in a huge loop there was a create and a drop table . Performance was awful. I'm more a development dba than a production dba so I'm usually aware of all objects in the database. The main thing is that "usually" the

newbie: thanks

2001-02-01 Thread anurag dewan
hi, thank u everybody for helping me out. And thanks for not shooting me. -anurag Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie --

Réf. : Re: asyn i/o on sun or hp

2001-02-01 Thread Sofiane-Ennaifar
Hello, I am intereseted in having more information about ASYN I/O : What is ASYN I/O ? Advanteges ? Desadvanteges ?... When it is good to activate ASYN I/O . NT/W2k ASYN I/O ? Thanks Sofiane

imp full=y indexfile=filename does not produce create tablespace ....

2001-02-01 Thread Cale, Rick T (Richard)
Hi All, Oracle 8.1.6 NT 4.0 Someone gave me a full export to do an import on test system. I wanted to create the tablespaces first so I did imp user/password file=file.dmp full=y indexfile=file.sql However, this does not produce any create tablespace ... commands. I thought all create

RE: Réf. : Re: asyn i/o on sun or hp

2001-02-01 Thread Mark Leith
Asynch I/O on a Windowze box? supresses a snigger... To the best of my knowledge there are no Windows based system that can take advantage of this, single thread management can be enough a problem sometimes.. But, I may be wrong.. List? -Original Message- [EMAIL PROTECTED] Sent:

RE: POINTLESSLY, SICKENINGLY OFF TOPIC

2001-02-01 Thread Jamadagni, Rajendra
Mohan, For my HTS, I chose Mirage (over Klipsch, which was costly for same quality) AVS100/200 and a FRX-8 powered sub. Small enough size of Bose speakers, sound is huge ... quality is astounding ... for me it gave me the most bang for the $$ I paid. This is connected to Sony STR-AV333ES (which

RE: New Dynamic Views - GV$ ???

2001-02-01 Thread Mark Leith
Chandini Straight from the 8I Refernce guide page 346 - I couldn't explain it better myself :) Well done Oracle.. --Snip-- GV$ Views For almost every V$ view described in this chapter, Oracle has a corresponding GV$ (global V$) view. In a parallel server environment, querying a GV$ view

controlfile schema global enqueue lock

2001-02-01 Thread Joan Hsieh
Dear Listers, Our database in London has tremendous cf enque lock. Since I am new here. I checked the parameter found the log_checkpoint_interval set to 3200 and log_checkpoint_timeout set to default (1800 sec). So I suggest to set log_checkpoint_interval to 1 and log_checkpoint_timeout

Q: values in V$SGA

2001-02-01 Thread Schoen Volker
Hi list, I think this is a easy question, but I'm not sure if I'm right: 1. What is "Variable Size" in view V$SGA, SUM(large_pool_size+java_poolsize+shared_pool_size)? 2. What is Fixed Size in view V$SGA? TIA Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the

RE: ***Problem***

2001-02-01 Thread Mark Leith
In this case, the rownum should not be a problem when using it in a sub select? You are only trying to get the first seven rows from the sub select.. Whats the problem? Fair enough, using a rownum on a single select may not be reliable, but in this case it should work like a charm..

Inserting into Long

2001-02-01 Thread Gary Chauhan
Hi, I am loading data into Oracle table using a perl program. Table structure is ( Col1 Varchar2, Col2 Long ); What r the different ways to insert into Long field? I have a string of length more than 4000 characters. When I am using insert

New Dynamic Views - GV$ ???

2001-02-01 Thread Chandini Paterson
Hi, I was just looking at the data dictionary (dict table) and came upon a whole list of views that have similar names to the dynamic views (V$), but all start with GV$. EG:- GV$DLM_LOCKS GV$LOCK etc. There almost seems to be one GV$ view for each V$ view. Would somebody tell me

RE: Réf. : Re: asyn i/o on sun or hp

2001-02-01 Thread Trassens, Christian
I've been testing quite a lot about it. First you need to know that the configuration is different in each platform. And some of them don't support async. F.e., in AIX you set two kernel parameters and init.ora parameter, in Hp-Ux you need to create the device, change a kernel

RE: New Dynamic Views - GV$ ???

2001-02-01 Thread Chandini Paterson
Right, I'll go hide somewhere now. I did look at the Reference guide and never found it:-((. (Sassen, frassen, rassen, mutter, mutter). Anyway thanks a zillion, guys. And sorry for the trouble. Chandini Paterson -Original Message- Sent: 01 February 2001 13:20 To: Multiple recipients

OT RE: METABLINK on the Fritz?

2001-02-01 Thread Mohan, Ross
Title: METABLINK on the Fritz? "DUH" Distributed Uniform Hardware. Let's get the marketing boys on it, right away! -Original Message-From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 31, 2001 4:56 PMTo: Multiple recipients of list ORACLE-LSubject:

COPY command dieing - help

2001-02-01 Thread Shaw, John B
I am attempting to copy a table from a 8.1.6 db to 8.1.7. Most of the tables have come across successfully. One table is having a problem. The command: copy from v55/v55@int to user/pwd@frog create DMF using select * from DMF@int; This table gives ora-00911 error (invalid character ? where?

Re[2]: People Soft dba info

2001-02-01 Thread dgoulet
Mike, Does PeopleSoft have database training, Yes. Will it help you with Oracle, NO WAY IN HELL!. PeopleSoft uses Sql*Server in their development training. They also don't do anything outside of the PeopleTools suite. Therefore, for database sizing, performance tuning, backup recovery,

RE: RE: controlfile schema global enqueue lock

2001-02-01 Thread Joan Hsieh
Dick, The system is not in archivelog mode. If the database crashed, I was told they don't care at all. They just rebuilt a shell database and let getter and feeder processes gradually feed the database. (The getter will check the url in the database, if didn't find then will go to the origin

CUBES

2001-02-01 Thread SRAJENDRAN
Hi, Could someone please give me an example for cube. I could understand rollup using the following example. SELECT deptno, job, SUM(sal) FROM emp group by rollup(deptno, job) / Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

RE: Unix script question

2001-02-01 Thread Glenn Travis
check the man page; $ man test -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Roy Ferguson Sent: Wednesday, January 31, 2001 2:48 PM To: Multiple recipients of list ORACLE-L Subject: Unix script question I am looking to resolve an issue we have

RE: controlfile schema global enqueue lock

2001-02-01 Thread Joan Hsieh
Dick, The database size is 200Gb (datafiles), not including the redolog. This is a internet content delivery company. The database structure is very simple. Some processes called getter continually insert the http site to the database. Other processes keep check the url is expired or not. Based

Re: Re[2]: People Soft dba info

2001-02-01 Thread Jeffrey Beckstrom
I have been supporting Peoplesoft for 5 years now. Like Dick says, it is NOT written for Oracle and does not use constraints, packages, etc. It has its own data dictionary which it uses when altering tables. I wrote SQL to repopulate the Peoplesoft dictionary with sizing from the catalog.

OT RE: Réf. : Re: asyn i/o on sun or

2001-02-01 Thread Mohan, Ross
Title: RE: Réf. : Re: asyn i/o on sun or hp "...Standing, corrected, and sniggering." Odd picture, that.. Anyways, pop quiz: On what OS kernel technology is NT based? Who was the original designer and what was his/her first OS? ---Original Message-From: Mark Leith

Re:RE: controlfile schema global enqueue lock

2001-02-01 Thread dgoulet
Joan, HUMMM! Lots to think about here. For one, if your not doing any backups what is the plan for when a disk drive fails? Predicting that is similar to predicting the next asteroid impact on the earth, it's not a matter of if, but when. After that drive gets replaced, something has

Re: OT_RE:_Réf._:_Re:_asyn_i/o_on_sun_or_

2001-02-01 Thread paquette stephane
NT is based on VMS (talk about a real OS) and if my memory is good the guy's name is Cutter. Do I win a toaster ? a microwave oven ? a palm-pilot ? --- "Mohan, Ross" [EMAIL PROTECTED] a crit: "...Standing, corrected, and sniggering." Odd picture, that.. Anyways, pop quiz:

RE: RE: controlfile schema global enqueue lock

2001-02-01 Thread Joan Hsieh
Oh, some more info. We have 2 control file, all the disk just have 1 datafile. The company spend a lot money invested on this. All the redolog on separated disk too. all raw disk and mirrored. I want to know what I can do to reduce control file lock? Joan -Original Message- Sent:

RE: imp full=y indexfile=filename does not produce create

2001-02-01 Thread exu
I think that if indexfile is included in the import command, no database objects will be imported. This parameter is only used to create to index-creation commands, so you can edit the file (ex: change storage parameters or tablespace) to create the indexes. Eveleen Please respond to

Re: PL/SQL syntax

2001-02-01 Thread Bill Pribyl
There is also, of course, a chapter of Oracle's PL/SQL manual that has "railroad diagrams" for each statement, but I figure you already know about that: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/11_elems.htm#1407 Bill --

Oracle shareware web site.

2001-02-01 Thread Ron Cetnar
I'm looking for the web site that has a export utility called something like TAB/EXT. Does anyone know the URL for this site? TIA, Ron *** Ron Cetnar Supervising Programmer/Analyst/DBA State University of New York at Albany

Netapp

2001-02-01 Thread hp
Hi everyone I was hoping i could get some dvice from anyont that might have a netapp We are currently evaluating a Netapp F740 and trying to determine if it is faster than the current hardware we have , which is 3 12H Hp autoraid I was wondering if anyone could give me any advice on performance

Réf. : Re: temp tablespace

2001-02-01 Thread Sofiane-Ennaifar
Hi, What is the PCT increase for your Temp TBS. If PCT increase is 0, try to alter it to 1% for instance (temp segments will be dropped) then go to 0% Sof

Queries over DB Links

2001-02-01 Thread Bill Becker
Hello, We seem to have more and more questions regarding query performance across DB Links, and how to improve it. I have the Gurry/Corrigan book, but can't find anything on this specific topic. Can anyone point me to a good whitepaper or other article regarding query performance across DB

RE: Réf. : Re: asyn i/o on sun or hp

2001-02-01 Thread Gogala, Mladen
Async IO is good 'cause you may start more then one IO request simultaneously, which means that you don't have to wait for them. The IO requests will inform the invoking process by sending a signal (typically, SIGIO) when it's done. Read man pages for aio_read and aio_write. As for the NT/Win

Re: Inserting into Long

2001-02-01 Thread jkstill
Please use 'perldoc DBD::Oracle' from the command line. This documentation will tell you how to deal with longs. Jared On Thu, 1 Feb 2001, Gary Chauhan wrote: Hi, I am loading data into Oracle table using a perl program. Table structure is ( Col1 Varchar2,

RE: OT ? for people who know other databases besides Oracle

2001-02-01 Thread jkstill
On Wed, 31 Jan 2001, Seley, Linda wrote: OK. So we want to avoid procedures, functions, triggers, etc. unless we want to build some sort of wrapper. What about long datatypes, blobs, clobs, outer joins, distincts, using nextval to grab sequences, etc. Does anyone know where I can find

RE: PL/SQL syntax

2001-02-01 Thread Jacques Kilchoer
Title: RE: PL/SQL syntax -Original Message- From: Bill Pribyl [mailto:[EMAIL PROTECTED]] Sent: jeudi, 1. février 2001 09:26 I think one that stays near to the language syntax without a lot of pages is O'Reilly's Oracle PL/SQL Pocket Reference. I have that sitting on my desk and

RE: OT NT2K vs Unix.

2001-02-01 Thread Kevin Kostyszyn
Title: OT NT2K vs Unix. That's a good point, but who really knows? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Thursday, February 01, 2001 1:27 PMTo: Multiple recipients of list ORACLE-LSubject: OT NT2K vs Unix. Yea,

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
:-) True enough. Ok, I'll restate like this Datacenter ( a copy of Unix, according to old style Unix'ers ) will decimate other brands of Unix in 5 years. -Original Message-From: Rocky Welch [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 2001 2:01 PMTo:

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Ruiz, Mary A (CAP, CDI)
Rick: In tnsnames.ora, is the entry listed as "satt.world" ? If so, then check the sqlnet.ora file, to see if there is a line names.default_domain = world Just a shot in the dark, Mary Ruiz / Atlanta GA -Original Message- Sent: Thursday, February 01, 2001 1:27 PM To: Multiple

Re: temp tablespace

2001-02-01 Thread Mohammad Rafiq
To resolve it now: alter tablespace temp coalesce; for all the time set pctincrease to 1 (if 0) of temp tablespace alter tablespace temp default storage(pctincrease 1); Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 01 Feb 2001

RE: Parallel Query Option

2001-02-01 Thread Scott . Shafer
http://www.oreilly.com/catalog/oraclepp/ Can't vouch for it, but it may be a good reference... From site: "These days, databases often grow to enormous sizes, straining the ability of single-processor or single computer systems to handle the load. More and more organizations

RE: OT RE: Réf. : Re: asyn i/o on sun or

2001-02-01 Thread Mark Leith
Title: RE: Réf. : Re: asyn i/o on sun or hp Wasn't it Dec VAX/VMS? Also, I noticed I contradicted myself, STANDING corrected, and SITTING sniggering.. Even more of an odd picture huh? Go on then - Who and what was it? Bet it wasJob "The Woz" or something with the Mac? -Original

Parallel Query Option

2001-02-01 Thread Holman, Rodney
Listers, I'm looking for documentation on the PQO. I have scanned through my Oracle Press books and some of the Online Documentation at MetaLink. What they offer is a piece here and a piece there interspersed in Parallel Server topics. I am NOT running OPS, but would like to implement PQ on a

RE: CUBES

2001-02-01 Thread Trivedi, Hitarth
Just try : SELECT deptno, job, SUM(sal) FROM emp group by cube(deptno, job) / and see the difference between rollup and cube! Cube basically adds one more dimension, it gives summary for each value in "job"

RE: Queries over DB Links

2001-02-01 Thread Toepke, Kevin M
Bill, Also, you don't want to join remote tables together. Create a join-view on the remote database instead. Kevin -Original Message- Sent: Thursday, February 01, 2001 1:10 PM To: Multiple recipients of list ORACLE-L Bill, Queries across DB links are pretty messy. Check

RE: CUBES

2001-02-01 Thread SRAJENDRAN
thanks -Original Message- Sent: Thursday, February 01, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Just try : SELECT deptno, job, SUM(sal) FROM emp group by cube(deptno, job) / and see the

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Title: OT NT2K vs Unix. I sure as hell don't, but I learn something every time a microflamesoft war starts, so, shrug what the heck! -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 2001 2:33 PMTo: Multiple recipients of list

RE: OT_RE:_Réf._:_Re:_asy

2001-02-01 Thread Yosi
Important addendum. For those of us that note these things, each letter of WNT is one letter up from the letters of VMS. (And, HAL, from 2001, A Space Oddysey, is one letter removed from IBM.) fwiw, Yosi -Original Message- From: Steve Orr [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: OT RE: Réf. : Re: asyn i/o on s

2001-02-01 Thread Mohan, Ross
Title: RE: Réf. : Re: asyn i/o on sun or hp David Cutler from VAX fame, armed with new ideas about "microkernel" OS architectures out of CM University, went to work on NT in late 89. ( So, it's only 11 years old. Wonder where it'll be when it's Unix' age30+). One other microkernel

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Cale, Rick T (Richard)
I want to connect using the @service_name -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-12514 TNS names could not resolve service name So you want to

RE: OT NT2K vs Unix.

2001-02-01 Thread Gogala, Mladen
There is, however, one significant difference: stability. If Microsoft starts making stable products, we might just as well start using them, but knowing Microsoft, I'm not overly worried. -Original Message- Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Gogala, Mladen
Try TWO_TASK on Unix, LOCAL on NT or ORA_DFLT_HOSTSTR on the NT predecessor. -Original Message- Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list ORACLE-L So you want to connect without the @string system/password as opposed to system/password@orcl?

6i

2001-02-01 Thread Kevin Kostyszyn
Hi All, Ok I am tired of looking for the answer myself.!! So, does anyone know if Oracle certifies Developer 6i for Windows 2k? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: OT NT2K vs Unix.

2001-02-01 Thread Eric D. Pierce
SHOCKING!!!: a huge software company with billions of dollars at its disposal might actually succeed in improving its products evry decade or so. innovative! :) On 1 Feb 2001, at 11:46, Mohan, Ross wrote: Date sent: Thu, 01 Feb 2001 11:46:31 -0800 To: Multiple

RE: Primary Keys

2001-02-01 Thread Tony Johnson
How are you going to retrieve the data in these tables for your application. A surrogate key as you are describing is valid in many instances if for no other reason that to make the model much cleaner. There are many occasions where the 'live-and-die' relational rules have to be bent to meet real

RE: temp tablespace

2001-02-01 Thread Joan Hsieh
or take temp offline and online again. Joan -Original Message- Rafiq Sent: Thursday, February 01, 2001 2:12 PM To: Multiple recipients of list ORACLE-L To resolve it now: alter tablespace temp coalesce; for all the time set pctincrease to 1 (if 0) of temp tablespace alter tablespace

RE: values in V$SGA

2001-02-01 Thread Joan Hsieh
If you have Steve Adam's book, on page 82 The fixed area of SGA contains several thousand atomic variables, small data structures such as latches and pointers into other areas of the SGA. These variables are all listed in the fixed table x$ksmfsv along with their data types, sizes, and memory

Re: Primary Keys

2001-02-01 Thread Don Jerman
When you say "no natural key" I assume you mean no data that is non-null and unique. How, then, do you propose to get single records, since you (probably) don't want to have to find them by the image data... Of course, if the table is write-only -- who cares? :-) Brian Wisniewski wrote: I

RE: OT NT2K vs Unix.

2001-02-01 Thread Gogala, Mladen
Well, IBM has predicted so called "paperless office" in 5 years in the year 1980. Paper manufacturers did not seem very concerned at the time and, boy, are they thriving these days! Don't get me wrong, I like Microsoft. In fact, I like Microsoft so much that I wish that there was more then

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Title: RE: OT NT2K vs Unix. Granted.just out of curiousity: Can you cite reliability statistics for the 10 year Unix? -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 3:01 PM To: Multiple recipients of list ORACLE-L

RE: Primary Keys

2001-02-01 Thread Brian Wisniewski
I don't know if my prior email made it out to the list or not. In 99% of the rows the Primary key will be a combination of 2 fields however they cannot be 100% sure this concatenated key will always be unique therefore the need for the surrogate key. From what I've gathered the PK will usually

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Reboots: Did you realize you DO have to reboot after some Solaris package installs? Maybe not "all" and maybe not "Solaris 8", but.certainly some of them with kernel hooks in 2.5. Crashes: Most of them due to poor third party driver authoring -- MS, a software company, gave too

RE: OT NT2K vs Unix.

2001-02-01 Thread Kevin Kostyszyn
Good points and don't worry about the sarcasm, at least you are honest about it. Sometimes I can't tell if people are being mean, or sarcastic. Anyway, back to the argument. What it would seem like to me is that because Microsoft is trying to improve their platform you are arguing that

RE: OT NT2K vs Unix.

2001-02-01 Thread Jesse, Rich
Horse Hockey (as you help point out)! You don't have to reboot if you use MS's builtin drivers for Tuke (aka Windows 2000, aka Win2K), which are crap. For example, the drivers for the NVidia TNT2 Riva video card. If you want to reinstall the OEM drivers, you need to reboot in order to get a

RE: OT_RE:_Réf._:_Re:_asy

2001-02-01 Thread Mohan, Ross
Title: RE: OT_RE:_Réf._:_Re:_asy OK, I make a REAL effort not to reply to The List on OTs, but this one crosses the line. || Brace yourself, this is important. The Giant has been aroused...er, roused.G NT is NOT, I repeat, *NOT* based on VMS, VAX/VMS, OpenVMS, or whatever anyone wants to

RE: OT NT2K vs Unix.

2001-02-01 Thread Adams, Matthew (GEA, 088130)
There is an excellent card game called SPIDER on many versions of solaris. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] They couldn't hit an elephant at this dist- - Dying words of Union General John Sedgewick -Original Message-From: Kevin Kostyszyn

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Amen..there are very few new "discoveries" and many many enhancements. One of the reasons the Japanese automakers have been KICKING AMERICAN FANNY for, oh, twenty years, is their simple, dogged *improvement* of our methods. They even revere William Deming, a guy we just shrugged off

RE: OT NT2K vs Unix.

2001-02-01 Thread Rocky Welch
You’re right about that, Ross. People can use Microsoft products, businesses cannot. Of course the world does need organized recipes and an animated paper clip to remind them of cousin Tilly’s wedding so in that regard I guess Microsoft products are useful. :o) "Mohan, Ross" [EMAIL PROTECTED]

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
You got it: there are no people in business.er, wait a second. Hmm... scratching headmust be in the Linux source code here, somewhere. :-D -Original Message-From: Rocky Welch [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 2001 4:38 PMTo: Multiple

RE: Primary Keys

2001-02-01 Thread David Barbour
Brian, This may be rather simplistic, but why can't you just use the bank routing number, account number, check number as the primary key? Routing numbers are unique to each bank. Account numbers are unique to each bank/customer. Check numbers are unique to each customer. Occasionally, an

RE: How to drop a database

2001-02-01 Thread Glenn Travis
What is usually in dba_temp_files? Mine has zero rows (all day). If you shutdown and restart Oracle, will this table be empty? -Original Message- From: Igor Polishchuk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 9:38 PM To: 'Glenn Travis'; Woody Mckay; [EMAIL

RE: OT NT2K vs Unix.

2001-02-01 Thread Suhen Pather
yeah, 3 years an MicroSlop still does not have a solution Did anyone notice the DATE on that story? I wonder innocent look if there is any substantive update in THREE YEARS SINCE IT HAPPENED. LOL! It's like the scalability attacks on Linux three years ago! HO HO! VBG

RE: OT NT2K vs Unix.

2001-02-01 Thread Gogala, Mladen
No. -Original Message- Sent: Thursday, February 01, 2001 4:02 PM To: Multiple recipients of list ORACLE-L Granted.just out of curiousity: Can you cite reliability statistics for the 10 year Unix? -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, February

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Title: RE: OT NT2K vs Unix. Did anyone notice the DATE on that story? I wonder innocent look if there is any substantive update in THREE YEARS SINCE IT HAPPENED. LOL! It's like the scalability attacks on Linux three years ago! HO HO! VBG -Original Message- From: Suhen

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Title: RE: OT NT2K vs Unix. Dayum! I had the SAME experience, almost. I tried to install SunOS5.6 on a very very early sparc chip, and boy, was it reluctant to work. Fortunately, the vendor had TOTAL CONTROL over the hardware and software, so in addition to charging something like a

RE: temp tablespace

2001-02-01 Thread Alex Hillman
Title: RE: temp tablespace I disagree. pctincrease should be 0, you do not need to coalesce tablespace if it is temporary. Segments in temporary tablespace are not dropped after SQL statement execution ends. But if you want to drop all segments from temporary tablespace the easiest way is:

RE: OT NT2K vs Unix.

2001-02-01 Thread Kevin Kostyszyn
yeah, you know I noticed that the video card acts a little strange with the built in driver. but I haven't noticed any other problems? Anybody? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jesse, RichSent: Thursday, February 01, 2001 4:18

RE: RE: OT NT2K vs Unix.

2001-02-01 Thread Kevin Kostyszyn
What about Mechwarrior or Quake II, can I run that on Unix and will it run smoothly? This is a fun debate, but I do agree there will never be a winner. -Original Message- [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 4:45 PM To: Multiple recipients of list ORACLE-L I believe

RE: OT NT2K vs Unix.

2001-02-01 Thread Kimberly Smith
Actually you can. In Motif you can do just about anything you can do in Windows. -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 2001 1:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT NT2K vs Unix. Oh, and not

RE: OT NT2K vs Unix.

2001-02-01 Thread Kevin Kostyszyn
Another excellent point. And know, it's not "mean" to intend to wound, especially if it's mentally. However, when you really think about sarcasm, it's really not "mean". You know like when yousay something really stupid and someone says "Wow, you are so smart!". It's not that it hurts, it

RE: OT NT2K vs Unix.

2001-02-01 Thread bill thater
On Thu, 1 Feb 2001,Kevin Kostyszyn scribbled on the wall in glitter crayon: -Oh, and not only that, I like the GUI a lot more than I like command -based programming...unless.can you play solitaire on Unix:) xsol and variants.;-) -- Bill Thater Certified ORACLE DBA Telergy, Inc.

Linking ORACLE 8i and ORACLE rdb7

2001-02-01 Thread Stephen Miller
To the list: We currently run ORACLE rdb7 on a Compaq ALPHA system. We are in the process of migrating the whole works to ORACLE 8i on IBM AIX. Does anyone have any experience in accessing ORACLE rdb7 using SQLNET or linking ORACLE 8i to ORACLE rdb7? We want to be able to transfer data between

Re: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Oliver Artelt
Don't forget your domain in tnsnames.ora. A serv.= or serv.mydomain.com should work. oli On Thursday 01 February 2001 19:33, [EMAIL PROTECTED] wrote: Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tnsnames.ora. When I try to connect using sqlplus I get ora-12514.

RE: OT NT2K vs Unix.

2001-02-01 Thread Rocky Welch
Air Bag? Windows Crash? The next generation of PC I can see it now. LOL This is a debate that will continue for years but it is entertaining. Thanks to all for theinteresting reading. =(True.Not sarcastic or mean.) Kevin Kostyszyn [EMAIL PROTECTED] wrote: Good points and don't worry about the

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Personally, I love sarcasm. Sometimes, theres a little collateral damage. We can put up with it in the Persian Gulf, why not here at home? ( har har har ) -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 2001 5:03 PMTo:

RE: RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Title: RE: RE: OT NT2K vs Unix. How about WORD2000 for Solaris 8??? Works great!!! -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 5:13 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: OT NT2K vs Unix. What

RE: OT NT2K vs Unix.

2001-02-01 Thread Gogala, Mladen
-Original Message- Sent: Thursday, February 01, 2001 3:28 PM To: Multiple recipients of list ORACLE-L PCs Stay Up and Running Fewer Reboots How Much More Reliable Is Windows 2000 Professional? Highest Reliability in Production Environments . . . Does anybody know what

RE: RE: OT NT2K vs Unix.

2001-02-01 Thread Glenn Travis
Title: RE: RE: OT NT2K vs Unix. Here you go: Best of both worlds Win4Lin: Running Windows Applications Under Linux (Does everything except games). http://www.linuxplanet.com/linuxplanet/reviews/2957/1/ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On

RE: OT NT2K vs Unix.

2001-02-01 Thread Steve Orr
I can vouch for that. One of the co-founders of Hotmail is my CEO. He confirms that MS was still using Apache, FreeBSD and Solaris when he left MS. (He worked awhile for MS after making a bundle from the Hotmail sale.) . . . A couple of years ago I was head-hunted for a job as an Oracle DBA

8.0.6 Installation Problem

2001-02-01 Thread Mouloudi, Saad
HI all, I had this error while installing Oracle 8.0.6.0.0 entrprise edition on tru64 V4.0G dig_server.806.vrf(0): FILE_NOT_FOUND while verifying dig_server.v806 (no such file or directory) any idea ? regards, Saad. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Title: RE: OT NT2K vs Unix. I heard this was a total list. Including documentation bugs. Anybody hear of another vendor releasing a complete bug list? -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 5:33 PM To: Multiple

RE: RE: OT NT2K vs Unix.

2001-02-01 Thread Bill Conner
At 02:38 PM 2/1/01 -0800, you wrote: How about WORD2000 for Solaris 8??? Star office works just fine and it's free. Works great!!! -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 5:13 PM To: Multiple recipients of list

RE: RE: OT NT2K vs Unix.

2001-02-01 Thread Mohan, Ross
Title: RE: RE: OT NT2K vs Unix. VMWARE is *sweet*, too. thx -Original Message-From: Glenn Travis [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 01, 2001 6:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: OT NT2K vs Unix. Here you go: Best of both

How to find USER who locked my row ...

2001-02-01 Thread Janardhana Babu
Dear list, I am simulating an error generated by an application. select * from XXX where fdoc_nbr = '12345' for update nowait; It returns with error: ORA-00054 Resource busy acquire with nowait specified. I need to findout who(SID,SERIAL#,USERNAME) locked the same ROW (not table). There

RE: Linking ORACLE 8i and ORACLE rdb7

2001-02-01 Thread Disser, Arno
Hi, We are currently having a working construction using RdB 7.0.5 Oracle 7.3.4.3.0, Sqlnet4Rdb 1.0.2.5.0 and having no major problems, other than a poor performance in joins over this db-link and some problems with the differences in the usages of timestamps in both DBMS's.

Oracle8 on NT (/Win2k) backup software

2001-02-01 Thread Eric D. Pierce
We are slowly getting closer to migrating (exp/imp) from Oracle7/Netware to Oracle8/NT (/Win2k), and are doing some budget planning in relation to what backup software to use. Campus datacenter SAs are telling me that they are currently using Veritas for NT4, but moving to Legato (see

Moving database to another platform with GL app 10.7 Character mode

2001-02-01 Thread Bao Jenny
Hi List, Currently, we are running Oracle Application 10.7 ( GL and AP modules, character mode) + Oracle Database .. all of them on one AIX box, so now we have plan to move Oracle database to SUN Solaris, and still kept Oracle application on old machine. I wonder about the Oracle Application

  1   2   >