TOAD Login Problem

Oracle 9i (9.0.1) on XP Professional on DELL 8200. TOAD VI freeware ver. 6.3.11.1g I keep gettint this error when I try to connect to 9i: Initialization error. Could not locate OCI dll I can connect using SQL*Plus with no problems. Any idea as to what the problem is with TOAD? Thanks much, Ke

Re:Eval copy of 91

Dick: I'm just going to use it as a learning tool. I looked into downloading the three zip files but it would have taken forever with my regular phone line connection. So, it was just easier to purchase the CD pack. Ken > Ken, > > To Oracle's good and bad, no nothing will happen. For a

Re: Eval copy of 91

Joe: I belong to OTN and tried that route. But I only have a regular speed phone line and it would have taken about two weeks to download the three zip files. So it was just easier to pay $39.95 plus shipping. And I also get other tools and doc. in the CD Pack. Ken > Yes your PC melts dow

Eval copy of 91

I have purchased an eval copy of 9i for my PC using XP Prof. The eval is for 30 days. What happens at the end of the eval period? Does my PC melt, does the DB lock up, or nothing? TIA, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [E

OCP Study Materials - Your Opinion

I found both of these OCP study materials on Amazon.com and would like your opinion of them. OCP: Oracle8i DBA Cert. Kit: Study Guide by Chip Dawes Book and CDROM from Sybex OCP: Oracle8i DBA Virtual Test Center from Sybex Your comments will be very helpful. Thanks, Ken Janusz, CPIM -- Pleas

Re: OT RE: How do you audit a DBA?

Write a letter to the IRS stating that he did not report all his income last year. They will be happy to audit him. Ken Janusz, CPIM > I think i see where this thread is going. > > You'd better audit change to the trigger that audits changes to the data > that > audits the DBA that you don't

Re: OCP Test timeframe

I have not seen anything of a time frame for the OCP exams. The only time frame is when the next release comes out and the previous release becomes obscolete. I am APICS CPIM certified and APICS has a time limit of about 3 years (?). Ken Janusz, CPIM > Hello, does anyone know if there is a

RE: How do they get the answer?

I want to thank everyone who gave me input on this question. It was most helpful. Ken Janusz, CPIM > um, I can see possible answers to this question being 2 teachers, 3 teachers > or 4 teachers. > > however, since that isn't one of the multiple choice answers, then it has to > be "at least 4

DB2 Question

Does DB2 store data as EBCDIC or ASCII? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

How do they get the answer?

I am taking the Self-Test software test for the SQL exam and don't see how they get the answer to this problem. They don't explain how it is arrived at. Any help you can give me will be appreciated. Thanks, Ken Janusz, CPIM -- Examine the structure of the TEA

Re: Converting EBCDIC to ASCII

Thanks for the help. Oracle will be located on a W/2000 box. Could you go into more detail on how one "exports" data from IMS on the mainframe to flat textfiles? Thanks, Ken > > > > > If you "export" the IMS data out to flat textfiles, > > and then transfer them via ftp in "ASCII" mode, t

Re: Converting EBCDIC to ASCII

Thanks for the help. How did you create the flat files? How did you get the data out of IMS and into the flat files? TCP/IP or SQL Loader or what? Thanks, Ken > > I did it by creating flat files containing only character data (no packed > fields), > and using sqlloader to load the data. > >

RE: Converting EBCDIC to ASCII

Thanks for the information. How does your mainframe guy get the data out of IMS? Thanks, Ken > We do not pull data directly from IMS but load it in batch jobs. Our > mainframe guy either dumps the data report-style (ASCII) or copies records > in native EBCDIC to files on the mainframe. We ftp

Re: OT: DBA tasks

Angelina: Do you know if your can setup your TIVO box so that it can automatically ignore commercials when recording? If, so how do you do that? Thanks, Ken Janusz, CPIM > Ahem... the female DBA's save the database, save the world, flatten the > evil people with her well-tuned martial arts s

ColdFusion

Would like to know if implementing ColdFusion has any "gotchas"? Also, any problems with the day-to-day administration of ColdFusion? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Converting EBCDIC to ASCII

Thanks for the information. The IMS data will have to be cleansed before it is loaded into Oracle (8.1.? on W/2000). So there will be some intermediate files/tables that will be used for this purpose. Will sqloader convert EBCDIC to ASCII? Thanks, Ken Janusz, CPIM > We do not pull data d

Re: Converting EBCDIC to ASCII

Thanks for the info. The Oracle DB will be on W/2000. Ken Janusz, CPIM > If you "export" the IMS data out to flat textfiles, > and then transfer them via ftp in "ASCII" mode, the > conversion will be done automagically for you. > > Alternatively if on Unix the "dd" utility will > do the convers

Converting EBCDIC to ASCII

I may be moving data from an IMS db which is stored in EBCDIC. Oracle stores data in ASCII format. How do I go about converting EBCDIC to ASCII to store the data in Oracle (8.1.?)? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [

Migrating IMS to Oracle

I may be starting a project in the near future to migrate an IMS database to 8.1.? on Windows 2000. I would like to know if Oracle provides a tool to do this? Data profiling, mapping, etc.? I could not find anything for IMS on OTN or the Oracle site. I know there are some non-Oracle tools

Re: Personal Top 3 Oracle titles

Before I buy a book I always check Amazon.com's reader reviews. They can be very helpful. Ken Janusz, CPIM > Guy Harrison's High Performance SQL Tuning Book > Steven Feuernstein's PL/SQL books (O'Reilly) > > Both of these books taught me a lot of what I know. I read Harrison's book > cover to

Oracle8i eBoot Camp

Does anyone have any experience with the Oracle8i eBoot Camp put on by OraKnowledge? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, C

Oracle Designer Question

Has anyone used Oracle Designer to do Business Process Modeling? If so, any problems with the product or gotchas? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Oracle Beta

I checked OTN and they have a download for 9i on NT but its the Lite version. Ken Janusz, CPIM > to be quite honest I can't be sure what it is. When I hit the link in the > email it opens up, but before I hit it I have to be logged on as a user with > privelages to get to it. I am pretty sure

Re: Medtronic

On Medtronic's career web site they are looking to fill the following positions: Sr. DBA Project Mgr Sr. DBA (2 positions) Prin. DBA I would like to find out who the hiring manager is, their mailing address and direct phone #. I already sent my resume to HR. Your help getting me this informa

Medtronic"

Is there anyone using this list from Medtronic in Minnesota? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Publi

Re: * Oracle DBA Needed in Phoenix..

With our current economic conditions it's a buyer's market. > > Peter, > > It probably means that they're willing to relocate someone > but don't want to pay a ton of money to relocate someone > who owns a house. There can be more than $10,000 worth > of closing costs, moving costs, guarante

RE: OCP Discount S36

Here is what the web site says: > Sign Up For a Test Now Register for Oracle certification testing (mention promotional code "S36" to receive your OTN 20% discount) -- There is no mention of an expiration date. Ken > I don't think it does -

A Question on the Basics of PL/SQL

I am a bit confused as to when to use the following. I cannot seem to find any definitive rules. - function - cursor - procedure - package If someone can point me to a white paper, or whatever, that defines the rules for their usage I would be most thankful. Thanks, Ken Janusz, CPIM -- Ple

OCP Discount S36

OTN says that you can get an OCT 20% discount on the testw with code S36. However, it doesn't say when this code expires? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5

Re: Virus?

Kevin: Yes, I got 2 of them and immediately deleted them. They looked fishy to me. Ken Janusz, CPIM > Hey, did anyone recieve a bunch of emails for a Venkata Apparao N with > attachments. It appears to just be peaces of emails and then a "see > attached" and an attachement? Yeah, I'll get ri

Re: Common Oracle RDBMS Misconceptions

Where can I get the "exploding the myths" paper? Thanks, Ken Janusz, CPIM > Jeremiah, > > Marlene and I did an "exploding the myths" paper very similar to what you > are doing.. > > "always set pctincrease on your temporary tablespace to 1" > > and my OOW submission is very very similar to yo

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

I don't know too much about their IS dept. I have my resume in with them for a couple of Oracle related positions, but haven't gotten any feedback yet. Ken > Sorry Ken. I thought I finally figured out what employers want. What do I > know. I work for a company who has different colored cha

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

I don't mind if they are lying for me, but not lying for the company that I may go to work for. Also, none of them get paid until they play someone. Ken Janusz, CPIM > And Lisa, most of them lie thru their teeth in order to get a position > filled ! > > -Original Message- > Sent: Monda

RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..

Lisa: You need to update this. Must not be over 30 years old with a minimum of 15 years of post graduate work as an Oracle DBA with a minimum of 5 years of experience with 9i and 11i. etc. Ken Janusz, CPIM > Requirements: > Must be able to lift heavy database files. > Must be at least 30 ye

OCP Testing Software

I have used SelfTest Software in the past to prepare for the OCP tests. Is there another similar company that is as good or better? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (

Re: * I'm Looking for an Oracle Financials DBA for Miami,

The Minneapolis / St. Paul area is not very active for Oracle people now. We have about 175 Oracle shops in the area. Ken Janusz, CPIM > Florida has always been a weak market compared to rest of the USA. I remember > in NYC, you could go get another job at a lunchtime interview. DC area has

Need Help

I need some help. I was an Oracle DBA with ADC Telecomm in Minnesota and was laid off along with 7,000 other ADC employees. The job market here in the TC’s has been very slow. Any assistance finding another Oracle related position would be greatly appreciated. Please contact me directly

OCP Discount?

I was looking over the OCP stuff on Oracle's web site and them mentioned a 20% discount. However, I can't find were to apply for it. Any ideas? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Ser

RE: OT SPAM : Become an Oracle Certified DBA in 5 Weeks

Yes. But it's only $1,499 a pop! Ken Janusz, CPIM > Yup. > > > > -Original Message- > Sent: 13 June 2001 14:16 > To: Multiple recipients of list ORACLE-L > > > Did anyone else on the list get this stupid spam besides me? > > thanks, joe > > > -Original Message- > To: [EMA

Re: Job search on this list

Yosi: I'm in the market also, got laid off from ADC Telecomm in the Mpls / St. Paul, MN area. The job market here is slow at best. So, I need some help. Thanks, Ken Janusz, CPIM [EMAIL PROTECTED] > Thanks to those who've responded so far. I forgot to > mention I'm looking in the New York Met

Re: 9i download

Is that ReGet Junior or Deluxe? Or, does it make a difference? Also, has anyone tried Download Accelerator Plus? It seems to be a similar product. Thanks, Ken Janusz, CPIM > > I'll second that. It's the only way to get a clean download from technet. > > Jared > > > On Monday 04 June 200

Re: job offer from SAUDI ARABIA

I would suggest that you contact the taxing authorities in you native country to determine if you owe any income taxes on what you make and also on any expenses that Saudi Arabia will give you. My 2 cents, Ken Janusz, CPIM > Hi all , > I have taken an offer from a company in Europe to work i