Errorhandling

Hallo you DBA's: Can someone give me an example on how to write the code to trap errors where the field is too large to fit in the size of the PL/SQL variable? I also want the errors to be logged in a table. Please give me a good example on PL/SQL code and also includ ethe insert statement

Re: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P

for downgrading from oracle 8 to 7, u need to take complete export and import the file in oracle 7 by running the catexp7.sql utility. look for more help on this utility. - Original Message - From: Djordje Jankovic To: Multiple recipients of list ORACLE-L Sent:

forget sys password ?

Hi all, What can I do, if I forget my testing server's sys account password ? I keep sys and system passwords together, and I lost that document. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network

Metadatabase

Hi All, I am looking for an application or software which helps me doing my job as a DBA. I want to set up a what we call a metadatabase, which gets and holds data about the databases I administer as a DBA. I want to keep data in the metadatabase as for example the growth of data in a database

RE: job offer from SAUDI ARABIA - OFF TOPIC

Well Said Gregory Though may SAY the SAME About our Lands Too INDIA Always Ever , forever -Original Message- From: Gregory Conron [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: job offer from SAUDI

RE: PCTFREE/PCTUSED

What is your DB_BLOCK_SIZE? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. KaradenizSent: Thursday, May 17, 2001 04:51To: Multiple recipients of list ORACLE-LSubject: PCTFREE/PCTUSED PCT_USED = PCT_FREE + 1 row sizePCT_USED

Problem with DBMS_UTILITY.ANALYZE_DATABASE

Hi there, I have a problem to analyze my whole database as user sys: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SQL BEGIN 2 DBMS_UTILITY.ANALYZE_DATABASE('COMPUTE',NULL,NULL,NULL); 3 END;

Re: forget sys password ?

hi , just connect as Internal in svrmgr then alter user sys identified by newpassword still forget password Internal ? use Orapwd ... Bambang Setiawan Sinardy Xing [EMAIL PROTECTED] 05/18/01 03:30PM Hi all, What can I do, if I forget my testing server's sys account password ? I

File size problem.

Hi DBAs, We are creating a oracle 7.3.4 database on a sun machine with solaris 8 installed on it.The problem is that when we try to create a file thru the oracle then it does not allow us to crewate files bigger than 2000M size.whereas when we do it thru the OS it does create bigfiles created

Re: Errorhandling

Hi Roland, I added a ittle example that shows how to trap the value error and stores it into a very simple error table. This is very basic, normally you add a lot more exceptions ( like NO_DATA_FOUND and ofcourse the OTHERS) and store a lot more information in your error_table ( like the value

RE: forget sys password ?

Do you know internal's password? If so log on as internal, and alter user sys identified by new_password;. This of course assumes that you do not have any scripts with the sys user/password coded in (a bit of a no no anyway). But hey this is a test server anyway! HTH Mark -Original

Re: Metadatabase

Hi Create your own. Kevin loney's dba handbook give good guidelines for starters, but you can extend as you please. I have created a package in my monitoring database that has many different procedures to collect meta data from different databases across db_links. these procedures get called

RE: Metadatabase

Arie I suppose this depends on the stats that you are trying to collect - If it is just growth reports on data, this could probably be easily achieved with a single script and table. Run the script or schedule it once every X-n (X-integer, n-timespan), and populate your table with the data

vni-2015 authentication error

hello I'm running oracle 8.1.7 on WNT. I've set system/manager as the preferred credentials of the DB, and an administrator OS account (with 'run as batch job' priv) as the credentials of the node. I'm getting the vni-2015 authentication failed error while running any job. can anybody help me?

RE: forget sys password ?

Change it by going into svrmgrl and connecting internal. One other thing SYS AND SYSTEM PASSWORDS ON A LOST DOCUMENT - AAARRRGGH ! Lee -Original Message- Sent: 18 May 2001 08:31 To: Multiple recipients of list ORACLE-L Hi all, What can I do, if I forget my testing server's

Ynt: File size problem.

Hi, being able to create a file 2GB in OS does not mean being able to create file 2GB in Oracle. Oracle addressing technique may not match OS addresing capabilities. There should be a note on metalink which give oracle-platform matrixes regarding 2GB problem. - Original Message - To:

RE: data migration

If the remaining 90% of data is not going to change while you test-run the first 10%, then how about something like this: run this against the original data just before moving the 10%: SELECT 'CREATE SEQUENCE '||sequence_name||' START WITH '||last_number + 1||';' FROM user_sequences; This gives

Re: ODBC driver setup is not started

In my case it was because of bad PATH variable. It must have "c:\orant\bin" (or wherever you installed) in it. I changed it in (as I remember) Start/Control Panel, System, Environment variables HTH Mike "Nguyen, Long (ITS, Limestone Ave)" wrote: Hi, A user had just installed Oracle

Re: File size problem.

7.3.4 does not support file sizes larger than 2GB From: Manivannan.M [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: File size problem. Date: Fri, 18 May 2001 02:41:02 -0800 Hi DBAs, We are creating a oracle 7.3.4 database

RE: job offer from SAUDI ARABIA

Statistically, states where handguns are legal are the states where violent crimes are less. Criminals prefer easy victims. Outlaw handguns and only Outlaws will have them. Check out: http://www.tsra.com/LottPage.htm I am not saying everyone should carry a firearm but those who do must

SNAPSHOT

Hi I am trying to create a snapshot from a valid database link but get an error (ORA-12014 table name does not contain a primary key constraint)i have a valid primary key on my table . Any help would be highly appreciated. Shahid. -- Please see the official ORACLE-L FAQ:

RE: job offer from SAUDI ARABIA

That's sort of the whole nature vs nurture argument and it could very well last the rest of our lives. Fact is, you could be raiesed in the United States by a fine upstanding family, but you could still turn around and go gun everyone down at school the next day. It's not necessarily how you

RE: job offer from SAUDI ARABIA

That's a very good article. -Original Message- Conron Sent: Thursday, May 17, 2001 9:56 PM To: Multiple recipients of list ORACLE-L On Thu, 17 May 2001, Gene Sais wrote: Only in America, can you rant! Try to criticize China while living there. I have a friend there, her mail is read

RE: Temporary files and Quick i/o

I wonder if you could do something (big sort or temporary table etc) to force the space to be allocated ie de-sparse-ing the file, and then convert the file to Quick IO ? Connor --- Khedr, Waleed [EMAIL PROTECTED] wrote: I think that the failure will not be caused by Oracle but by the

RE: job offer from SAUDI ARABIA

Statistics from who? Actually most states that allow citizens to carry weapons for there own protection have seen a decline in muggings and things of that nature. A criminal is less likely to try and mug someone if the criminal thinks that the person is hiding a .357! -Original

Event ID 1008 in NT - Oracle 8.0.5

Good morning, I am getting the following error in the application event log. It occurs every hour and there are four instances of the error every hour. The error is as follows: Event ID 1008 Source: Perflib The Open Procedure for service Oracle80 in DLL oraperf.dll failed. Performance data for

Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE

grant analyze any to sys; hth connor --- Bachmann, Henrik [EMAIL PROTECTED] wrote: Hi there, I have a problem to analyze my whole database as user sys: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SQL BEGIN

Re: job offer from SAUDI ARABIA

Here, here! RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 5:16 PM SET MODE SILLY ON Damn, I *knew* I forgot to buy something on my last shopping trip to Nordstroms! Note to self: - buy gun I didn't know I

RE: job offer from SAUDI ARABIA

Totally agree with everything said here. I blame it all on lawyers and the media. I've got an idea - how about a bunch of us move our families to a secluded Pacific island with no lawyers or televisions. We'll sit around a monitor fully-cached databases with no users or

RE: job offer from SAUDI ARABIA

Only if you disregard the number of criminal acts that are twarted due to brandishment where the gun is never fired. Add in the fact that most people really don't want to shoot a criminal, they just want the criminal to leave. Paul Harvey(You know, the rest of the story, Good Day)

RE: Temporary files and Quick i/o

But you need new_file with specific length - let say 500M - how will you do it? Another way to do it - but may be long - is create normal tablespace (not temporary) with data files you need, then drop tablespace and then create temprary tablespace with reuse of created data files. Alex Hillman

RE: Temporary files and Quick i/o

As I mentioned in my previous email copying the file using cp after shutdwon normal will do this. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/18/01 9:35 AM I wonder if you could do something (big sort or temporary table etc) to force the space to be allocated

Re:RE: job offer from SAUDI ARABIA

No, it's a suburb of Boston Mass with a number of constantly drunk truck drivers who like to use New Hampshire Vermont as demolition courses. lock, load blow them to hell Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 5/17/2001 2:40

Re: What is the cost of replication?

Eric, My paper applies to all platforms as platform independence is one of the many strengths of replication. As to your websites... must be a Y-chromosome thing ;) Take care, -- Anita --- Eric D. Pierce [EMAIL PROTECTED] wrote: A., Just out of curiosity, is your paper pertinent to

Re: File size problem.

Jothish, 7.3.4 on Solaris doesn't support file sizes larger than 2GB except on raw partitions. I find the following note invaluable for file size issues. It also contains links to port-specific notes as well. Note: 62427.1 2Gb or Not 2Gb - File limits in Oracle HTH, -- Anita ---

RE: Temporary files and Quick i/o

Steve, The tip is part of Database creation--- Why Raw datafiles?. So if my database has been running for a while and has come back with a few unable to allocate extents in the temp tabalespace. I could convert that datafile to quick io as the full space is allocated. So it is not sparse

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

unfortunately no other result with ... grant analyze any -Ursprüngliche Nachricht- Von: Connor McDonald [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 18. Mai 2001 15:36 An: Multiple recipients of list ORACLE-L Betreff: Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE grant

RE: Would you increase the shared pool? --URGENT

Hi Steve, How can you say that the shared pool is too big in this case? According to your book ,I've done this: If this ratio (Flushed Chrunks/Pins and releases ) is more than 1 in 20 then the shared pool is probably too small. And if transient chunks is more than 3 times recurrent chunks it's

RE: newbie -PRIVILEGES question. Please help.

Hi all, I have a package created by user1, created a public synonym on the package, granted execute on this public synonym to a user_role. What the package does is: Creates a user (test_user) dynamically, also ties him with a profile and also grants the test_user the role above (user_role).

RE: job offer from SAUDI ARABIA

I think each country has pretty sides and bad sides. Weather in Saudi Arabia is perfect compared with Germany, but loosing the hand for the case you steel something worth of five bucks? Redicilous and not a good sign for tolerance and respecting each other in general. I know western cultures are

SQL Query to combine multiple rows into 1 ?

I've got a simple table with 2 columns: ID and Relation E.X. ID Relation --- 123 Sam 123 Bobby 123 Dani 234 Mary 234 Cindy 345 Steve 456 Karen 456 Gary 456 Wayne I'm trying to create a report using only ANSI SQL (no PL*SQL, or SQL*PLUS

RE: Temporary files and Quick i/o

Hi Johnson, I think I've fixed the web site to allow for this now. No, I'd say the bottom line is to use a raw tempfile. While following Waleed's idea of copying the file to make sure that it is not sparse would be safe, it is still contrary to what Veritas recommended. @ Regards, @ Steve

Re: OT - Books Covering Partitioning in 8i

What about Ian Abramson 's book on DATA WAREHOUSING ? I have not read it from cover to cover ( in scheduled readings) but from what I've seen I think is what you want. Luis Octavio [EMAIL PROTECTED] wrote: Listers, I might end up on a Data Warehouse and Data Mart project using 8i. I've

RE: OT: RE: job offer from SAUDI ARABIA

I'm not upset, Ross. Being from the most powerful (thanks to our fine people in the military), and generous (thanks to everyone), nation on earth we are used to being critizied by the nations we help (the dog that bites the hand that feeds it). I'm simply pointing out a fact that you seem to have

Re: job offer from SAUDI ARABIA

Am Freitag, 18. Mai 2001 15:30 schrieb Kevin Kostyszyn: Statistics from who? Actually most states that allow citizens to carry weapons for there own protection have seen a decline in muggings and things of that nature. A criminal is less likely to try and mug someone if the criminal thinks

Re: ....A drop schema script ??

Thank you Jared for the words of encouragement and specially for the SCRIPT Luis Octavio Jared Still wrote: Luis, Don't feel bad, this is a valid question. DROP USER CASCADE is not always the most efficient way to drop a user, especially a user with a large number of objects. I've had

adding columns to system tables

Does anyone know if it is 'safe' to add additional columns to user_tab_columns? I am running 8.1.5. I would use the new columns to tell the application software which columns on any one table are user editable by a dynamically generated dialog form. Thanks, Greg -- Please see the official

RE: job offer from SAUDI ARABIA

Interesting for the first email I recieved on list. heh. hey all. -Original Message- Sent: Friday, May 18, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Am Freitag, 18. Mai 2001 15:30 schrieb Kevin Kostyszyn: Statistics from who? Actually most states that allow citizens to

RE: job offer from SAUDI ARABIA

That would be Hear, hear, as in Hear [him|her]. I figure, even though this is off-topic, it's a mere drop in the ocean of OT posts on this list. -Original Message- Sent: Friday, May 18, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Here, here! RBG - Original Message

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

Set sql_trace on before running it and see which sys sql fails. Regards, Waleed -Original Message- Sent: Friday, May 18, 2001 10:31 AM To: Multiple recipients of list ORACLE-L unfortunately no other result with ... grant analyze any -Ursprüngliche Nachricht- Von: Connor

Re: Event ID 1008 in NT - Oracle 8.0.5

Hi Pat, Check the Oracle performance worksheet (which, I believe uses that dll) to see if it's running. You may have it scheduled to collect data every 15 minutes. HTH, -Rocky --- Piper, Pat [EMAIL PROTECTED] wrote: Good morning, I am getting the following error in the application event

RE: Temporary files and Quick i/o

No you don't. Just copy the file to the new file and the new file will be created notsparse. -Original Message- Sent: Friday, May 18, 2001 10:11 AM To: Multiple recipients of list ORACLE-L But you need new_file with specific length - let say 500M - how will you do it? Another way to

Re: Create Snapshot failed - why ?

Andreas, ORA-7445 is a very generic error and the arguments are frequently irrelevant. You should log a tar with support and upload the alert.log and trace files generated by the ORA-7445 errors. HTH, -- Anita --- Andreas Teich [EMAIL PROTECTED] wrote: Dear All, two days ago, we created

RE: adding columns to system tables

Absolutely NOT!!! As soon as you do that you are completely unsupported by Oracle and probably everyone else. Rick -Original Message- Sent: Friday, May 18, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Does anyone know if it is 'safe' to add additional columns to

RE: job offer from SAUDI ARABIA

I'm in -Original Message- [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Totally agree with everything said here. I blame it all on lawyers and the media. I've got an idea - how about a bunch of us move our families to a secluded

Re: adding columns to system tables

On Fri, 18 May 2001,Greg Schraiber scribbled on the wall in glitter crayon: -Does anyone know if it is 'safe' to add additional columns -to user_tab_columns? I am running 8.1.5. I would use the new -columns to tell the application software which columns on -any one table are user editable by a

RE: job offer from SAUDI ARABIA

Jim, Pacific Micronesia will be under water due to global warming. (there are many hits to choose from, but...) http://www.unescap.org/mced2000/pacific/SoE-pacific.htm Let's not go there until we have Amphibious SUVs. ( God forbid we change our way of life. ) - Ross WaterWorld Mohan ||

Re:adding columns to system tables

Greg, USER_TAB_COLUMNS is NOT a table but a complex view of several SYS tables. Consequently adding a column requires redefining the view (owner by sys to boot) and then if you ever have to re-run catalog.sql your change is gone. Not something I would do. Dick Goulet

RE: job offer from SAUDI ARABIA

Only to Americans. You can have Quebec though. -Original Message- Sent: Thursday, May 17, 2001 3:41 PM To: Multiple recipients of list ORACLE-L Isn't Canada a state in the north of the USA? grin, duck, and run like hell || -Original Message- || From: Kimberly Smith

Re: adding columns to system tables

Yes, you CAN add columns to the view as SYS. However, if you break something doing so, you aren't supported. Also any db upgrades will destroy your changes and invalidate any code that references it. Better idea might be to create a table with a similar key as user_tab_columns with your

Re:adding columns to system tables

Could you create a new and seperate view based on the code from the old one then add what you need? --- [EMAIL PROTECTED] wrote: Greg, USER_TAB_COLUMNS is NOT a table but a complex view of several SYS tables. Consequently adding a column requires redefining the view (owner by sys to

Check for number only

I have a table with a column of varchar2(50) datatype. We are building a new table and the values in this column should all be numbers. I need to query the table to find all rows which have a value in this column which is not a valid number. Table: circuit (circ_id (primary_key) number,

RE: job offer from SAUDI ARABIA

And sure, you can criticize, but only in America are you in danger of being run down or shot for having a bumper sticker expressing an opinion on politics or abortion or religion or NASCAR...I'm especially nervous now that Eric has told us that all these women are carrying guns now. :) I love

RE: ??? how to interpret query plan

Duh! sound of hand smacking forehead I didn't notice that there was no cost listed next to the COST= You're absolutely right. Of course a hint can still be used to change to COST, but certainly in this query it seems unlikely to be worthwhile unless there is a large %age of rows being returned

RE: job offer from SAUDI ARABIA

I just love these stats: The same number of people killed in Germany by Car accidents, is killed in the Staates by gun bullets. *rofl* [EMAIL PROTECTED] 05/18/01 10:51AM I think each country has pretty sides and bad sides. Weather in Saudi Arabia is perfect compared with Germany, but

Re: job offer from SAUDI ARABIA

Good, go back to your country and hide! [EMAIL PROTECTED] 05/18/01 11:11AM Am Freitag, 18. Mai 2001 15:30 schrieb Kevin Kostyszyn: Statistics from who? Actually most states that allow citizens to carry weapons for there own protection have seen a decline in muggings and things of that

RE: adding columns to system tables

Personally i wouldn't do that. How come you couldn't create another table or a view off of the user_tabl_columns and use that table instead? Kev -Original Message- Schraiber Sent: Friday, May 18, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Does anyone know if it is 'safe'

Re: SQL Query to combine multiple rows into 1 ?

The only way I know of to do this is with self-joins, and you have to have a known upper bound of the number of Relations per ID. An example (warning, untested, off the top of my head): select t1.id, t1.relation || ' ' || t2.relation || ' ' || t3.relation from relationtable t1, relationtable

RE: Check for number only

Glenn, something like ... where LTRIM (circ_num, '0123456789.') is not null HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of

RE: Temporary files and Quick i/o

I found this link: http://www.cpmc.columbia.edu:21168/techlib/qna/faxes/html/bak/bak16.htm Find this section: The Effect of Certain Commands on Sparse Files -Original Message- Sent: Friday, May 18, 2001 12:10 PM To: Multiple recipients of list ORACLE-L No you don't. Just copy the file

RE: job offer from SAUDI ARABIA

Chris, We knew you left LazyDBA... ;) - Kirti -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: job offer from SAUDI ARABIA Interesting for the

RE: job offer from SAUDI ARABIA

ahh, I don't actually know this figure off hand, but aren't there more people in the United States than there are in Germany? That would kind of balance out that statistic. There are definately some beautiful parts of the US, I love Minnesota, it's so nice up there. New York State Lovely!! Not

Re: OT: RE: job offer from SAUDI ARABIA

Thanks for this response. I rest my case. -Rocky --- Mohan, Ross [EMAIL PROTECTED] wrote: || -Original Message- || From: Rocky Welch [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 18, 2001 10:57 AM || To: Multiple recipients of list ORACLE-L || Subject: I am such a freaking

Tivoli??

Hi Friends Could you people shed some light on tool Tivoli, Like what is functionality,purpose and more. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the

RE: Check for number only

Try TO_NUMBER(circ_num) and exception INVALID_NUMBER Jan Pruner -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 6:17 PM To: Multiple recipients of list ORACLE-L Subject: Check for number only I have a table with a column of

RE: Check for number only

Ooh, I like this one better! Disregard mine, I hate all the characters you have to put into replace(). Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED]

RE: job offer from SAUDI ARABIA

Not hardly. You've got a good chance of something happening in quite a few countries. Maybe not shot, but beaten, stabbed etc. Pick the divisive issue and try it in Ireland, Germany, Italy, Spain, Turkey, Greece, UK(probably, I just can't think of a hot issue) etc. Everyone else is just as

RE: job offer from SAUDI ARABIA

My brother in law is a Canuck, a Newfy. Real solid guy, glad to have him in the family. Really pitches in with the single malts. Helps me with geography and pronounciation, too. A. || -Original Message- || From: Kimberly Smith [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 18, 2001

OT: RE: job offer from SAUDI ARABIA

|| -Original Message- || From: Rocky Welch [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 18, 2001 10:57 AM || To: Multiple recipients of list ORACLE-L || Subject: I am such a freaking ignorant redneck! || || || I'm not upset, Ross. Being from the most powerful (thanks to || our fine

RE: adding columns to system tables

Greg, It is 'safe' in that you won't die or get injured. However, your database may and your support from Oracle certainly will. Don't even think about it. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas

RE: Temporary files and Quick i/o

Hi Johnson, No, that's a datafile tablespace with temporary contents. A tempfile tablespace is inherently temporary. Check the documentation for the difference between ... CREATE TABLESPACE ... TEMPORARY and CREATE TEMPORARY TABLESPACE ... @ Regards, @ Steve Adams @

Re: Check for number only

You could always write your own function. Or you could do something using the replace() function, maybe like this (again, untested): select circ_id, circ_num from circuit where replace(circ_num, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890',

RE: OT: RE: job offer from SAUDI ARABIA

geez louise guys! take it far back enough and EVERYONE has to leave here... I'm only second generation American. And Ross IS from this country so exactly where is he supposed to go back to? 1st Amendment: freedom of speech. Doesn't mean you have to like what the other says, you just

Hi need some please

Hi All, Does anyone have a script that will compare table_a to table_b and delete the dups in table_b, or a site that might have one? Thanks Very Much for any ideas. -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL

Re: job offer from SAUDI ARABIA

Welcome back. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 18, 2001 11:26 AM Interesting for the first email I recieved on list. heh. hey all.

Re: View v_$session

Did you run catproc? Just a thotrbg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 4:31 PM Hi guys! Since the upgrade of my Oracle server to the version 8.1.6 (I applied all the patches) and the rebuild of the

Oracle and Lawson

Hello All, I just inherited an Oracle database which runs Lawson CRM application. The database is extremely slow because there is high insert/delete activity in the tables which are highly accessed. Is there a solution to compress extents without using exp/imp utilities. Anyone on the list using

RE: job offer from SAUDI ARABIA

Heyas Kirti, yes I have. I won't go into why, alot of people know why I am sure but I said I won't go into it. I probably won't respond as much as I did on lazy because I want to put some effort into my site, but I will surely help out here and there when I can. And I won't even try to sell it

RE: job offer from SAUDI ARABIA

I think the world is scary sometimes. It's all relative. [EMAIL PROTECTED] 05/18/01 01:30PM And sure, you can criticize, but only in America are you in danger of being run down or shot for having a bumper sticker expressing an opinion on politics or abortion or religion or NASCAR...I'm

RE: job offer from SAUDI ARABIA

Hi All, We're not allowed to talk about that on the other list! I was trying to reply to the thread Christopher started about how to unsubscribe, but kept getting bogus replies that looked like list mails but were not really. It took me 7 attempts to work out that it was the thread title Bye

Re: job offer from SAUDI ARABIA

Since it is Friday, I'll share something that all the talk of going back to where you came from brought to mind. When the 1990 US census forms came out we got a call from our younger son where he said on the order of the following: I got the long form. They are asking me for ethnicity and I

Re: OT: RE: job offer from SAUDI ARABIA

On Fri, 18 May 2001,Rocky Welch scribbled on the wall in glitter crayon: -Thanks for this response. I rest my case. - --Rocky Ladies and Gentlemen: It appears that this issue has in fact become a bit derisive. I do understand that you may wish to resolve it but I request that you do so among

RE: job offer from SAUDI ARABIA

On Fri, 18 May 2001,Deshpande, Kirti scribbled on the wall in glitter crayon: -Chris, - - We knew you left LazyDBA... ;) - -- Kirti Say Chris, welcome to the asylum.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED]

RE: job offer from SAUDI ARABIA

I hope the original poster found the answer for his question. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: job offer from SAUDI ARABIA

On Fri, 18 May 2001,Khedr, Waleed scribbled on the wall in glitter crayon: -I hope the original poster found the answer for his question. - Answers? We're supposed to give answers? How come nobody told me?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL

RE: job offer from SAUDI ARABIA

LoL!! I like the idea of airlifting in our Urban Assault Vehicles. We can establish a beachhead at 0600. Recon should take the better part of the morning, and we can spend the rest of the time indoctrinating the locals. Let's rename each of the natives with a keyword from the Oracle reserved

RE: job offer from SAUDI ARABIA

... and hide good 'cause we're gonna getcha. What's going on here? Does the freedom to own a gun supercede the freedom to disagree with the freedom to own a gun? -Original Message- Sent: Friday, May 18, 2001 12:53 PM To: Multiple recipients of list ORACLE-L Good, go back to your

RE: RE: job offer from SAUDI ARABIA

GOOD LORD! -Original Message- Sent: Friday, May 18, 2001 1:36 PM To: Multiple recipients of list ORACLE-L || -Original Message- || From: Rocky Welch [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 18, 2001 10:57 AM || To: Multiple recipients of list ORACLE-L || Subject: I

RE: OT: RE: job offer from SAUDI ARABIA

Spoken like a gentlemen, which is more than I found momentarily capable of. I not only rest my case, but withdraw it for considerable rework. - Ross -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/18/2001 2:31 PM Thanks for this response. I rest my case. -Rocky

RE: job offer from SAUDI ARABIA

That sounds great! So far it's me, you, and Kevin. I think the three of us can take the island. I drive a Land Rover, so I'll bring it. Once we have raised our flag at HQ and have all the locals assimilated, we can send for our families. I like the idea of naming the natives with

  1   2   >