FAQ

Oracle > oracle-l > December 2001

Search Discussions

487 discussions - 1,868 posts

  • 32

    help

    HELP [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase ...
    Boag, Merridy [SMTP:merridy.boag_at_m-co.co.nz]Boag, Merridy [SMTP:merridy.boag_at_m-co.co.nz]
    Dec 17, 2001 at 9:21 pm
    Dec 21, 2001 at 2:30 am
  • Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions were asked to me and I could not able to answer to the employers satsifaction. He asked ...
    Dharani RaviDharani Ravi
    Dec 24, 2001 at 9:26 am
    Dec 28, 2001 at 4:14 am
  • In our shop we've tried the cross training tact. Problem was that those who accepted the challenge could not take the heat, so they left the kitchen. Damn!!! Dick Goulet ____________________Reply ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Dec 27, 2001 at 3:10 pm
    Dec 31, 2001 at 3:42 pm
  • Hi Lisa, CA Unicenter has been a source of many nightmares and sleepless nights in the past for me. I was very glad when I quit that job... Just my .02 Lisa Koivu Certified Monkey Fairfield Resorts, ...
    Koivu, LisaKoivu, Lisa
    Dec 4, 2001 at 8:53 pm
    Dec 7, 2001 at 3:44 pm
  • Will 9i run on XP Professional client? And, no I am not interested in putting Linux on my home PC at this time. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, ...
    Ken JanuszKen Janusz
    Dec 29, 2001 at 12:57 pm
    Dec 31, 2001 at 2:15 pm
  • This question is a little off the mark. I will be ordering a new Dell PC (8200) in the near future. I would like to know which OS I should go with. XP Professional or W2000? Any suggestions? Anyone ...
    Ken JanuszKen Janusz
    Dec 26, 2001 at 4:33 pm
    Dec 27, 2001 at 1:46 pm
  • Group, Does anyone have some SQL handy that will re-compile INVALID objects for a given user, that they would be willing to share?? TIA Al Rusnak 804-734-8453 rusnakga_at_hqlee.deca.mil -- Please see ...
    Rusnak, George A.Rusnak, George A.
    Dec 17, 2001 at 6:29 pm
    Dec 18, 2001 at 10:42 am
  • I have a kshell script that I am trying to perform an oracle operation. Everything works fine in the script excpet cleanup. One section of the script spools off a monitor job that watches the script ...
    Kevin LangeKevin Lange
    Dec 10, 2001 at 5:18 pm
    Dec 11, 2001 at 2:12 am
  • Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a "DBA Weakest Link" ...
    Paul ValleePaul Vallee
    Dec 7, 2001 at 2:49 pm
    Dec 8, 2001 at 3:28 pm
  • We are in the process of buying new hardware, and our original configuration called for 10 18 GB drives in a Hitachi disk array cabinet. We are getting some sales pressure to change this to 5 36 GB ...
    Steve McClureSteve McClure
    Dec 18, 2001 at 7:16 pm
    Dec 19, 2001 at 4:33 pm
  • Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace without recreating the DB? For some reason the person who created the DB I am working on set PCTINCREASE to 50 (or didn't ...
    Ken JanuszKen Janusz
    Dec 17, 2001 at 3:31 pm
    Dec 18, 2001 at 9:56 pm
  • Hello all, Why cannot I do :- sqlplus -s scott/tiger select * from emp; or sqlplus -s scott/tiger "select * from emp;" Both the cases I get :- Usage: SQLPLUS [] [[/] [@]] [@ [] [] ...] where ::= { -s ...
    Viraj LuthraViraj Luthra
    Dec 4, 2001 at 5:21 am
    Dec 5, 2001 at 12:17 am
  • I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about ...
    Ken JanuszKen Janusz
    Dec 21, 2001 at 3:21 pm
    Dec 26, 2001 at 9:57 pm
  • 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient ...
    Ken JanuszKen Janusz
    Dec 7, 2001 at 5:11 pm
    Dec 11, 2001 at 4:06 am
  • Hi Everyone! I am trying to empty a database with some very large tables so I can import it again. Which is faster, truncating or dropping the tables? Thanks in advance, Ruth -- Please see the ...
    Ruth GramoliniRuth Gramolini
    Dec 10, 2001 at 5:01 pm
    Dec 10, 2001 at 8:07 pm
  • In report.txt we are getting the wait "buffer busy wait" _& wait on "latch free" for "cache buffer chain" Could an excessively Large db_block_buffer cause this ? NOTE - Transaction OLTP in nature ...
    VIVEK_SHARMAVIVEK_SHARMA
    Dec 4, 2001 at 12:01 pm
    Dec 6, 2001 at 8:18 pm
  • Hi Import is taking much time.How to eliminate that? Thanks -seema Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com ...
    Seema SinghSeema Singh
    Dec 21, 2001 at 8:35 am
    Dec 22, 2001 at 1:09 am
  • I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message. I can sign on svrmgr and through sqlplus with no problems. Any ideas? Thanks, ...
    Burton, Laura L.Burton, Laura L.
    Dec 12, 2001 at 10:50 pm
    Dec 14, 2001 at 7:29 am
  • Hi Gurus: It is possible to exp database from aix 4.3.3. oracle 8.0.5.1 and imp to Sun Soloris 2.7 Oracle 8.1.7 I have only done on same os. env before. Thanks in advance Mitchell -- Please see the ...
    MitchellMitchell
    Dec 12, 2001 at 5:49 pm
    Dec 12, 2001 at 11:04 pm
  • ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard INET ...
    Jeff WiegardJeff Wiegard
    Dec 10, 2001 at 7:43 pm
    Dec 11, 2001 at 8:08 pm
  • Informal survey: Datawarehousing. Limiting Assumption: "A necessary and sufficient condition for defining something to be a datawarehouse is the amount of data to be stored." Question/Poll: Given the ...
    Mohan, RossMohan, Ross
    Dec 6, 2001 at 10:44 pm
    Dec 10, 2001 at 3:06 pm
  • Happy Holidays to everybody. We have three triggers (all BEFORE EACH ROW on INSERT ) on a table, is there anyway we can control which one fires first,second, third, ...... n th Thanks Darren Darren ...
    Browett, DarrenBrowett, Darren
    Dec 27, 2001 at 9:50 pm
    Dec 31, 2001 at 5:26 pm
  • Hi Gurus How to make deletetion of millions rows faster? Please suggest. Thx Seema Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L ...
    Seema SinghSeema Singh
    Dec 27, 2001 at 8:12 pm
    Dec 28, 2001 at 6:55 am
  • Sorry for the cross post if you are the other big list. I am having some trouble finding a solution to a problem. This is specifically AIX related. Here is the gist. Any large sort or import appears ...
    Post, EthanPost, Ethan
    Dec 20, 2001 at 7:01 pm
    Dec 21, 2001 at 5:35 pm
  • Hi. This is just to thank all who replied to my post. Based on what I read, I have got two different ways of calculating that number and they seem to produce the same result. thank you all (you know ...
    Gene GurevichGene Gurevich
    Dec 18, 2001 at 1:19 pm
    Dec 19, 2001 at 9:41 pm
  • Hi all: Is there a way for me to see how many blocks under the HWM are unused? thanks Gene
    Gene GurevichGene Gurevich
    Dec 17, 2001 at 8:12 pm
    Dec 18, 2001 at 2:20 am
  • Is it possible to create a database without using dbassist ? Gavin Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Saturday, December 15, 2001 5:25 PM -- Please see the ...
    Gavin D'melloGavin D'mello
    Dec 15, 2001 at 3:07 pm
    Dec 17, 2001 at 1:35 pm
  • Why??? -----Original Message----- Sent: Monday, December 03, 2001 5:33 PM To: Multiple recipients of list ORACLE-L future re Haven't heard myself, but I hope this is true. Please, please, please let ...
    Khedr, WaleedKhedr, Waleed
    Dec 4, 2001 at 12:07 am
    Dec 5, 2001 at 1:20 am
  • Where can I find the total size of my DB? I have not found anything in the DBA_ views or my documentation. Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken ...
    Ken JanuszKen Janusz
    Dec 31, 2001 at 4:30 pm
    Dec 31, 2001 at 11:50 pm
  • I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights ...
    TomasTomas
    Dec 20, 2001 at 10:12 pm
    Dec 27, 2001 at 8:22 pm
  • Hi all, I am investigating using dbms_obfuscation_toolkit in my application. Now, I need a key to encrypt and decrypt the key. The question is how to protect the key? The data will be accessed from ...
    Jamadagni, RajendraJamadagni, Rajendra
    Dec 18, 2001 at 4:39 pm
    Dec 19, 2001 at 7:04 pm
  • I have just heard today that an external consultant, who is coming to upgrade software for our Student Records system next week, wants to unload the live, test and training databases, and recreate ...
    Docherty, HeatherDocherty, Heather
    Dec 14, 2001 at 3:55 pm
    Dec 17, 2001 at 1:38 am
  • Something I learned today, but haven't seen it documented anywhere and would like to see whether anybody has come across it. We have a Sun server (call it oracle.acme.com). It came to life by ...
    Djordje JankovicDjordje Jankovic
    Dec 11, 2001 at 3:10 pm
    Dec 12, 2001 at 6:00 pm
  • When I run this code both columns I get no rows returned. When I do a desc on one of the tables I see both columns. So, why am I not getting any data? select table_name, column_name from ...
    Ken JanuszKen Janusz
    Dec 11, 2001 at 3:59 pm
    Dec 11, 2001 at 5:31 pm
  • Whenever I discuss disk waits with my system administrator, I always get the reply that "the RAID system isn't anywhere near its rated throughput". Maybe I'm wrong, but I don't see any of the tuning ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Dec 7, 2001 at 5:33 pm
    Dec 11, 2001 at 2:44 pm
  • When you alter a user's password, what table does it update? I need to 'restore' a password for a user back to what it was before I changed it, but do not know what it was. Any ideas?? Can this be ...
    Burton, Laura L.Burton, Laura L.
    Dec 6, 2001 at 11:05 pm
    Dec 7, 2001 at 9:48 pm
  • May be odd question, but I realy need to do this, I want to revoke the privilege of the schema owner. I mean give only select priv to the schema owner. Thanks Hamid Alavi Office 818 737-0526 Cell 818 ...
    Hamid AlaviHamid Alavi
    Dec 5, 2001 at 7:43 pm
    Dec 7, 2001 at 5:51 pm
  • Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the ...
    LBanzali_at_aol.comLBanzali_at_aol.com
    Dec 24, 2001 at 7:45 am
    Dec 27, 2001 at 11:06 pm
  • Hi List, What is wrong with this package, I compared it to one example in a book and looks equal, but still get an error. CREATE OR REPLACE PACKAGE MANTENIMIENTO_COMPROBANTES AS TYPE ...
    Ramon EstevezRamon Estevez
    Dec 17, 2001 at 3:49 pm
    Dec 19, 2001 at 9:10 pm
  • The DBA of one of my customers tried to run one week ago dbms_stats() to analyse all indexed columns. The result was that all queries ended with ORA-00600. As trace files were indicating queries on ...
    Stephane FaroultStephane Faroult
    Dec 17, 2001 at 11:35 am
    Dec 17, 2001 at 10:07 pm
  • I am getting the following error for this line of code in my control file Any ideas of how I can get around this? When I try a conventional path load I get a FK constraint error (not on this field) ...
    Ken JanuszKen Janusz
    Dec 13, 2001 at 10:37 pm
    Dec 14, 2001 at 5:21 pm
  • List, Received this the the SearchDatabase org today. I thought some of you might find it usefull. ROR mª¿ªm ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja Here's a quick tip: The installation of ...
    Ron RogersRon Rogers
    Dec 6, 2001 at 10:05 pm
    Dec 14, 2001 at 10:28 am
  • Hi all, Can someone recommend good unix mailing list by the way how to check the existence of a file ? My logic : if (findThisFile(/tmp/myfile.txt) == 0) echo "the file is exists" else echo "file not ...
    Sinard XingSinard Xing
    Dec 5, 2001 at 8:30 am
    Dec 6, 2001 at 11:57 pm
  • Good morning all - I've been practicing rman restores. It's a lot easier than I originally thought. I've noticed that when you restore and the arclogs are needed, it restores them. Which is ...
    Koivu, LisaKoivu, Lisa
    Dec 3, 2001 at 3:56 pm
    Dec 4, 2001 at 3:08 pm
  • Here is the background of the stiuation I am facing. We are piloting a application that uses a hybred store and forward system to aggregate all of our disparate student data into one central ...
    Tom SchrueferTom Schruefer
    Dec 31, 2001 at 3:52 pm
    Dec 31, 2001 at 6:24 pm
  • Here's a paste from the $ORACLE_HOME/rdbms/admin/dbmsutil.sql script: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) Not only do they want to ...
    Orr, SteveOrr, Steve
    Dec 26, 2001 at 8:22 pm
    Dec 28, 2001 at 3:55 pm
  • Oh, very interesting. Thanks. http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme I'll take a look and add that to my Perl Whirl talk. Tim. [cross-posted to oracle-l and ...
    Tim BunceTim Bunce
    Dec 5, 2001 at 1:13 am
    Dec 28, 2001 at 12:08 am
  • Hi, I am trying to retrieve objects from an ORACLE 8i database using OCI. I have attached some code that I wrote for the same but it fails at the OCIStmtFetch call with the error ORA-00932 ...
    Siddharth aggarwalSiddharth aggarwal
    Dec 25, 2001 at 4:36 am
    Dec 26, 2001 at 5:24 am
  • Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I ...
    Witold IwaniecWitold Iwaniec
    Dec 21, 2001 at 3:53 pm
    Dec 22, 2001 at 8:14 pm
  • -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: SamB_at_cpas.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- ...
    Sam BootsmaSam Bootsma
    Dec 20, 2001 at 6:52 pm
    Dec 21, 2001 at 10:23 am
Dec 2001
12345…10
Group Navigation
period‹ prev | Dec 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions487
posts1,868
users364
websiteoracle.com

364 users for December 2001

Jared.Still_at_radisys.com: 88 posts Ken Janusz: 61 posts Mohan, Ross: 46 posts Kimberly Smith: 44 posts Rachel Carmichael: 41 posts DENNIS WILLIAMS: 34 posts Mercadante, Thomas F: 30 posts Scott Shafer: 30 posts Stephane Faroult: 29 posts Jamadagni, Rajendra: 28 posts Jared Still: 28 posts Tatireddy, Shrinivas (MED, Keane): 26 posts Mark Leith: 22 posts Boivin, Patrice J: 20 posts Connor McDonald: 20 posts Joe Testa: 20 posts Khedr, Waleed: 20 posts Hemantchitale_at_charteredsemi.com: 19 posts SARKAR, Samir: 19 posts Dgoulet_at_vicr.com: 18 posts
show more
Archives