RE: Sub-query in order by clause

2003-04-04 Thread Lyndon Tiu
Which way is faster? The subselect(nested select) or the join? Thanks. -- Lyndon Tiu Quoting Jacques Kilchoer <[EMAIL PROTECTED]>: > Why would you do that instead of > SELECT emp.deptno, empno, ename > FROM emp a, dept b > WHERE dept.deptno = emp.deptno > o

RE: Value of OCP

2003-03-20 Thread Lyndon Tiu
Quoting Stephen Lee <[EMAIL PROTECTED]>: > > -Original Message- > > Did you learn anything from the previous crash to prevent it from > > > happening again? > > > > Yes. Duct tape the power cord to the floor. > Whoa! -- Lyndon Tiu --

Re: Value of OCP

2003-03-20 Thread Lyndon Tiu
o check and not to panic no > matter > who is breathing down my neck to get the database back up > experience teaches you the general things that can go wrong > Teaches you to stay cool. "Database crashed again!? No problem, seen this happen before." -- Lyndon Ti

Re: Value of OCP

2003-03-19 Thread Lyndon Tiu
On March 19, 2003 05:23 pm, Rachel Carmichael wrote: > trust me, experience helps you think through a production crash -- > especially if it crashes in the same way as it did the last time :) > Did you learn anything from the previous crash to prevent it from happening again? -- L

RE: Value of OCP

2003-03-19 Thread Lyndon Tiu
t; database > crash recovery, deal with users, etc. > No amount of training, exam taking or even experience can prepare you with any of this. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City

RE: Value of OCP

2003-03-19 Thread Lyndon Tiu
Depends on the orginazation. Some organizations are rigid seniority based traditionaly managed where it does not matter if you have a PhD or not. If you've been with the company 10 years, then you get a raise and get to do neat things. -- Lyndon Tiu Quoting Pete Sharman <[EMAIL P

Re: OT: Who Owns Unix?

2003-03-07 Thread Lyndon Tiu
But GNU is not UNIX. -- Lyndon Tiu Quoting "Orr, Steve" <[EMAIL PROTECTED]>: > Per the below link, SCO owns Unix and they're suing IBM for a > paltry > $1Billion: > > http://www.infoworld.com/article/03/03/06/HNsco_1.html > > > How can this be?

Rman and controlfile backups.

2003-03-04 Thread Lyndon Tiu
unavailable. 7) This is because I used the controlfile as the rman repository. And when I back-uped the controlfile, the controlfile did not yet have the updated backupset information. 8) How do you solve this problem? Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http

Re: RedHat 8.0

2003-03-04 Thread Lyndon Tiu
Oracle use it's own jre. Comes with the install package and installs as part of the software package. You probably have an unrelated DISPLAY or X server problem. -- Lyndon Tiu Quoting "Odland, Brad" <[EMAIL PROTECTED]>: > Anyone messing with RedHat 8.0 and Ora

Re: 32 bit and 64 bit memory

2003-03-01 Thread Lyndon Tiu
n.oracle.com/tech/linux/pdf/9iR2-on-Linux-Tech-WP-Final.PDF > Actually, it did answer all my questions! Thank you. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-50

Re: 32 bit and 64 bit memory

2003-02-28 Thread Lyndon Tiu
Hey, I just remembered that Oracle on Linux runs as multiple processes , unlike Oracle on Windows which runs as one big process. Does this mean each Oracle process on Linux can access 3GB of memory? So that in the end the whole of Oracle can actually use greater than 3GB of memory? -- Lyndon Tiu

Re: 32 bit and 64 bit memory

2003-02-28 Thread Lyndon Tiu
this since PGA, sort area, log buffer takes some space too) does not give you a lot of data, does it? It's equivalent to a 3GB hard drive full of Oracle data. 3GB hard drives are what, a 5 year old technology? 3GB of Oracle data, translates to how many rows, columns, tables (roughly)??

Re:Hello

2003-02-28 Thread Lyndon Tiu
What's wrong with plain text? Should we start using XML too? Where is the world going? -- Lyndon Tiu Quoting [EMAIL PROTECTED]: > Chuck, > > HTML makes a mess in my e-mail package, at least right now. > > Dick Goulet > > Reply Separator___

PAE on ia32

2003-02-28 Thread Lyndon Tiu
Hello, Anyone here used Oracle on a PAE enables ia32 hardware? Can Oracle use more than the 3GB limitation? Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

32 bit and 64 bit memory

2003-02-28 Thread Lyndon Tiu
Hello, 1) How big (max) can an Oracle SGA be in a 32bit platform (Windows and Linux on ia32)? 2) How big (max) can an Oracle SGA be on a 64bit platform (Sparc Solaris, AIX PowerPC)? Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon

RE: OT - MS at it again?

2003-02-28 Thread Lyndon Tiu
code you see? -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > I find it interesting that some foreign countries like China and > Russia have > expressed interest in Linux for just this reason. They realized > that maybe > someday the CIA could bury some code to

Re: MS SQL hasn't given up!

2003-02-27 Thread Lyndon Tiu
If you know MS. You should know they will never give up. They will conquer the Universe one day. Resistance is futile. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > For your amusement, MS thinks they can "now" equal Oracle in > performance > (wasn&#

RE: Partition recovery question

2003-02-21 Thread Lyndon Tiu
I like that 40% OCP, 100% DBA. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [

RE: RMAN gui...in OEM 9.x i

2003-02-21 Thread Lyndon Tiu
RMAN is cool. Especially in 9i since everything is automated, as in channel allocation and such. RMAN in 8i was a bit painfull since a couple of steps were manually necessary. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL

RE: Service startup on Windows 2000 fails

2003-02-19 Thread Lyndon Tiu
Please tell us what caused the problem and how you solved it. -- Lyndon Tiu Quoting "Koivu, Lisa" <[EMAIL PROTECTED]>: > Hi Wayne, > > Thanks so much for responding. > > I guess my lack of knowledge of Windows 2000 administration has > just bit

Re: Service startup on Windows 2000 fails

2003-02-19 Thread Lyndon Tiu
Check to make sure Oracle is not using NT PDC authentication. Maybe you do not have a PDC in the network and Oracle would not start becauise of this. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City

RE: best way to provide GUI outside of telnet

2003-02-18 Thread Lyndon Tiu
e for this? > Sounds like a huge development project. Got to be web based GUI. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.

Re: Know 1 database, know them all?

2003-02-17 Thread Lyndon Tiu
Learning the first database is the hardest for me. After which learning the rest was easy. -- Lyndon Tiu Quoting Mogens Nørgaard <[EMAIL PROTECTED]>: > I see it from a slightly different (and probably wrong) angel, at > least > regarding the performance of things and datab

Re: Oracle 8i or 9i ?

2003-02-14 Thread Lyndon Tiu
When I quoted the prices, I quoted exam prices alone. Education costs are extra. FYI - I got my OCx without going to school. Work experience and self study were all I needed. -- Lyndon Tiu Quoting Les Ayudo <[EMAIL PROTECTED]>: > School A (www.idtnetwork)which is offering the Oracl

Re: Oracle 8i or 9i ?

2003-02-14 Thread Lyndon Tiu
9i will cost you more in the long run because you have to take 4 exams at $150 each plus a $3000 course to get OCP. 8i then upgrade to 9i will cost you less but requires you to take up to 6 exams at $150 each but no more $3000 course. -- Lyndon Tiu Quoting Les Ayudo <[EMAIL PROTEC

RE: Ora-00600 fun

2003-02-14 Thread Lyndon Tiu
Quoting "Farnsworth, Dave" <[EMAIL PROTECTED]>: > 8.1.7 on NT. Got it fixed though. > > Thanks, > > dave > Dave, Instead of just telling us it's fixed. Perhaps it would be better if you actually told us how it got fixed, please. Thank you. --

Re: RMAN: I don't trust it

2003-02-13 Thread Lyndon Tiu
n comes into play. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: RMAN: I don't trust it

2003-02-13 Thread Lyndon Tiu
not come close to Oracle in funxtionality. I am already over-worked trying to manage just one PostGreSQL instance. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://ww

RE: Unix research source ???

2003-02-13 Thread Lyndon Tiu
l desktop now. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Unix research source ???

2003-02-13 Thread Lyndon Tiu
Difference between Unix and Linux is $$$. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Unix research source ???

2003-02-13 Thread Lyndon Tiu
1) Solaris http://docs.sun.com 2) Linux http://www.linux.org/docs/index.html 3) AIX http://www-1.ibm.com/servers/eserver/pseries/library/sp_books/index.html 4) Got questions: try Google at http://www.google.com 5) There's more out there but these sites are a good start. -- Lyndo

Re: Oracle License for Training

2003-02-12 Thread Lyndon Tiu
ot > been following MySQL development for some time so perhaps things are coming > along. PostGreSQL is definitely worth to learn if you have a free weekend for hacking. It's pretty much all you need for most jobs. Best of all, it's free! as in free beer. -- Lyndon Tiu -- Please see

Re: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

2003-02-12 Thread Lyndon Tiu
. . . no way! If anyone on this > list is getting discouraged, this is the time to pursue that truck driving > career you've always dreamed of. Go! Hurry! ;-) > I will be while before things get cleared up. By then, I'll be a pensioner. -- Lyndon Tiu -- Please see the offici

RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
s you get the job done, only that it will get you the job in the first place. Even junior position DBA require a B.Sc. (those that I've read). As far as the wave is concerned, it's getting too crowded at the crest. Too many people wannbea DBA. -- Lyndon Tiu -- Please see the official

RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
after the bubble burst. > > ? > > What's that to do with becoming a DBA? > Too many other experienced DBA's running around jobless. > > But I do admin(solely me and me alone) exactly one PostGreSQL > > development soon to be a production database so does tha

Re: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
Quoting Ora NT DBA <[EMAIL PROTECTED]>: > You are WRONG! The Oracle Academic Initiative has 100's of members. > In > California > there are more than 200. > I should move to Californiaa. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.

Re: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
e one > heck of a mess. > More like people are developing software on a database running on development machines. Look at the number of [Re]'s on the subject line of this email!!! -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INE

RE: Re[2]: Re[2]: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
Quoting Nick Wagner <[EMAIL PROTECTED]>: > Two words - Speed and Performance. > gotcha. Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-5

Re: Re[2]: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
ink Java (and .Net) should be thought before C since C is harder. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Ma

Re: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
m > if > desired. > > more information can be found at: > http://oai.oracle.com > Sounds good. It's not that expensive! I wonder if Oracle instructors cost more than MS SQL instructors that's why most schools (where I am)offer MS SQL? -- Lyndon Tiu -- Please see th

Re: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
#x27;t enough of this because I can't seem to find one where I live. All I see are MS SQL classes all over the place. The school where I graduated from offers MS SQL. I ask them about Oracle and they gave me an answer - "We teach SQL using MS SQL.". -- Lyndon Tiu -- Please see the

Re: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
's not even my job to do this tweaking (it's someone else who went to Oracle class for $$$ company paid and still does not know), it just so happens I know how to fix it that's why I get called to fix it. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: AW: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
omatic - somewhat like Oracle's locally managed tablespace feature. Perhaps this is the way databases should go - intelligent self-tuning. It will be hard to accomplish but is possible. Hopefully, we will get there (slowly) one day. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ:

RE: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
community college. What Oracle is doing right now is stifling this. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com S

RE: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
sity, College, High School not those $$$ making diploma mills). -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Ma

Re: Re[2]: Re[2]: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
le? More efficient? I find the plain text output more useful and easy to store. Recovery is easier as well, just cut and past the relevant lines of script and run it. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat

RE: AW: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
problem. Only to be surprised when the DB stops working and then finding out later that the init.ora file needs to be edited for scalability. Oracle does not scale itself. It needs to be configured to scale. Why isn't Oracle scalable by default? -- Lyndon Tiu -- Please see the offici

RE: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
g saying over what > technology > to use. > But of course, Oracle does not know this. They are sitting on their laurels thinking they are "THE" Database. They will lose the lower end of the market and get pushed upmarket till there is no more room to go. -- Lyndon Tiu -- Pleas

Re: [Q] ctl-c on sql/plus hange the terminal session on LINUX system?

2003-02-11 Thread Lyndon Tiu
g list > and we > press ctl-C, the termineral session hang. If outside sql/plus and > press > ctl-C, there is NO problem. I do not have the same problem. Pressing ctrl-C stops the long query but simply returns to the sqlplus sql> prompt. -- Lyndon Tiu -- Please see the offici

RE: AW: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
den?, secret??) that I have never encountered before. That's why I freaked out when someone mentioned "You can do this with that... !" I did not get the point that hsql is a different database. Anyways. It's good to know there is another database out there. Thanks. -- Lyndon

Re: AW: AW: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
7;s why I asked. Thank you. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list a

Re: AW: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
va app. > I thought we were talking about Oracle and Postgresql here? hsql is not scalable means I'd rather use Access. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services--

Re: Oracle License for Training

2003-02-11 Thread Lyndon Tiu
they will prefer what they know. When will these people learn? IBM priced OS/2 out of the market. Sun priced Solaris out of the Intel market (until recently, but it's too late). Oracle is going soon if they continue to do this. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ:

Re: Re[2]: RMAN: I don't trust it

2003-02-11 Thread Lyndon Tiu
first with some automagic third-party utility). -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

Re: RMAN: I don't trust it

2003-02-10 Thread Lyndon Tiu
tabase files are in binary format. Simply copying does not turn it into text sql scripts. Could you please explain further? Thanks. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Servic

Re: RMAN: I don't trust it

2003-02-10 Thread Lyndon Tiu
If only Oracle can come up with a Postgresql command such as: pg_dump dbname | gzip > dbname_backup.gz Then backups would be easy. I know, I know Oracle can do the same with export, and sqlplus but hell it ain't that easy with Oracle. -- Lyndon Tiu -- Please see the official ORAC

RE: Freeware reverse engineer ER diagram from ODBC connection

2003-02-10 Thread Lyndon Tiu
tried it I did not seem to find the function for this. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

Re: multiple oracle homes

2003-02-07 Thread Lyndon Tiu
at's > in > oracle base such as the inventory. > > during an install/upgrade this common data needs to be updated. > > i suppose i would work ok if u were careful with permissions, but > it would > be just one more thing to go wrong. -- Lyndon Tiu -- Please see

Re: Re[2]: RAC on linux?

2003-02-07 Thread Lyndon Tiu
is > FUN!! > I am doing this as we speak! I am having so much fun! -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Californi

Freeware reverse engineer ER diagram from ODBC connection

2003-02-06 Thread Lyndon Tiu
Hello guys, I remember seeing a freeware software that can connect to a database through ODBC on Windows, then reverse engineer the ER diagram from the database. Could someone on this list email me or us the link to get this software? Thank you very much. -- Lyndon Tiu -- Please see the

RE: Windows 2000 Cluster on oracle

2003-02-06 Thread Lyndon Tiu
Quoting Bernardus Deddy Hoeydiono <[EMAIL PROTECTED]>: > I > suggest if > your O/S (Win2K) running well ,please don't apply the service if > not > necessary. Perhaps this is the advice most people followed that's why that Slammer worm took off. -- Lyndon Tiu --

RE: Windows 2000 Cluster on oracle

2003-02-05 Thread Lyndon Tiu
; subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tony Johnson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and

RE: Migration from SQL Server to ORACLE 9i

2003-02-04 Thread Lyndon Tiu
Read-up: http://otn.oracle.com/documentation/oracle9i.html http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: [Q] does Redhat 8 has problem work with ORACLE 8.1.7???

2003-02-03 Thread Lyndon Tiu
try strace ./runInstaller or strace ../runInstaller -- Lyndon Tiu Quoting Joe Raube <[EMAIL PROTECTED]>: > What is your DISPLAY environment variable set to? > > -Joe > > --- dist cash <[EMAIL PROTECTED]> wrote: > > > > > > I installed the

RE: Borderline OT - Unix for Oracle at home

2003-01-30 Thread Lyndon Tiu
a 5 or 10 workstations on ebay for less than $500. > > Anyone having experience good/bad/ugly for this type of task? All > tips, > challenges, things to consider are greatly appreciated. > > Dan Fink > > -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http:/

RE: Problem on P4 intel servers

2003-01-29 Thread Lyndon Tiu
I believe the problem affects only 8i. 9i is ok. -- Lyndon Tiu Quoting "Jesse, Rich" <[EMAIL PROTECTED]>: > I completely forgot all about this, but the install I just > completed went > without a hitch. I'm running Win2K SP3 (bleah) and installed > 9.2.0.1.0

Re: SQL Net connection.

2003-01-28 Thread Lyndon Tiu
ut value is the key here. It's probably in the range of 30 seconds to 2 minutes depending on the OS. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://w

Re: SQL Net connection.

2003-01-28 Thread Lyndon Tiu
If you are using TCP/IP, then yes. It's highly dependent on your OS TCP/IP stack though. I tried it with Linux and it seems fine. -- Lyndon Tiu Quoting Bond Mike A Contr OC-ALC/LPRC <[EMAIL PROTECTED]>: > > Is there any possible way to retain/reinstate/continue a SQLNet

Re: SQL Net connection.

2003-01-28 Thread Lyndon Tiu
If using TCP/IP, you don't have to do anything. 10 seconds is short enough time for the connection to still be alive. -- Lyndon Tiu Quoting Bond Mike A Contr OC-ALC/LPRC <[EMAIL PROTECTED]>: > > Is there any possible way to retain/reinstate/continue a SQLNet > connection

RE: Freeware tool to browse data in Oracle tables?

2003-01-21 Thread Lyndon Tiu
Why bother with third-party freeware when Oracle client software is free too. Oracle 9i's Enterprise Manager Console is a pretty good GUI tool. -- Lyndon Tiu Quoting Jeremy Pulcifer <[EMAIL PROTECTED]>: > TOAD > > -Original Message- > Sent: Tuesday, January

Re: year 2059 problem

2002-12-29 Thread Lyndon Tiu
Hmmm, anyone tried Linux Oracle with year 2059? -- Lyndon Tiu On Sunday 29 December 2002 08:28 pm, Amit Nargotra wrote: > This strange problem we are facing while implemting Oracle Based ERP at > Nepal for asian paints. > > Nepal follows Hindu calender, as per the hindu calender the

RE: Logitech Give Away

2002-12-20 Thread Lyndon Tiu
What's the logic behind the skill testing question "required by Canadina Law" to win a prize? -- Lyndon Tiu > -Original Message- > Sent: Friday, December 20, 2002 2:10 PM > To: Multiple recipients of list ORACLE-L > > > LOL glad I'm not

RE: Oracle connection/listener/dispatcher stops allowing connecti

2002-12-20 Thread Lyndon Tiu
get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > Lyndon >I would look at the wait statistics to see what

RE: 8i OCP DBA Exams

2002-12-20 Thread Lyndon Tiu
Not to mention 10i is coming out soon. Too fast man. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Oracle connection/listener/dispatcher stops allowing connections

2002-12-20 Thread Lyndon Tiu
tions? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu --

RE: Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Lyndon Tiu
. Everything is still in there. Whatever that's not in there you can down load from www.rpmfind.net -- Lyndon Tiu Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > Any limitations on the personal version or lack of features that exist in > the pro/advanced server vers

Re: Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Lyndon Tiu
Why not? -- Lyndon Tiu Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > Thanks > > Waleed > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
create database database_name can you? ?? -- Lyndon Tiu Quoting Nick Wagner <[EMAIL PROTECTED]>: > if the DOS command prompt doesn't work, try starting it at the services > level. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET:

Re: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
OK. Thanks. -- Lyndon Tiu Quoting Boris Dali <[EMAIL PROTECTED]>: > Alan, I think what Lyndon meant is this > SQLNET.AUTHENTICATION_SERVICES thing on MS Win that > toggles your ability to connect with the syntax > described. Comment it out and you might see somethi

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
I certainly did not get anything after each exam, only after each level. I got the OCA level certificate and a letter from some Veep two weeks after I completed the second 9i exam (which I'm happy to say I did before the Sept. 1, 2002 deadline !!!). -- Lyndon Tiu Quoting DENNIS WIL

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
When you say at least with O 9.2, does this mean we cannot do this in 8i ? We have 8i on EnTee and WinTuKee. Thanks. -- Lyndon Tiu Quoting "Cornio, Georgette Ms USACFSC" <[EMAIL PROTECTED]>: > > How do you startup & shutdown the database on NT/W2K ? > &g

Re: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
Oracle DBA's could not setup a W2K Oracle database properly - tainting the OCP name in the process, ouch. -- Lyndon Tiu Quoting Alan Davey <[EMAIL PROTECTED]>: > Hi Lyndon, > > Well I don't know about your setup, but I can connect just fine with the > connect str

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
racle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTE

RE: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > My instructor in a recent Oracle E

RE: Oracle 8i Certification Will Terminate When???

2002-12-04 Thread Lyndon Tiu
I'm barely done with my 9i certification track and I'm hearing of 10i coming out soon. All's too fast! -- Lyndon Tiu Quoting [EMAIL PROTECTED]: > Peter, > I don't think a date has been announced yet. > When they do state a date they give 6 months notice thoug

Re: Are Oracle courses required for Oracle Certification now?

2002-12-04 Thread Lyndon Tiu
You are not required to take the expensive course if: 1) You are upgrading from 7 8 or 8i certification. 2) You took your very first 9i certification exam before Sept 1, 2002 3) You are only shooting for the Associate certification level. -- Lyndon Tiu Quoting Kieran Murray <[EMAIL PROTEC

RE: Oracle 9iR2 on Red Hat 8.0

2002-12-02 Thread Lyndon Tiu
Oracle 92i runs fine on all recent Linux distros. I've tested it on Mandrake 9.0 and all's well. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.f

RE: surprising result:8CPU Sun 3500 VS 4CPU Dell 6650

2002-11-15 Thread Lyndon Tiu
from Sun nor from anybody else. I'd hate to say this but Sun is on it's way out if this is the case. -- Lyndon Tiu Quoting John Shaw <[EMAIL PROTECTED]>: > I am also having a weird performance issue with a sun box - mine is a new > v880 4 cpu (900mz) with 16g of ram and a 2

Linux?

2002-11-14 Thread Lyndon Tiu
/news_article.php?topiccode=20021001_itereport0043 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Solaris vs Windows 2000

2002-11-14 Thread Lyndon Tiu
/news_article.php?topiccode=20021001_itereport0043 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Solaris vs Windows 2000

2002-11-14 Thread Lyndon Tiu
ed 500 per server at three servers on average per installation site, so imagine the cost of that. That's where Linux comes in. AND contrary to what people still think, Linux is ready for prime-time. -- Lyndon Tiu On Thursday 14 November 2002 01:30 am, Mark Leith wrote: > This blind h

Re: Solaris vs Windows 2000

2002-11-13 Thread Lyndon Tiu
I'd like to quote Chairman Mao: "If you repeat a lie 1000 times, it becomes the truth." -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

Re: Solaris vs Windows 2000

2002-11-13 Thread Lyndon Tiu
W2K will beat Solaris anytime on cost. Linux will beat anything including the kitchen sink on cost. -- Lyndon Tiu On Wednesday 13 November 2002 08:38 pm, Jared Still wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City

Re: Solaris vs Windows 2000

2002-11-13 Thread Lyndon Tiu
companies will be medium to large sized and guess what, they will have Linux in them. -- Lyndon Tiu On Wednesday 13 November 2002 08:40 pm, Jared Still wrote: > You're looking at this from your own perspective. > > Try looking at it from your manager's perspective, or the &

RE: Solaris vs Windows 2000

2002-11-13 Thread Lyndon Tiu
What's wrong with having 18GB SGA. It's never enough anyways so it's good to have more. Besides, Linux uses a flat memory system (I think) in that it fools application into thinking Linux got GBs of physical memory when in fact most of it is available as SWAP. -- Lyndon Tiu

RE: Solaris vs Windows 2000

2002-11-13 Thread Lyndon Tiu
I don't understand. I could easily configure Oracle on Solaris to show this same output. Your Oracle on Linux is probably misconfigured. You probably don't know how to work Linux? -- Lyndon Tiu Quoting Stephen Lee <[EMAIL PROTECTED]>: > > FTLP> show sga >

RE: Solaris vs Windows 2000

2002-11-13 Thread Lyndon Tiu
That's where IBM's 1billion comes in. -- Lyndon Tiu Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>: > That is the problem with free stuff. There isn't a big expensive hype > machine around to push it. > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. >

Re: Solaris vs Windows 2000

2002-11-13 Thread Lyndon Tiu
adiness is relative. I'd say it's ready enough. Maybe not SAP specifically. But if you havn't heard, Oracle software runs on Linux fine with a lot of support available for it already today - Dell, RedHat, Oracle & IBM all support Linux. -- Lyndon Tiu On Wednesday 13 Novemb

Re: Oracle 10i features

2002-11-12 Thread Lyndon Tiu
Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > > San Diego, California-- Mailing list and web hosting services > > > > - > > > > To REMOVE yourself from this mailin

Re: Solaris vs Windows 2000

2002-11-11 Thread Lyndon Tiu
Seriously now. I know you are trying to evaluate Solaris and Windows, but ... Linux is the way to go. Sun's are expensive machines. NT/2K are cheap(er) but locks you into an expensive software upgrade cycle. Linux costs very little and runs on cheap hardware. -- Lyndon Tiu On Mond

  1   2   >