OT (Unix): Find names of files (in current & sub-dir) that contai

Hi Unix Gurus, What's the command to find the names of all files (in the current directory and sub-directory) which contains the word APPS ? I know that "grep -i APPS *.* " works but it's only for the current directory. I need to know all the files that contain the word APPS in the sub-directo

registry problems

Boy, I'm stumped. I've done this zillons of times on NT, but this is the first try on Win2k. I have a software key, HEKY_LOCAL_MACHINE\SOFTWARE\Oracle, that I am unable to delete. Here are the rest of the entries... HEKY_LOCAL_MACHINE\SOFTWARE\Oracle ..All_Homes ID1 ..\Registry Ba

Re: Oracle DBA With Internet Experience Needed in Harrisburg, PA

Dang fer'ners (NY'ers)! Can't trust 'em! --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 8:00 PM > I don't think they drive :) > > On the other hand, I remember reading a few years ago about someone who > liv

Re: database consistency tools ?

Rachel, you were a sybase DBA, the goddess notches another one on her belt. joe Rachel Carmichael wrote: > > Jared, > > having been a sybase dba (I know, forgive me for straying)... we ran dbcc a > lot. > > Oracle equivalent (poor equivalent) would be "analyze table validate > structure" may

RE: Oracle DBA With Internet Experience Needed in Harrisburg, PA

I do somewhat of the same. I'm out on the tip of the Olympic Peninsula and commute to Seattle. It's only a little over 2hrs each way by bus and ferry. Hell of a long commute, but what a wonderfull place to live. -Original Message- Sent: Thursday, August 30, 2001 6:00 PM To: Multiple reci

How many RBS waits are too many?

I'm using Guy Harrison's script that shows the percent of waits for WRITES to rollback segmants, and also the percent of waits for READS from rollback segments. If there are too many waits he suggests adding additional rollback segments. My problem is the book says waits become significant if th

ADMIN: Update on donations...

Hi again everyone... Jared and I are both truly honored and bowled over with the response that has been generated to this call for help! You folks are a generous and caring group of people, and I can't tell you how much it means to me that you've offered your help. There are literally almost a

Re: database consistency tools ?

Jared, having been a sybase dba (I know, forgive me for straying)... we ran dbcc a lot. Oracle equivalent (poor equivalent) would be "analyze table validate structure" maybe? Rachel >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROT

RE: Oracle DBA With Internet Experience Needed in Harrisburg, PA

I don't think they drive :) On the other hand, I remember reading a few years ago about someone who lived WAY out east on Long Island... he left his house at 5AM and reached his desk at 9AM every day. His reason for doing this? He loved where he lived and enjoyed the weekends enough that the

RE: Archiving data

Title: RE: Archiving data The database is running on older versions not on 8.0(i guess 7.3.4) .This is at one of the customers site and the solution is for that database. They might upgrade to new version after few months but till then we got to live with that.     -Original Message-

RE: Licensing cost for 1000 concurrent users?

Title: RE: Licensing cost for 1000 concurrent users? Yes you are getting screwed, but for that matter we all are. Oracle licensing always reminds me of an acronym I learned in the military...BOHICA...You can get the definition at either of the following links. http://ase.isu.edu/ase01_07/ase0

RE: ENQUEUE RESOURCES and DML LOCKS

Ethan, And for a simple script I find handy to look at v$resource_limit: -- resource_usage.sql -- -- 25-Aug-2000 Bruce Reardon -- -- Show the resource usage, including calculated percentage values -- set pagesize 1000 set linesize 150 column current_utilization heading "Current|Utilisation" fo

RE: database consistency tools ?

Maya, Also look into the dbv (Database Verify tool). In the 817 documentation this is covered in the "Oracle8i Utilities" manual, chapter 9. Also see Metalink note http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=32969.1 for a good overview of dbv, db

RE: Archiving data

Title: RE: Archiving data This sounds like a textbook case for table partitioning. Read the manual on partitions. You ARE on oracle 8.0 or above, I imagine? > -Original Message- > From: Ravindra Basavaraja [mailto:[EMAIL PROTECTED]] > > I have few tables that will be getting populate

Re: database consistency tools ?

Maya, I'm not a Sybase DBA, but I play one on TV. Just kidding, I took the Sybase DBA and replication courses last year. I was a little surprised at the emphasis placed on dbcc. When asked about the Oracle equivalent, my reply was 'We don't have that problem'. Seriously, the type of error y

Licensing cost for 1000 concurrent users?

Title: Licensing cost for 1000 concurrent users? We are in the process of negotiating our contract with Oracle. I've been asked to inquire as to how much other sites are paying for a license for 1000 concurrent users.   We are looking in the ballpark of $400-$500k according to the Oracle negot

Re: ksqsttyp in x$ksqst CF

Hi, CF stands for ControlFIle Transaction. THis is generally acquired while updating the controlfiles ,like status changing of the tablespaces online/offline/readonly/readwrite. ANd excessive checkpints, log switches, dumping file headers, hot backups are also cause CF waits. >I am having s

Archiving data

I have few tables that will be getting populated with transaction data continuously.This table grows to large size.For us once the transaction is completed we don't need the data to be in the database, but we cannot delete them either.We need to archive those records and clear those archived recor

Re: Parallelism in oracle8i

Soman, If you are truly scanning 100,000 records then that could be the problem. There is overhead to do the PQ. In your case it is probably cheaper to do a serialized query. Try the same test with 1,000,000 or 2,000,000 records and you will probably see a difference. I had a similar problem to th

RE: OT: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY

I agree with Ethan.  I mean how hard is it to set up a message filter or rule?  I'm constantly throwing away junk mail at home.  The only difference is that I shred the stuff at home because it's more personal typically.  That darn delete key is tough to reach *ouch*  The only thing you ment

RE: sql*loader datatype question

Check your positioning. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Koivu, Lisa"

Re: 9i NT

Kevin, Starting the NT service for the oracle instance has never started the database in any version of Oracle on NT by default. I think what you have seen before is the use of the auto start service of the DB. This service has a dependency to the SID service, so when you start the SID service it

RE: OT: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY

Try spamcop.net. It can read your headers and figure those things out. Plus send out emails to the abuse addresses. -Original Message- Sent: Thursday, August 30, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Ethan, I will admit that a spammer can torque my jaws pretty hard

Re: setting up a common Net8 connect string for all OPS instances

Andrey, Why? I wouldn't name all of my instances with the same name. There are some v$tables that have the instance name as a column and that would just get confusing. It is good practice to use different SID names for OPS and in 9iRAC it is mandatory. The TNS syntax you are using below is SQL*NET

RE: Oracle DBA With Internet Experience Needed in Harrisburg, PA

Now see... THAT is Greater area! I think I would loose my voice cussing out the idiot drivers if I were to commute from PA to NY... there are just way too many of them... and WAY too much time in the car. -Original Message- Sent: Thursday, August 30, 2001 4:04 PM To: Multiple recipients

RE: maximum number of processes exceeded

Donna, thanks for the thought. no web connections, just Citrix for a middle tier. everything else is dedicated server connections. It appears that the count(*) for v$process is increasing, while the count for v$session is remaining stable. thread count is at 175 ... I guess when it gets to 250

Re: An Interesting Grouping Question

"MacGregor, Ian A." wrote: > > Given the following Table > > emplid course_id > -- - > 1 1 > 2 2 > 2 3 > 3 3 > 3 4 >

Re: database consistency tools ?

Maya, see Oracle 8i Administrator's Guide, the chapter on "Addressing Data Block Corruption."  Or try a search of the docs for "dbms_repair".  This is what you are looking for.   Oracle DBA's don't seem to always place as great of emphasis on this type of checking as Sybase DBA's, who seem to

RE: OT: football fan-hood

Isn't it some Detroit Redwing, I can't remember. Would have loved to have had the chance to play in college, but the didn't happen. Hockey players get all the girls...to have deep intellectual conversations about work and school and the universe and stuff...whoo...that was cl

RE: !! *Very* important Oracle-L message !!

Jared & Bruce Tried to reply yesterday but was not really on this list. Had a different reply address from signup address... Thanks for straightening that out Bruce. I have learned alot from a few months of list lurking. Count me in for a donation. Thanks to all of you for sharing your wisdom

Re: !! *Very* important Oracle-L message !!

http://www.thehungersite.com/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 1:21 PM > Let's start a campaign for Hunger ! > > -Original Message- > Sent: Thursday, August 30, 2001 12:28 PM > To: Multiple recipi

Re: Oracle licensing,,,,again

In these cases, Oracle tends to charge by the power of your server multiplied by the tensile strength of your shoelace divided by the number of sheep in an arbitrary pasture plus the total number of hair folicles on your head then doubled. Seriously, I've always had best success (in Oz and UK

Re: UTL_FILE and ksh

I'd look at java or equivalent to actually run a OS command to do 'ls -l' and get this result back. hth connor --- "Post, Ethan" <[EMAIL PROTECTED]> wrote: > I have a directory that another process will be > placing files in and I will > be processing them using the UTL_FILE package. I > wish

RE: 8.1.7 on W2K

Uma, Check your registry to ensure that the key ORA__AUTOSTART is set to TRUE. That will start the instance after the Service starts. It's documented for 8.1.6 in Appendix B "Oracle8i Configuration Parameters and the Registry" in "Oracle8i Client Administrator's Guide Release 2 (8.1.6) for Wind

Re: UTL_FILE and ksh

Or you can have the script that's creating the file generate an indicator file after finishing writing the file. So if the indicator file doesn't exist then the file is still being written to. >>> [EMAIL PROTECTED] 08/30/01 04:16PM >>> One solution for the "make sure the file is complete problem

RE: sql*loader datatype question

Title: RE: sql*loader datatype question Lisa,   A .bad file with the offending record should have been created when sqlloader abended. Even at 1500 characters you should be able to eyeball the single bad record in a good editor and figure out what values are in the phone number part of the r

RE: Spooling output of a select statement to a file through store

utl_file has execute granted to public -0 so there is no need to grant execute. Alex Hillman -Original Message- Sent: Wednesday, August 29, 2001 2:57 PM To: Multiple recipients of list ORACLE-L stored Do not forget 'grant execute on utl_file to apps_user' before running.. MOHAMMAD RAF

RE: OT: football fan-hood

Heck, look who got Anna Kournikova, ! Dave -Original Message- Sent: Thursday, August 30, 2001 3:00 PM To: Multiple recipients of list ORACLE-L I am curious, what is the reason? -Original Message- JAMES W [IT/1000] Sent: Thursday, August 30, 2001 2:48 PM

Re: phantom queue table

Actually, yes. I don't have the specific details - that would be helpful, right?? - but after contacting Oracle support, I had to remove an entry from an internal table. Check out Metalink - I'm sure it's on there. Brian Richard Ji wrote: > Hi all, > > I try to create a queue table (AQ) and i

phantom queue table

Hi all, I try to create a queue table (AQ) and it tells me the queue table already exists. But it's doesn't show in the ALL/DBA_QUEUE_TABLES. I tried to drop it and the dbms_aqadm.drop_queue_table() executes successfully. But when I try to create it again it gave me the same message. It seems

RE: An Interesting Grouping Question

That's correct. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 12:54 PM To: Multiple recipients of list ORACLE-L Ian; Are you saying that if employees 1 and 2 took course 1,2,and 3 but employee 3 only took cours

RE: Oracle DBA With Internet Experience Needed in Harrisburg, PA

I remember going to Lititz (sp?) PA when I was a kid and making a pretzel in the oldest pretzel factory in the USA. I even learned that the 3 holes represent the trinity (first made by monks), and that pretzels used to be coated with sugar. German's changed it to salt so they would be thirstier an

Strange error.log ERROR

Performance statistics empty: data overflow Anyone seen that one before? Thanks, Ethan http://www.geocities.com/epost1 -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confide

Re:OT: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY

Ethan, I will admit that a spammer can torque my jaws pretty hard, especially when they go to such long lengths to hide their true identify and repeat the spam several times in one day. At the present moment I'd like to get a spammer who is putting three identical spam messages in my inbox e

RE: sql*loader datatype question

Anyway, what if you need to add some non-domestic phone numbers?   Henry -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: RE: sql*loader datatype question I agree

RE: !! Keeping the list alive

Um, Kevin, if the shoe doesn't fit, then don't wear it. :) Not all developers are duhvelopers, in fact, most of the ones I know are very good, but the ones that are duhvelopers require so much attention that it kind of wears on you. :) And some of us DB-ehs can do just fine writing apps, than

Re: Fwd: RE: !! *Very* important Oracle-L message !!

no no no no no! :) Jared Jan Pruner <[EMAIL P

Re[2]: Permanent Tablespace for sorting.

Joan, 1) because I've not had any problems using a permanent tablespace 2) I'm an old timer set in my ways 3) my sa is against it for disk fragmentation reasons 4) my boss see's no reason to change something that is working without a problem. In general, "if it ain't Baroque don'

RE: Oracle to Sql Server

On sql server table create your column definition as a TEXT column. But be aware of the 2g limitation. -Original Message- Sent: Thursday, August 30, 2001 11:06 AM To: Multiple recipients of list ORACLE-L It's working . but how do I move those objects with CLOB Datatype ?? Any Ideas

Re: OT: football fan-hood

All right, Ruth, this is just too mysterious. Let's have it. What is ths reason? Rodd Holman >> Original Message << On 8/30/01, 2:54:18 PM, Ruth Gramolini <[EMAIL PROTECTED]> wrote regarding Re: OT: football fan-hood: > I'll forward the email I just sent L

RE: Oracle DBA With Internet Experience Needed in Harrisburg, PA

then there is the Greater NY Metropolitan Area, which lately seems to include all of Long Island, Westchester, lower CT, most of NJ and seems to be spreading towards PA even as I type (I know people who commute DAILY from PA to NYC) >From: April Wells <[EMAIL PROTECTED]> >Reply-To: [EMAIL P

RE: OT: football fan-hood

because Hockey players RULE!!! (sorry..) -Original Message- Baumgartel Sent: Thursday, August 30, 2001 3:06 PM To: Multiple recipients of list ORACLE-L I haven't heard it, Ruth; care to clue me in? Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message---

RE: OT: football fan-hood

Title: RE: OT: football fan-hood Mmhcceeey.. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of HAWKINS, JAMES W [IT/1000]Sent: Thursday, August 30, 2001 12:58 PMTo: Multiple recipients of list ORACLE-LSubject:

Oracle licensing,,,,again

I understand about how concurrent and named user licensing works for the most part. What I don't understand is when you have a web application that gets people from all over coming into our site and then routed through MTS to be sent to the Oracle database for info. How does the web stuff count

Re: OT: football fan-hood

Why not? Baseball doesn't even have yellow cards. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 2:48 PM Ruth, Yes, I know the reason women are attracted to hockey players, I just didn't think of it. So I gues

Fw: OT: football fan-hood

Here it is! RBG - Original Message - To: "Koivu, Lisa" <[EMAIL PROTECTED]> Cc: "oracle list @fatcity" <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 2:48 PM > It's not because they are graceful like figure skaters, it's not because we > like to see their cute little tushes when the

RE: An Interesting Grouping Question

Ian; Are you saying that if employees 1 and 2 took course 1,2,and 3 but employee 3 only took course 1 and 2 then you would want to see 2 groups: group 1: Employees 1 and 2 (took courses 1, 2, and 3) Group 2: Employee 3 (took course 1, and 2) Kevin -Original Message- Sent: Thursday, A

RE: A PL/SQL datatypes conversion question

Andrey, You should first do a utl_raw.cast_to_varchar2 and then split the varchar2 string into individual numbers, using substr(). HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expr

Re: OT: football fan-hood

It's not because they are graceful like figure skaters, it's not because we like to see their cute little tushes when they skate backwords (o, maybe a little), it's when they have to go into the little room when they've been bad, (Ba-a-a-d Sergey, Ba-a-a-d Sergey). I can't tell it like the ad on

Re: OT: football fan-hood

I'll forward the email I just sent Lisa... Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 3:06 PM > I haven't heard it, Ruth; care to clue me in? > > Paul Baumgartel > MortgageSight Holdings, LLC > [EMAIL PROTEC

RE: OT: football fan-hood

Hahahah, me niether:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

Re: OT Kaszynski-Ware and Hannibal

Fortunately the glare-screen can be removed and serve as a plate. I have spoken to the warden. There will be no mint flavoring on your bit tonight! --Scott "Mohan, Ross" wrote: > > Scott! lolthanks for the check in...nice to > know i am "having an effect" in the world out there! > > y

RE: !! *Very* important Oracle-L message !!

It is very interesting and informative reading the replies to the original request. I did not know how diverse this list is as a lot of responders to the email are normally quiet and on the sidelines. ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Ro

RE: Unix-script

Just an example: #!/bin/ksh . $HOME/.profile {Insert additional environment variables here} ftp -vin {Box Name or IP Address}Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Unix-script >Date: Thu, 30 Aug 2001 07:16:2

RE: Oracle DBA With Internet Experience Needed in Harrisburg,

A lot cheaper that regular mail where he would have to pay for printing, paper, envelopes and postage. It's all relative.   Stephen     >>> [EMAIL PROTECTED] 08/30/01 12:26PM >>>1500 users / 10$ = 6.6 cents per email.  Pretty expensive rates don't yathink?>-Original Message->From: Far

RE: sql*loader datatype question

I agree with Joe.  I always have declared the data to be char, even if I am loading a number field.  Always seems to work.   Tom Mercadante Oracle Certified Professional -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 2:48 PMTo: Mu

RE: OT: football fan-hood

Ruth, you can't float that nugget out with giving us the answer. -Original Message- Sent: Thursday, August 30, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Have you heard ESPN's reason why women are so attracted to Hockey? You might think differently about having hockey

Re: OT: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY

about to start flame war, the other side is then the people who dont care about spam are the spammers.  so where do YOU fit in?   joe >>> [EMAIL PROTECTED] 08/30/01 02:47PM >>>This is sure to start a huge flame war but...I am always shocked about howseriously some people take the act of spamm

RE: Oracle DBA With Internet Experience Needed in Harrisburg,

1500 users / 10$ = 6.6 cents per email. Pretty expensive rates don't ya think? >-Original Message- >From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 30, 2001 11:48 AM >To: Multiple recipients of list ORACLE-L >Subject: RE: Oracle DBA With Internet Experience Need

Re: UTL_FILE and ksh

One solution for the "make sure the file is complete problem" is for the script that is actually doing the file creatation is to write/create it into a subdirectory of the target folder. Once the file is closed & complete, the script simply moves or renames the file into the target directory. This

RE: sql*loader datatype question

Title: RE: sql*loader datatype question Good explanation but no  it's not -Original Message- From:   Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, August 30, 2001 2:48 PM To: Multiple recipients of list ORACLE-L Subject:    Re: sql*loader datatype question Lisa,

RE: sql*loader datatype question

Title: RE: sql*loader datatype question Well noo   it's fixed-length and I think I'd end up with a big jumble, wouldn't I?  No delims in the file. -Original Message- From:   Bala, Prakash [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, August 30, 2001 2:48 PM To: Multiple reci

RE: OT: football fan-hood

I am curious, what is the reason? -Original Message- JAMES W [IT/1000] Sent: Thursday, August 30, 2001 2:48 PM To: Multiple recipients of list ORACLE-L Ruth, Yes, I know the reason women are attracted to hockey players, I just didn't think of it. So I guess Cardinals baseball would be

RE: Tuning File IO on 8.0.5 and a Netapp file system

Kevin, Nothing wrong with just going with the defaults unless you actually discover there is a problem with DBWR IO. I would suggest some clear goals and benchmarks. Play with async_io, dbwr_io_slaves and other dbwr parameters. Run a performance monitoring tool during the tests and get some rea

ksqsttyp in x$ksqst

Title: ksqsttyp in x$ksqst Hi - Where can I find out what the values mean in the ksqsttyp column on the x$ksqst table?  I am having some waits associated with the value "CF", but I don't know what that means. If anyone can help, I'd greatly appreciate it. Lisa

RE: !! *Very* important Oracle-L message !!

I will weigh in for a one-time contribution. Thumbs-down on the complexity of managing a subscription. Since there seems to be some concern & confusion about the value of money (US$20) and exchange rates (with an undercurrent of the ability of all to pay), perhaps a different yard stick is in or

Re: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY

Yes. People-staff is harvesting email addresses from the list. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 11:16 AM > Uh-oh - anyone else get this ?? > > > -Original Messa

RE: constraint names

Here is something that I have feel free to modify ... Although it is designed to be used in Forms application, it will give you some idea. -- start here -- PROCEDURE LP_CIVILIZED_ERROR (PI_SQLERRM IN VARCHAR2) IS -- /* **

OT RE: financial problems with fatcity.com

Title: OT: RE: financial problems with fatcity.com aren't you kind!  i have to say that...here...i get a bigger kick out of  making folks laff than recommending a tech fix that 20 of my betters will come up with first!   so.NO WAYI am a listserv remorahappily swimming along...

OT: Peoplestaff spammer aka Rick Zabor

Rick Zabor is a long time unrepentant spammer. It appears he's stopped spamming me because I've complained about his spam runs in the past. Complain to EXODUS.NET about hire.com. Complain to VERIO.NET about www.peoplestaff.com What you tolerate, you perpetuate! If you are NOT part of the soluti

Re: sql*loader datatype question

Lisa, Can you show us the control file and a couple of lines of sample data? Are you sure you don't have an unprintable character before/after the phone number? Is this occurring for all the phone numbers? David A. Barbour Oracle DBA, OCP AISD 512-414-1002

Re: Permanent Tablespace for sorting.

Dick, Just wondering why not just convert it to temp tablespace? Joan Hsieh DBA -ocp 7&8 617-627-5032 [EMAIL PROTECTED] wrote: > > Chris, > > I've always used a permanent tablespace for temp and have not had the > problems you state. But it does take some consistency to maintain. > > 1-

Re: Oracle to Sql Server

Title: Message It's working . but how do I move those objects with CLOB Datatype ??   Any Ideas???     - Original Message - From: Walthour, Jon (GEAE, Compaq) To: Multiple recipients of list ORACLE-L Sent: Thursday, August 30, 2001 1:26 PM Subject: RE: Oracle to

constraint names

Hello, Oracle 8.1.6 on Solaris 2.7 I am trying to write an exception handler that extracts the constraint name from SQLERRM whenever a constraint violation occurs. I am trying to do this by using the substr and instr functions to extract just the constraint name; the reason is that we want to t

A PL/SQL datatypes conversion question

> Dear list ! > > There is a column of datatype RAW in a table. > it contains 4 numbers (4 bytes each) and a string of 54 bytes , that are > concatenated and then converted to RAW by an external C++ application. > I need to convert it back in a PL/SQL trigger. > I.e. i need retrieve that RAW colu

RE: sql*loader datatype question

Lisa, Have you tried loading without specifying any datatype and length in the control file? Just a thought... Prakash -Original Message- Sent: Thursday, August 30, 2001 1:33 PM To: Multiple recipients of list ORACLE-L I'm hitting a wall here. I'm trying to load data into a large

UTL_FILE and ksh

I have a directory that another process will be placing files in and I will be processing them using the UTL_FILE package. I wish there was a way to list the contents of a directory from PLSQL but I don't think that there is. My solution at this point is cron out a ksh script that will check the

Re: error running query using microsoft odbc driver for oracle

Can you run the same code when you connect with SQLPlus? Harvinder Singh

Re: sql*loader datatype question

Lisa, Is the field you are attempting to load the last field in the string? is the delimited in place? The reason being is the EXTERNAL INTEGER data might be interpreted at char including the "space" at the end of the string. That has bit me before and now all non-numbers are enclosed in quotes

RE: OT: football fan-hood

Ruth, Yes, I know the reason women are attracted to hockey players, I just didn't think of it. So I guess Cardinals baseball would be a good hobby? Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Co

RE: OT: football fan-hood

That's right, Kevin. I can't duck projectiles unless semi-sober. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAI

RE: Oracle to Sql Server

Title: Message You may need to do some tweeking of the tables - but most every table/view moves fine. It will not move pl/sql or triggers. -Original Message-From: Walthour, Jon (GEAE, Compaq) [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 10:27 AMTo: Multiple recip

Re: OT: football fan-hood

Have you heard ESPN's reason why women are so attracted to Hockey? You might think differently about having hockey as a hobby. Lifelong sports fan, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 12:58 PM Well, I'

RE: !! Keeping the list alive

Well, I've only seen you posting on this list for about a month now, so I think you missed the context of "duhveloper". It is generally used around here to refer to those developers out there who "just don't get it" (don't bother with proper design of stuff, never bother with sql tuning, think

An Interesting Grouping Question

Given the following Table emplid course_id -- - 1 1 2 2 2 3 3 3 3 4 3 5 4

RE: sql*loader datatype question

how about a cut of the 10 chars, then grep looking for A-Z, a-z in whats left.   joe >>> [EMAIL PROTECTED] 08/30/01 02:58PM >>> Yup, looked at that too.  Unfortunately the record is 1500 characters long.  That's a lot to just eyeball.  Thanks -Original Message- From:   Igor N

RE: OT: football fan-hood

I haven't heard it, Ruth; care to clue me in? Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 1:57 PM To: Multiple recipients of list ORACLE-L Have you heard ESPN's reason why women are so attracted to Hockey? You might

OT Kaszynski-Ware and Hannibal

Scott! lolthanks for the check in...nice to know i am "having an effect" in the world out there! yeaUna-Metabolism (or *whatever*) is pretty hard to parse sometimes (probably like "John Smith" would be in the click and whistle language of the Kalahari Bushmen) but the software actually

Re: Unix-script

Ron, try man cron or man crontab write your shell script as if you were going to run it from the command line manually (however, make sure you define all the environment variables you will need within the script) Once it is done and working, use cron to schedule it for Unix. Rachel >Fr

OT Re: financial problems with fatcity.com

Hannibal, I just spewed rice, refried beans, and fajita meat all over my screen! ("Uni-Bomberism") LOL!!! Do you have any idea how hard that is to clean off? Much worse than liver or fava beans... --Scott From:"Mohan, Ross" <[EMAIL PROTECTED]> Guys like Lewis, Adams, Uni-Bomberism, etc. bo

  1   2   3   >