Re: sqlloader stops
If I execute one load at the time maually it loads fine. It gives me hard time when I try to run multiple loads(one after another) through the batch file. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 9:05 PM How about using some GUI tool (or even SQL) to see what SQL its running, if any, and what counters and waits are incrementing... Good luck, keep in touch :-) Yosi [EMAIL PROTECTED] wrote: Thanks Yosi. No, that is not the case..:-( -Original Message- Sent: Tuesday, August 07, 2001 5:37 PM To: Multiple recipients of list ORACLE-L Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: Hi List, I have another problem. I have a process that loads multiple (~ 20 ) files through sqlloader. It works fine on other servers. There is this one server that is giving me a hard time. It loads 3 files and then stops. I commented out the third call to sqlloader thinking may be there is something wrong with a third text file. It loaded 3 files again and stopped on the forth one. There is nothing in alert log (no errors). Also, there is enough space on the drive where the logs are going. Oracle 7.3.4 on NT. If anyone has any idea please let me know... Lyuda Hoska (703)797-8656 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: completely off-topic question...
I've heard (did I hear it from this list?I think I did) it stands for 'Hope It Helps'. Michael, if you'renewto this list be prepared for ajourney HTH, Lyuda - Original Message - From: Michael To: Multiple recipients of list ORACLE-L Sent: Thursday, August 02, 2001 8:45 PM Subject: completely off-topic question... ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks, Michael.
Re: huge datafiles/need help
Thank you everyone who replied. All suggestions were very helpful. I am bebuilding my indexes in a different tablespace. It runs very very slow.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 3:51 PM Lyuda; 1. Create a new tablespace for the indexes on a seperate drive. Make sure you do this with a much more reasonable datafile size. (Watch it here maybe they did the big size because they were running out of possible files -- see the max_datafiles parm on the Create Database command) 2. Rebuild the indexes over into the new tablespace. Make sure your initial paramater fits in the initial size of the data files. 3. Drop your old Index Tablespace. As for your ALTER DATABASE DATAFILE RESIZE ... goes; thats what happens when you use all your space. I would suggest at some point to take an outage and reorg that tablespace containing the table as well to get its files down in to a resonably managed size. -Original Message- Sent: Thursday, August 02, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: huge datafiles/need help
I meant EBUILDING. That is what a long day of slow rebuilding indexes can do to you.:-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 9:32 PM Thank you everyone who replied. All suggestions were very helpful. I am bebuilding my indexes in a different tablespace. It runs very very slow.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 02, 2001 3:51 PM Lyuda; 1. Create a new tablespace for the indexes on a seperate drive. Make sure you do this with a much more reasonable datafile size. (Watch it here maybe they did the big size because they were running out of possible files -- see the max_datafiles parm on the Create Database command) 2. Rebuild the indexes over into the new tablespace. Make sure your initial paramater fits in the initial size of the data files. 3. Drop your old Index Tablespace. As for your ALTER DATABASE DATAFILE RESIZE ... goes; thats what happens when you use all your space. I would suggest at some point to take an outage and reorg that tablespace containing the table as well to get its files down in to a resonably managed size. -Original Message- Sent: Thursday, August 02, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Hi List, I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask me who created such a file because I don't know. I am trying to rescue the database that has multiple problems. Something you've never seen before. Bye the way, did anyone ever run a test how much stuff you can put on your disc before it dyes? Well, yesterday I found a disc which was 99.07 % full. Anyway... The tablespace is ~ 50 % free. The bad news is it doesn't let me to reduce the size of the datafiles by using 'alter database datafile ... resize...';. That tablespace contains 32 indexes. Some of them are as large as 600 -800 M. I need to develop a plan of attack. My options are: 1) drop and recreate the indexes; 2) rebuild the indexes in different tablespace/tablespaces; 3) export/import indexes or may be even tablespace all at once. Is there anyone who has done something similar before? All suggestions are greatly appreciated. That database is screaming for help!! It running Oracle 8.1.6 on NT. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Re: completely off-topic question...
This Is a simple one: BTW-bye the way. I visited www.acronymfinder.com. Here is something I wanted to share. /SOS [not an acronym] a common misconception is that SOS means Save Our Ship/Souls (a distress call); the letters don't actually stand for anything./ I always wanted to know what SOS really meant. It is not an acronym at all. Cool site. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 4:56 AM ROFL - rolling on the floor laughing I believe there actually is a web site somewhere that keeps track of these acronyms. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Babette Turner-Underwood [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 2:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: completely off-topic question... Or Happy To Help ... Also ... YMMV - Your Mileage May Vary (this took me FOREVER to guess) LOL - laughing out loud RTM - read the manual RTFM - read the Fine manual IMHO - in my humble opinion OR in my honest opinion OT - Off topic Babette - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 1:02 AM hope this helps hth yosi Michael wrote: ...which means it's probably going to start a great big thread :) I see a lot of emails with HTH on them, seemingly some sort of way to say thankyou or something... as they're always at the end of somebodies message right before they sign off their name.. I have pondered, and pondered as to what HTH could stand for, could somebody be so kind as to fill me in ? Thanks,Michael. -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Virus again
Yes, no e-mail from the list contains virus. The case is even worse: he is not attacking the list; he attacks us(users of the list) personally one by one. There is definately an association between this list and the person speading the virus because virus comes as a reply to the list posts. I'd like to ask a question: are our e-mail addresses widely available to anyone and there is nothing we can do about it? I had an impression it wasn't the case. I would call it privacy violation(very strong statement, probably too strong) or using technical list to do his durty business(more applicable to the situation). From now on I will think twice before signing up for another list, posting messages, or replying to them. Yes, you're right I would not block my customers or friends e-mails because people who have any respect for themselves would clean their machine up after becoming aware of the virus. The problem here is that person has been notified by number of people and he keeps doing it. So, regardless on us individually blocking his e-mails we need to get to the root of this problem and BLOCK that person's access to the list. It becomes clear he is doing it deliberatly. Or you would say: 'Let him do it?' That would not be a good sign - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 2:21 PM The boys in network admin initially said they would strip the virus-now they have said that they are going to block email from the list. The boys in network admin may be barking up the wrong tree. As I understand it, no email from the list contains a virus. Even if the virus did come from the list, what kind of solution is this? If someone from your accounting department sends you an email that has a virus are they going to block all email from accounting? If a customer sends an email with a virus are they going to block all email from customers? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT 24 x 7 on NT - ot
Title: RE: OT 24 x 7 on NT - ot Alex, I would even buy your bookto support your efforts. :-) - Original Message - From: Hillman, Alex To: Multiple recipients of list ORACLE-L Sent: Thursday, June 28, 2001 3:15 PM Subject: RE: OT 24 x 7 on NT - ot At least your memory is good :-) Alex Hillman -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 5:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT 24 x 7 on NT - ot Lisa, my fine-feathered friend, i would have no idea what to write about. Clearly not oracle. And since i'd probably self-publish, I'd likely have to go mano a mano with Alex Hillman on the printing presses. It wouldn't be pretty, and besides, I still owe him a lunch. So...that leaves not much in the hopper. I am open to suggestions that do not involve me wearing speedos, passing by mirrors, or being available while the sun is up. sigh Ah well, back to tweaking the nanokernel assembler extensions for the russian mafia. - Ross -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 4:38 PMTo: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'Subject: RE: OT 24 x 7 on NT - ot Ross, have you ever considered becoming an author? I would buy your book :) Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Subject: OT 24 x 7 on NT? Everything. The whole Coast Guard. Everything just turned blue and froze. Then, someone using oracle with "read consistency" was able to order a replacement ship simultaneously with the guy who was removing the last ship from inventory, but fortunately for the USCG, Oracle doesn't let "writers block readers", so the order went through but was never fulfilled. Now, they're running DB2 on VMS on realtime nanokernel OS kiosks. -Original Message- Sent: Thursday, June 28, 2001 3:20 PM To: Multiple recipients of list ORACLE-L The software or the ship? --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, June 28, 2001 12:56 PM To: Multiple recipients of list ORACLE-L On one of their newer ships they were using NT, and it froze up a couple of times. -Original Message- Sent: Thursday, June 28, 2001 1:36 PM To: Multiple recipients of list ORACLE-L The Coast guard uses Unisys, too...but i don't know where NT fits in to their front line systems. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Virus again
If I get e-mail from the customer with virus I'll inform him/her about the virus. 99.9% of customers would eliminate the source of the virus. If they refuse to do so I would probably not want to deal with them even as customers. It would not make any impact on the business if I lost 0.1% of my customers and that action would actualy work for me because all good people out there would know I don't challenge my values. It is like going to an unsanitized doctor's office, catching something there and doctor's claiming: 'you didn't get it from my office you got it from one of my patients'. That is what doesn't make scence I can even handle annoying recruter's e-mails but not e-mails with viruses. Noone asks you to block ALL e-mails but when the source of inconvinience has been identified why not to take care of it? Anyway, I am giving up. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 4:56 PM There is definately an association between this list and the person The point remains that such a broad solution makes no sense. If you get an email from a customer and it has a virus, you could say there is definitely an association between our customers and email with viruses. But are you going to stop all email from customers? How about just stopping all email? That would solve the problem. Perhaps the boys in network admin need to work on a more focused solution instead of cutting off a broad source of email. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to drop unique index
Suggestion given by Magesh should work for a non-constraint index. If it is index created by Oracle during the time when you created your unique constraint you won't be able to get rid of that index until you eliminate your constraint. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 3:31 AM Try out this Drop index U_SPYADH_2 ; Regards Magesh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 5:50 PM Hi Gurus, I tried to drop unique index using ALTER TABLE table_name DROP UNIQUE (column_name); unsuccessfully. How should I drop the unique index ? Please advise. Thanks. SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME COLUMN_NAME -- -- -- U_SPYADH_2 SPY_ADHOC_PAYMENT STDNAME SQL SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_OWNERTABLE_NAME UNIQUENES -- -- U_SPYADH_2 SPY SPY_ADHOC_PAYMENT UNIQUE SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME); ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME) * ERROR at line 1: ORA-02442: Cannot drop nonexistent unique key SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2; ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2 * ERROR at line 1: ORA-02443: Cannot drop constraint - nonexistent constraint Regds, New Bee -Original Message- From: Manivannan.M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: catrep.sql Hi It will be there under $ORACLE_HOME/rdbms/admin regards, Manivannan.M -- -- -- On Tue, 29 May 2001, Timajo, Joel - Equicom wrote: hello oracle gurus! i just tried a default installation of oracle 8.0.6 to our hp-unix machine. i followed step by step the procedures as stated in the oracle installation guide. my problem is when it comes to the step (pp 4-2 of the installation guide) that says run the catrep.sql. where can i find this sql script? thanks! oracle newbie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: magesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public