RE: Disk Names - sdXX vs. cXtXdXsX

> Is there a method or utility to translate disk names > reported by sar from the sdXX format to the cXtXdX > format? I'm on a Sun platform. If you look in /dev there are links from sd* to dsk/c*t*d*s*. I've got a little perl script to do the translation (see below), but its a bit rough-and-read

Re: Delete followed by Select Count(1) - SLOW

See my website: Index of topics -> Miscellaneous -> Block Cleanout Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L <[EM

Re: is C compiler a must for oracle UNIX installations ?

> All UNIX OS's come with a rudimentary C compiler and linker, mainly for the > purpose of rebuilding the kernel. What Oracle needs is the make utility and the > linker. Unfortunately, this is not true ... In SCO Open Server (5.x) you NEED to install a C-compiler before Oracle installation

RE: OT - Vaccines

Linda, I don't mean to be flippant but I am almost positive in about 13-16 years in the future there will be times when you will look back on those moments with EXTREME fondness Lee -Original Message- Sent: 16 August 2001 21:13 To: Multiple recipients of list ORACLE-L Thanks for the

table create vs alter

Hi, Does anyone know if the end result of these two statements is actually any different? CREATE TABLE mytable ( mycol1 NUMBER, mycol2 VARCHAR2(40), mycol3 VARCHAR2(30)); and CREATE TABLE mytable ( mycol1 NUMBER); ALTER TABLE mytable ADD (mycol2 VARCHAR2(40)); A

RE: Splitting a database: pro and cons

Title: RE: Splitting a database: pro and cons I would be tempted to leave them in the same instance, but use resource consumer groups to control them. Also, I would have their schemas (and associated objects) in different tablespaces, just to make management easier too, for things like backu

Dynamic cursor in PL/SQL

Title: Dynamic cursor in PL/SQL Hi gurus, I have to do a stored proc to compare the data of two tables in different schemas. I want to use a dynamic cursor and select the content of a table passed in argument. I saw in a document that I can work with REF CURSOR like this instance: schema_t

Two (probably simple) questions, function based index and table p

Hello folks! I need to create a function based index, but when I do this, Oracle gives me the message ORA-00439, function not installed, so I have tried and tried to figure out how to install this function, but I have failed, therefore this e-mail. I have looked in ORACLE_HOME/rdbms/admin and rea

RE: XML in Oracle ?

I have installed XML in Oracle, but not any development based on that myself. If you need help with getting XML loaded, let me know. Kumanan > -Original Message- > From: Raymond Lee Meng Hong [SMTP:[EMAIL PROTECTED]] > Sent: 13 August 2001 08:45 > To: Multiple recipients of list ORACLE

Export

Hi Can you please tell me if there is a way of exporting select rows from a given table in 8.1.6.2??? Thanks in advance Rgds Fawzia This message is confidential and is intended for the addressee only; unless clearly stated that this disclaimer should not apply, this e-mail is not intended

RE: Two (probably simple) questions, function based index and table p

What version of Oracle are you using? Function based indexes only work in EE. Rick -Original Message- Sent: Friday, August 17, 2001 6:46 AM To: Multiple recipients of list ORACLE-L p Hello folks! I need to create a function based index, but when I do this, Oracle gives me the message

RE: FW: [Fwd: Help scheduling Hot Backup on NT...]

If you have money there is always the SUN PC Card... Two different CPU architectures for the same workstation. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Bill Conner [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001

RE: Dynamic cursor in PL/SQL

Try: - schema_table := 'DIFF'; open schema_comp for 'select * from ' || schema_table; HTH David Lord -Original Message- Sent: 17 August 2001 11:46 To: Multiple recipients of list ORACLE-L Hi gurus, I have to do a stored proc to compare the data of two tables in different sche

RE: Openworld Abstracts

Project u - what is that?? .NOW - that has to be a jab at .NET. Couldn't find any white papers though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Br

NT backup script question

I have a NT cold backup script but I would like to add at last a winzip or any other compress command.  Any idea from someone who has already done this ?   Thanx

SV: Two (probably simple) questions, function based index and tab

Forgott to mension Oracle verson, 8.1.7.1.3 on a Windows 2000 advanced server /Jonas -Ursprungligt meddelande- Från: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Skickat: den 17 augusti 2001 12:08 Till: [EMAIL PROTECTED]; [EMAIL PROTECTED] Ämne: RE: Two (probably simple) questions,

Recovering WITHOUT tablespaces

Hi I need to recover the database with only a number of tablespaces from HOT backup. I know I can drop it from system later on, but will it cause any problems in applying archive logs with recover database statement? Any experiences/issues? Thanks Kumanan ***

RE: Export

In NT/2000 EXP username/password file=... tables=... query="""where condition""" log=exp.log That is 3 double quotes with NO spaces surrounding them UNIX exp demo/demo query=\"where lname like \'FRAN%\'\" tables=emp file=exp.dmp log=exp.log Rick -Original Message- Sent

RE: Export

Title: RE: Export Hi Fawzia, You can use the QUERY parameter in th export command. DOC :Oracle8i Utilities Release 2 (8.1.6) A76955-01 QUERY Default: none This parameter allows you to select a subset of rows from a set of tables when doing a table mode export. The value of t

linux for oracle

Hi Gurus, Can u please tell me the most stable version of Linux on which I can install Oracle 8i? Thanks in advance Uma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, UmaSankara S (CAP) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 F

RE: Comment on 'Practical Oracle 8i'

It's not actually too difficult to do this, if you have some hardware with lots of CPUs. With Solaris 8, you can create "processor sets", grouping a number of CPUs together, then running processes on those CPUs, they will not get any cycles scheduled on other CPUs in the system. This is different

RE: No TNSListner service after intall 8.1.7 on Win 2k

Thanks Bruce. That ifile part was the part I was missing. (looks like the the closest I can get to a unix link) I like the ifile implementation better than having two copies of the init.ora. Babette -Original Message- Bruce (CALBBAY) Sent: Friday, August 17, 2001 12:21 AM To: Multiple

RE: Deep Doo-Doo

TAR Number 1766421.999 Open Date 13-AUG-01 16:14:03 Support Identifier 3223081 Name Dave Farnsworth Priority 2 Last Update 13-AUG-01 18:02:05 Product Oracle Server - Enterprise Edition Product Version 8i Platform MS Windows NT Detailed Status Soft Close TAR Reference n/a BUG

RE: OT - Vaccines

Hi Ross - you wrote - >"...Children who have evidence of immunity as demonstrated by laboratory confirmation of immunity or a reliable medical history of disease are exempt from such requirement" > >|| This says, basically, that is it really ambiguous.lol > Actually, they're ref

Re: Export

exp help=y look at the bottom of the list, query option. joe "Malik, Fawzia" wrote: > > Hi > > Can you please tell me if there is a way of exporting select rows from a > given table in 8.1.6.2??? > > Thanks in advance > > Rgds > > Fawzia > > ---

RE: OT - Vaccines

>From: "MacGregor, Ian A." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT - Vaccines >Date: Thu, 16 Aug 2001 17:28:10 -0800 > " However, it was decided to allow the stocks of vaccines with thimerosal to be used ra

Re: Recovering WITHOUT tablespaces

Kumanan: Where I work, our databases are so big that we do it this way all the time. You need to restore the SYSTEM tablespace, at least one rollback tablespace, and any tablespaces you're interested in recovering from. You'll also need to have a copy of a 'backup controlfile to trace' script.

RE: Export

Title: RE: Export thanks all I found it in the online docs, but do appreciate all the responses... -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]]Sent: 17 August 2001 13:24To: Multiple recipients of list ORACLE-LSubject: RE: Export Hi Fawzia,

Re: linux for oracle

Uma: >From what I've seen and used myself, SuSE seem to be officially endorsed distro. I've >heard of people installing on RedHat, but I've also heard (especially concerning 9i) >that it is a pain in the a__ to get working--if at all. Jon Walthour > > From: "Rao, UmaSankara S (CAP)" <[EMAIL P

but will it run windows?

[EMAIL PROTECTED]: ** The World's Fastest Computer (This Week) Scientists at the Lawrence Livermore National Laboratory in Livermore, Calif., held a coming-out party this week, but it wasn't for a debutante--it was to dedicate the world's fastest computer, a silicon belle named ASCI White. And

Re: linux for oracle

8.1.6 on Redhat linux 6.2. Oracle 9i is available for mandrake linux with 2.2.4 Kernal HTH -- On Fri, 17 Aug 2001 04:23:36 Rao, UmaSankara S (CAP) wrote: >Hi Gurus, > >Can u please tell me the most stable version of Linux on which I can install >Oracle 8i? > >Thanks in advance >Uma >-- >Plea

RE: OT -- training

WHAT??? ECO went under? When did that happen.   (man am I ever out of the loop!!)   - Babette -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Monday, August 13, 2001 3:31 PMTo: Multiple recipients of list ORACLE-LSubject: Re:

PHP on Linux with Oracle

We've a Problem with PHP4 OCIFetch and varchar2 ! OCHIFetch with number or date Filed it work's fine but when i'll fetch a varchar2 Filed then i've no output in the browser ! When i dump the array then i see the character is 20 Bytes my field is 10 bytes i suppose so the character is unicode

RE: No TNSListner service after intall 8.1.7 on Win 2k

Babette, Bruce has the answer right-on regarding how NT starts Oracle services. Another way to accomplish this is to use ORADIM to point to the %oracle_home%\database\ directory. This is what I do so that I have one place to look for the init.ora file. I personally do not like the -ifile optio

Re: linux for oracle

If you need 24/7/365 server, install on kernel 2.2. Jan Pruner Dne pá 17. srpen 2001 14:23 jste napsal(a): > Hi Gurus, > > Can u please tell me the most stable version of Linux on which I can > install Oracle 8i? > > Thanks in advance > Uma -- Please see the official ORACLE-L FAQ: http://www.or

RE: Comment on 'Practical Oracle 8i'

Title: Message A friend of mine has an IBM XT with a 3 digit serial number.  He has been saving it for it to be bought from him for big money for a musuem "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their

RE: OT - Vaccines

Hi Ross - you wrote - > I haven't even *heard* of a case of tuberculosis..rubellamalaria... polio...diptheria...pertussis.in *years*. > Actually, tuberculosis is not really that rare - in fact, I had a very good friend who wound up with a positive PPD (tuberculosis test), apparently

RE: table create vs alter

g, why not try it the answer is - no difference. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, August 17, 2001 6:01 AM To: Multiple recipients of list ORACLE-L Hi, Does anyone know if the end result of these two statements is actually any differe

RE: Which view maintain droped constraint record?

Generally, unless you use auditing, Oracle will not keep anything dropped in the data dictionary, hense drop. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (

Re:but will it run windows?

Obviously not, it would take a single computer that powerful just to make Windows run in a meaningful way. Dick Goulet Reply Separator Author: Ray Stell <[EMAIL PROTECTED]> Date: 8/17/2001 5:15 AM [EMAIL PROTECTED]: ** The World's Fastest Computer

RE: OT - Vaccines

I wonder if there is a link between all of these vaccines that are forced upon our children and the increase in childhood illnesses, such as asthma and allergies and ADHD and ...?? Something has changed. With our new improved health care system, I believe on average children are sicker than they

RE: OT - Vaccines

Linda, I agree with Lee. My kids are 11,12 and 15. It is hard to remember when they were 4 months old. When I see small children now, I can't help but smile and laugh. It is absolutely amazing to watch small children learn and accomplish the smallest things - like rolling over and crawling!

Re:Oracle8i features

Roby, We wish to use Oracle 8i features like partitioning and global and local indexes in our datawarehousing project. ans -> Partitioning is only available as an add on to Enterprise edition, so make sure your licensed appropriately. We have the following doubts regarding these: 1)Does usage o

Oracle8i features

We wish to use Oracle 8i features like partitioning and global and local indexes in our datawarehousing project. We have the following doubts regarding these: 1)Does usage of local index make inserts,updates and deletes slower as compared to global index? 2)When is the use of Bitmap index prefera

RE: Comment on 'Practical Oracle 8i'

LOL A neighbor of mine had an original IBM PC, 64K RAM, 160Kbyte single-sided floppy, and the cassette port on the back so you could hook up a cassette recorder/play for data storage and retrieval, BASIC on EPROM. He wondered if the Smithsonian was interested. An old college classmate happened

RE: but will it run windows?

Yeah, wasn't this the only computer that MS could use with SQL Server to beat Oracle's benchmark... -Original Message- Sent: Friday, August 17, 2001 9:16 AM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]: ** The World's Fastest Computer (This Week) Scientists at the Lawre

RE: No TNSListner service after install 8.1.7 on Win 2k

Rick, As I recall, if you start the listener manually it will automatically create a tnslistener service if one doesn't already exist: lsnrctl start HTH, -- Anita --- "Cale, Rick T (Richard)" <[EMAIL PROTECTED]> wrote: > Thanks for the input. I am going to have a database > but I did not wan

RE: Recovering WITHOUT tablespaces

So if I just have SYSTEM, RBS, and TEMP along with the required data TS, it will be fine to "apply archive redo logs" of the DB? If so, that will be great. Thanks Kumanan > -Original Message- > From: Jon Walthour [SMTP:[EMAIL PROTECTED]] > Sent: 17 August 2001 14:16 > To: Multiple rec

RE: but will it run windows?

No actually they did it with signigicantly less. Although they kind of cheated. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 88

Oracle Performance in Unix machine with hardware Raid 5

Hi Guru, We will be implementing Oracle in unix machine with Hardware Raid 5. We can't implement Raid 1 as we do not have sufficient disk space. Initially, we thought of having many mount points .ie. 1 mount point for data files, another for index files, other mount points for redo log, contro

Re: PHP on Linux with Oracle

you should probably mail this to [EMAIL PROTECTED] George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 17, 2001 9:45 AM > > We've a Problem with PHP4 OCIFetch and varchar2 ! > > OCHIFetch with number or date Filed it work's fi

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: [

RE: Comment on 'Practical Oracle 8i'

Title: Message I have been collecting commodores and Apples for a while to keep in my own PC museum. I have been looking for a good working TRS-80. -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Friday, August 17, 2001 8:31 AMTo: Multiple recip

RE: Allow only certain ports for sql*net traffic

Yes, that is dynamic port allocation. There is a parameter to stop that, I believe if I remember correctly it is in the listener.ora. I had to worry about this when working with a firewall before. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize the

RE: linux for oracle

We're running two production 8.1.7 databases on Red Hat 6.2 here, will be bringing up a couple more in a few weeks. It's very stable, although there are a few annoying Oracle bugs peculiar to Linux that we've had to work around. We also have quite a few test databases running on Red Hat. Again, n

RE: but will it run windows?

> -Original Message- > From: Christopher Spence [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 17, 2001 10:51 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: but will it run windows? > > I hate windows and all it stands for, but I can't stand when > people say it > cras

RE: but will it run windows?

Windows is possibly stable if you manage to have 1Gb of RAM...what about the mere mortals among you that only have 128 or 256... I'm constanly having to reboot my machine as it gives the ol' two finger salute or BSOD! -Original Message- Sent: 17 August 2001 15:51 To: Multiple recipient

RE: NT backup script question

Try PKZIP, this has a command line interface.. You can most probably find it with a search for the name on the web.. HTH Mark -Original Message- Sent: Friday, August 17, 2001 12:41 To: Multiple recipients of list ORACLE-L I have a NT cold backup script but I would like to add at last

RE: but will it run windows?

And that is why 30 million people run windows. Yup, windows is completely useless. Get rid of it. It crashes every 1 second. I am no microsoft fan, but I have my laptop which I reboot once/3 months. I close it, which puts it in standby and I take it home, it automatically awks my wireless n

Re: NT backup script question

Check "COMPACT /C [filename]" command on NT. If you specify your 'backup' directory as [filename], then it will be marked as "compressed" directory, so that files added afterward (during your cold backup) will be compressed automatically while being copied.   Igor Neyman, OCP DBAPerceptron, I

RE: Oracle Performance in Unix machine with hardware Raid 5

Raid 5 will degrade performance, not many mount points. You will have contention, but that is not because of mount points or because of the lack of them. It is due to the fact that everything is running on the same set of disks. Raid 5 takes a big hit on performance, but if that is your only op

Re: but will it run windows?

Not everyone can throw money/hardware at an OS's deficiencies. Windows has a great interface, if it would only work as advertised. I think the big desire is to see M$ tighten up their codebase, i.e., make everything work better and more reliably rather than packing in additional features that on

Database upgrade w/ standby

I will be performing an upgrade this weekend of out production database from 8062 to 8063 (Alpha Tru64 40G machines). However we also have a standby instance which will obviously also have to be upgraded (my first). Are there any subtle things I have to look out for? One thing that comes to mi

Global Temporary Tables

Hi all, Where do I find more info, tricks, tips, when-to-use, when-not-to-use about global temp tables? I have already been through the FMs, but would like to find out more information. I have a process that is executed hundreds of times by multiple users on a daily basis. We are using pl/sql ta

RE: Oracle Performance in Unix machine with hardware Raid 5

We raid 5 on an AIX box, we have 89 mount points for database files (data and or index) as well as mount points for different kinds of scripts and files, redo and archival. We had one problems with Fork Function Failed for a while, Oracle said it was AIX, IBM said it was Oracle. We upped the pag

Re: RE: Recovering WITHOUT tablespaces

Yes. > > From: Kumanan Balasundaram <[EMAIL PROTECTED]> > Date: 2001/08/17 Fri AM 10:11:10 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Recovering WITHOUT tablespaces > > So if I just have SYSTEM, RBS, and TEMP along with the required data TS, it > will > b

RE: Converting EBCDIC to ASCII

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 them to the Oracle side (binary mode to EBCDIC files) and use sql loader to move into Oracle. On the

SOLVED: changing long col to varchar and vice versa

Hi list, I found a article at metalink which explanes how to change a long column to varchar. Example 2 worked for me. Doc ID: Note 1022030.6 3. How do you move a LONG to varchar2? It is not possible to change a long to a varchar useing the ALTER TABLE command. You could create a

RE: Please Help - ora error

Are you sure enough to post an answer? Alex Hillman -Original Message- Sent: Friday, August 17, 2001 2:45 AM To: Multiple recipients of list ORACLE-L Hi In case of Temporary Tablespace the Initital segemnt and next segment should be equal to the sort_area_size parameter. bye G.Subrah

RE: but will it run windows?

I am much a unix person over M$, but the simple fact is Win32 serves many purposes. And it crashing all the time is a fairy tail that unix people like to tell. Yeah, it isn't as stable as unix, and most of the problems are related to software and drivers which have nothing to do with the OS.

Re: Converting EBCDIC to ASCII

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 conversion for you. HTH & YMMV! [EMAIL PROTECTED] wrote: > > I may be moving data from an

RE: table create vs alter

Thanks Tom. I know that logically the schema would be the same, I was just wondering if the underlying physical storage set up by Oracle would in some way be suboptimal in the second case. But if they're identical, that's great, because it means I don't need to worry about patching schemas :0) g

RE: but will it run windows?

Not everyone can throw money/hardware at an OS's deficiencies. Os deficiencies? It takes $60,000 server to run Solaris OK. In NT you get the same performance at about $5,000. Most of the deficiences are to the poor performance of the intel processor in comparison to the 64bit risc count

RE: but will it run windows?

I've been discussing with someone else that perhaps they use 92 processes to run Windows and the 8,100 to monitor for errors and do an auto restart... We started with only 2 process to run windows, but then we thought about Office and upped it to 92... Mike Kline > -Original Message- >

RE: OT - Vaccines

Over here in the UK, we have our children done in two stages. They have the first at around 4 months, then go back 2/3 months later for the second. There was actually a story on the news a week or so back about a doctor being had up for offering the choice to parents to have the jab "all in one".

Re: Comment on 'Practical Oracle 8i'

On Fri, Aug 17, 2001 at 06:36:42AM -0800, Kevin Lange wrote: > I have been collecting commodores and Apples for a while to keep in my own > PC museum. I have been looking for a good working TRS-80. -- Speaking of museums, I took my daughter to the National Museum of American History a few we

RE: OT - Vaccines

I just meant I hate the vaccinations. They are a necessary evil for me as I have to take him to day care. I do give him the infant Tylenol. But how can I explain this to him when he is uncontrollably sobbing from the shots? Don't get me wrong...this age I love. Every day is a new experience

RE: OT -- training

early this year, Oracle User Resources decided it was no longer profitable to run ECO. >From: "Babette Turner-Underwood" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT -- training >Date: Fri, 17 Aug 2001 05:16:02 -

RE: OT - Vaccines

I've had the joy of a grand daughter.. I get all the joy and can hand her back to my daughter when I'm done. Her husband decided this wasn't for him, so she is with us. That's another story... grumble But, I get to see her pretty much every day... She'll be 3 months on the 23rd. And when he

RE: NT backup script question

i agree. pkzip also has a unix version, nice when you tranfer files between os's. gene >>> [EMAIL PROTECTED] 08/17/01 11:34AM >>> Try PKZIP, this has a command line interface.. You can most probably find it with a search for the name on the web.. HTH Mark -Original Message- Sent: Fri

Re: but will it run windows?

So you're saying, unless you run only M$ products it still sucks. They need to tighten up and open up the API's. Then windows would be great. --Scott Christopher Spence wrote: > > I am much a unix person over M$, but the simple fact is Win32 serves many > purposes. And it crashing all the t

Re: NT backup script question

Mark Leith wrote: > > Try PKZIP, this has a command line interface.. > > You can most probably find it with a search for the name on the web.. > > HTH > > Mark > Hi. You could try PowerArchiver - at http://www.powerarchiver.com Version 6.1 of the GUI was free (as in beer) - but the new vers

RE: but will it run windows?

And what are you going to run the 8,100 processers in, linux? Perhaps it would be better to get a better NT admin, and actually use the 8,100 processors. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes

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

Re: OT - Vaccines

Kathy Duret wrote: > > I just meant I hate the vaccinations. They are a necessary evil for me as I have to >take him to day care. I do give him the infant Tylenol. But how can I explain this >to him when he is uncontrollably sobbing from the shots? > *** You don't. You comfort them and the

Oracle and MC/Serviceguard

We are implementing MC/Serviceguard here for failover, and I have some questions about configuration/placement of Oracle files. Our Oracle environment: Oracle 8.1.6 (64-bit) HP-UX 11.0 (64-bit) We are not running OPS. The shared disks are on HP AutoRaid. Do all Oracle files need to be on the

Oracle DBA -Albany, New York

Healthcare solutions company in Albany, New York needs an Oracle DBA to join it's I.T. team. This company provides technical solutions to pharmacy, HMO and hospital clients. They are calling it a "Developmental DBA": You will be responsible for all facets of development related to the logical data

RE: OT - Vaccines

sicker? possibly. But the infant mortality rate has dropped. >From: "Babette Turner-Underwood" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT - Vaccines >Date: Fri, 17 Aug 2001 05:36:53 -0800 > >I wonder if there is

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: OT -- H1B brouhaha

You might find this interesting: http://www.mckinseyquarterly.com/ab_g.asp?ar=1101&nlink=23 g -Original Message- Sent: Tuesday, August 14, 2001 4:33 PM To: Multiple recipients of list ORACLE-L FYI, I found this on www.arstechnica.com: H1B visas and th

RE: but will it run windows?

If you only have 128Mb, 256Mb you think you would be considering unix? "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275

RE: NT backup script question

PowerArchiver is another good one, I know a couple of the people on the list use it to compress their NT backup sets >From: "Mark Leith" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: NT backup script question >Date:

Re: but will it run windows?

The win comment was just a joke, having just installed w2k and patches. Later, I hit the error, not being able to install office because of the patches. My associate said, "oh yes, you have to install office first, then patch." I sat there in wonder, and read about 12.3 teraflops machine.

Re: Converting EBCDIC to ASCII

I did it by creating flat files containing only character data (no packed fields), and using sqlloader to load the data. I think the only thing Oracle didn't know how to convert was the verticle bar ( | ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth

RE: but will it run windows?

I hate to climb on that soap box as well , but Chris is right. I am no fan of windows either, I have not had complete luck with it ... but then who has had complete luck with any environment. At my last job we had a Windows NT 4.0 Server that was running Oracle and Microstation CAD software.

RE: Database upgrade w/ standby

Rachel, The rebuild process is very painful. The database is 560Gb and getting the backup tapes to the DR site and getting the standby instance built before there are "too many" redo logs (for the I/O channel) to apply can be problematic. However, the more I think about it, the more a rebuild s

RE: Global Temporary Tables

Raj, Check out papers #127 and #130 at Craig Shallahamer's web site : http://www.orapub.com. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] > Sent: Friday, Augu

RE: Global Temporary Tables

I've got a sproc that uses a global temp. table. It works very well for different users to run and then get results back. Oracle is somewhat difficult about returning result sets from sprocs. (Sybase, MSSQL are not as anal - but they have other problems) There is no trick. Just experiment with

Re: but will it run windows?

I was thinking more along the lines of FreeBSD as optimal cost/benefit ratio. Now, if you can throw the Winders gui over a freeBSD codebase... Oh, wait, there is Mac OS... Scott Shafer San Antonio, TX Christopher Spence wrote: > > Not everyone can throw money/hardware at an OS's deficiencies

Re: Database upgrade w/ standby

Michael, Why not just rebuild the standby database from a backup of the upgraded production database? Or am I missing something here? Rachel >From: "Hand, Michael T" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Datab

  1   2   3   >