Search Discussions

507 discussions - 2,101 posts

  • Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is ...
    Rachel CarmichaelRachel Carmichael
    Sep 25, 2002 at 4:33 pm
    Sep 30, 2002 at 5:09 pm
  • Hi people... What to do if I have LOST ALL REDO LOGS and i don´t have any backup? Thanks in advance! ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: Gilberto Gampert Universidade de ...
    Gilberto GampertGilberto Gampert
    Sep 18, 2002 at 8:30 pm
    Sep 23, 2002 at 2:08 pm
  • Hi Gurus, In one of our insert intensive application we are inserting around 3-4 million rows / hour. Also this app needs to do a count(*) of the tables every 10 minutes for verifying some ...
    Sep 19, 2002 at 6:28 pm
    Sep 23, 2002 at 6:38 am
  • I'm trying to justify hiring another DBA, and management wants more justification. I have put together the usual reasons, but they want "Industry Standards", like how many Databases can one DBA ...
    Tony ynotTony ynot
    Sep 24, 2002 at 1:43 am
    Sep 27, 2002 at 5:45 pm
  • You have my profound sympathies, having been there and done that. Russ -----Original Message----- From: Jared.Still_at_radisys.com Sent: Tuesday, September 10, 2002 4:29 PM To: Multiple recipients of ...
    Brooks, RussBrooks, Russ
    Sep 10, 2002 at 8:10 pm
    Sep 14, 2002 at 12:48 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Hi All, We have a table which can contain more than half a million records. When we try to insert some 10k records in the empty table it ...
    Marul MehtaMarul Mehta
    Sep 4, 2002 at 6:53 am
    Sep 20, 2002 at 11:23 am
  • time for me to ask the experts again. My data warehouse will be 9.2, with all locally managed tablespaces. We will be following what I have taken to calling the "Goldilocks" principle -- that of ...
    Rachel CarmichaelRachel Carmichael
    Sep 3, 2002 at 3:48 pm
    Sep 4, 2002 at 9:23 pm
  • This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages ...
    Sep 10, 2002 at 2:54 pm
    Sep 11, 2002 at 1:16 pm
  • Interested candidates reply to: resumes_at_knowltongroup.com Consulting Position Title: Oracle DBA/Developer Duties and Responsibilities: This position is a conversion to an Oracle Data warehouse ...
    Bill ChristisonBill Christison
    Sep 17, 2002 at 7:14 pm
    Sep 20, 2002 at 5:04 pm
  • There are quite a few restrictions on function-based indexes. The Oracle SQL guide lists them all. Have you checked to ensure that you're following all the rules? Jared Content-Type: text/html ...
    Jared StillJared Still
    Sep 3, 2002 at 9:43 pm
    Sep 6, 2002 at 5:23 pm
  • We are planning to move to raw devices for all our existing file systems. Our database size is around 400 Gig. What is the recommended method that you guys feel is best as far as time required to ...
    Sep 19, 2002 at 6:38 pm
    Sep 23, 2002 at 8:13 pm
  • Hi all, I am stuck on this restore for two days and Oracle support seems to offering little help. I seem to be doing everything according to manuals and metalink notes but am not able to do the ...
    Johnson PoovathummoottilJohnson Poovathummoottil
    Sep 17, 2002 at 2:23 pm
    Sep 18, 2002 at 7:35 pm
  • Does anyone have a script that will write another script to recreate a particular database quickly with all the info specific to that particular database? Seems to me that I have seen this somewhere ...
    Connie MillikenConnie Milliken
    Sep 6, 2002 at 9:28 pm
    Sep 9, 2002 at 7:28 pm
  • Does anyone here knows how to setup the connections to the database server without using tnsnames.ora? Our DBA didn't use it. But I don't know how and why? Could anyone tell me the other options? Cc ...
    CC HarvestCC Harvest
    Sep 6, 2002 at 1:23 am
    Sep 9, 2002 at 5:53 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" OT: MIcrosoft Blackmail Thomas, Don't get mad - remember, it's not personal, it's just "the bidness". Remember, sales-dweebs can say ...
    Mercadante, Thomas FMercadante, Thomas F
    Sep 26, 2002 at 12:58 pm
    Sep 30, 2002 at 5:18 pm
  • Hello all, DB: 8i OS: solaris 2.7 can somebody post me reply for this. is there any quick way to find which datablocks are corrupted in my oracle database . ( other than dbverify and rman backup. ) ...
    Kommareddy sreenivasaKommareddy sreenivasa
    Sep 23, 2002 at 10:03 am
    Sep 24, 2002 at 7:23 pm
  • 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. Ray Stell ...
    Ray StellRay Stell
    Sep 17, 2002 at 6:13 pm
    Sep 18, 2002 at 5:43 pm
  • This really is my week for asking for help. We have a project lead/developer here who wants to use a java stored procedure, wrapped in a PL/SQL function, to implement a search function on the site ...
    Rachel CarmichaelRachel Carmichael
    Sep 5, 2002 at 1:08 pm
    Sep 6, 2002 at 2:13 am
  • Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an "ALTER TABLE PCTFREE 99 PCTUSED1", does this take effect immediately, even for existing blocks. [If so, existing blocks would not get ...
    Sep 24, 2002 at 9:58 am
    Sep 26, 2002 at 4:53 pm
  • Hi All, Some of my tables are accidentally created in the SYSTEM tablespace. Is there any way to move the records and the table to some other tablespace? regards, Karthik -- Please see the official ...
    Karthikeyan SKarthikeyan S
    Sep 17, 2002 at 8:58 am
    Sep 17, 2002 at 3:03 pm
  • Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my "medium" tablespace. The table ended up ...
    Miller, JayMiller, Jay
    Sep 5, 2002 at 4:08 pm
    Sep 11, 2002 at 3:48 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" I'm managing an OPS configuration (4x HP 9000/N, HP-UX 11/64 , RDBMS and I'm having an application dependency on a temporal ...
    Gogala, MladenGogala, Mladen
    Sep 3, 2002 at 10:00 pm
    Sep 7, 2002 at 3:18 pm
  • I am visiting Oracle next week and will be getting a dog-and-pony show on Oracle 9i and RAC (Real Application Clusters). Does anyone have any experience or comments on this product/technology? Can ...
    Glenn TravisGlenn Travis
    Sep 26, 2002 at 3:04 pm
    Sep 30, 2002 at 8:23 am
  • Hi List, I have Oracle 8.1.5 server on Win 2K machine. When I try to connect as SYSDBA using SYS account from a remote machine it says "ORA-01017: invalid username/password; logon denied". Then I ...
    Sep 11, 2002 at 11:34 am
    Sep 17, 2002 at 6:18 pm
  • Hello everyone, I am having a senior moment and I have forgetten the syntax for 'decode'. Can anyone give me a hint. I have leant out my sql books and of course I need them now. Thanks in advance, ...
    Ruth GramoliniRuth Gramolini
    Sep 11, 2002 at 5:53 pm
    Sep 12, 2002 at 8:33 pm
  • I've just spent 30 minutes with our SAP administrator trying to convince her that we really don't need to reorganize the tables in our production SAP database. Due to some misinformation in an Oracle ...
    Sep 10, 2002 at 7:25 pm
    Sep 11, 2002 at 9:29 pm
  • Hi Everybody, I am facing problem while invoice Processing. We have Invoice_Header table and Invoice_Lines Table. One Record in Invoice_Header table can have multiple related records in ...
    Suman S KSuman S K
    Sep 13, 2002 at 1:03 pm
    Sep 14, 2002 at 2:38 pm
  • Hi All, I've a table of 10 M records and I want to update some thousand records based on a column which is not a part of any index. Please suggest the quickest way to do this. Thanks, Rajesh -- ...
    Pillai, RajeshPillai, Rajesh
    Sep 13, 2002 at 5:58 pm
    Sep 14, 2002 at 10:23 am
  • Hello List I got a message about Hotsos Tuning seminar in Dallas. Scheduled in February 2003. The lecturers list include among others: Tom, Anjo, Gaja. http://www.hotsos.com/events/symposium/ I also ...
    Yechiel AdarYechiel Adar
    Sep 10, 2002 at 2:28 pm
    Sep 11, 2002 at 4:42 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Hi all, I'm writing a package to manipulate a partitioned table for the duhvelopers and have run into a weird query that I can't figure ...
    John WeathermanJohn Weatherman
    Sep 4, 2002 at 4:43 pm
    Sep 4, 2002 at 10:03 pm
  • Good morning list, Environment HP-UX 11.0 Oracle 8.1.6 Can anyone help with this SQL. I can get a result set of values from a table that match a given list of values - select code from table where ...
    Steven HaasSteven Haas
    Sep 23, 2002 at 4:28 pm
    Sep 23, 2002 at 7:28 pm
  • All, Is it possible to create Oracle reports into Excel format ? Is it possible to spool Oracle tables into Excel format? Thanks in Advance Bob
    Bob RobertBob Robert
    Sep 20, 2002 at 8:33 pm
    Sep 23, 2002 at 4:23 pm
  • Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello all. I need to provide a one page report on why it may be beneficial for an organisation with light usage, small DB ...
    Martin KendallMartin Kendall
    Sep 23, 2002 at 6:33 pm
    Sep 24, 2002 at 2:48 pm
  • I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical ...
    Freeman, RobertFreeman, Robert
    Sep 20, 2002 at 2:13 pm
    Sep 20, 2002 at 7:36 pm
  • Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the ...
    Walter KWalter K
    Sep 19, 2002 at 1:38 pm
    Sep 20, 2002 at 5:44 pm
  • Hi. A developer of mine is running a large insert as select: insert /* parallel hint */ into table A nologging (select * from table b where ...); There are no indices on table A and a PK disabled ...
    Sep 18, 2002 at 7:39 pm
    Sep 20, 2002 at 10:08 am
  • Howdy, I am spooling my sqlplus output to a file with no headings and all the fields separated by a delimiter. I have a field that is defined as varchar2(56), but typically only 4 or 5 bytes are ...
    Carle, William T (Bill), ALCASCarle, William T (Bill), ALCAS
    Sep 19, 2002 at 3:18 pm
    Sep 19, 2002 at 10:53 pm
  • Hi all, I have downloaded the Metalink Notes on implementing dbms_obfuscation. I am using multiple front ends on the database, so the way I plan to implement the de-encryption is with a de-encrypt ...
    Steiner, RandySteiner, Randy
    Sep 9, 2002 at 9:43 pm
    Sep 18, 2002 at 12:08 am
  • We are looking for an ssh client for our desktops. Our early testing has been with a product from F-Secure which has some major configuration issues when used in an environment connecting to multiple ...
    Peter BarnettPeter Barnett
    Sep 4, 2002 at 4:48 pm
    Sep 5, 2002 at 2:08 pm
  • Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, ...
    Sep 26, 2002 at 6:48 pm
    Sep 27, 2002 at 9:53 pm
  • List - I am wrapping up my RMAN procedures so I can turn off conventional backups and still sleep at night. I am on Oracle 8.1.6. Does anyone know the answer to this question: If I do an RMAN backup ...
    Sep 23, 2002 at 9:43 pm
    Sep 25, 2002 at 12:48 pm
  • Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which privileges are needed (DBA is a bit OTT :-)) Try them one by one does not sound ...
    Jack van ZanenJack van Zanen
    Sep 19, 2002 at 2:23 pm
    Sep 24, 2002 at 7:08 pm
  • Hello, I run into a problem, which I cannot solve myself and would greatly appreciate any help. Oracle utilises 99% of CPU on a Windows2000 server, which also has to run MS IIS and a few ...
    Inka BezdzieckaInka Bezdziecka
    Sep 16, 2002 at 5:13 pm
    Sep 18, 2002 at 3:33 pm
  • Despite the importance of using bind variables, the Oracle documentation seems to make very little reference to how to use them(for example the PL/SQL manual) Can anyone point me at any decent ...
    John DunnJohn Dunn
    Sep 6, 2002 at 3:38 pm
    Sep 13, 2002 at 6:23 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Hi, I'm writing a procedure/script for extract the data of all the tables in a schema. When I am trying to spool/write into a file, I am ...
    Muthaiah, VSNLMuthaiah, VSNL
    Sep 4, 2002 at 10:48 am
    Sep 6, 2002 at 5:33 am
  • -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San ...
    Jamadagni, RajendraJamadagni, Rajendra
    Sep 30, 2002 at 12:33 pm
    Sep 30, 2002 at 5:18 pm
  • Please don't sent any more mail to this ID Please take it as a request Please ignore my name Mail ID : VHLHSR_at_eth.net Thanks System Admin -- Please see the official ORACLE-L FAQ ...
    Sep 3, 2002 at 6:08 am
    Sep 30, 2002 at 2:43 pm
  • -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San ...
    Jamadagni, RajendraJamadagni, Rajendra
    Sep 17, 2002 at 2:33 pm
    Sep 19, 2002 at 1:03 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Hi list, Scenario Win2000 server, 8.1.7. I added a network card to my DB Server. I want the listener to accept connections for the 2 IP ...
    Ramon E. EstevezRamon E. Estevez
    Sep 17, 2002 at 2:43 pm
    Sep 18, 2002 at 6:38 pm
  • Listers, How do you set optimizer_goal to 'choose' to take effect for sessions connecting using COPY command? The database runs with optimizer_mode=RULE. I want to test if CBO would be better for ...
    Deshpande, KirtiDeshpande, Kirti
    Sep 11, 2002 at 6:03 pm
    Sep 12, 2002 at 2:08 am
Group Navigation
period‹ prev | Sep 2002 | next ›
Group Overview
grouporacle-l @

343 users for September 2002

DENNIS WILLIAMS: 99 posts Rachel Carmichael: 51 posts Jesse, Rich: 47 posts Jamadagni, Rajendra: 44 posts Jared.Still_at_radisys.com: 44 posts Mercadante, Thomas F: 42 posts Fink, Dan: 40 posts Tim Gorman: 39 posts Naveen Nahata: 37 posts Deshpande, Kirti: 35 posts Gogala, Mladen: 33 posts Dgoulet_at_vicr.com: 31 posts Ltiu: 29 posts Jared Still: 25 posts Yechiel Adar: 24 posts Connor McDonald: 23 posts Khedr, Waleed: 23 posts Inka Bezdziecka: 22 posts Miller, Jay: 22 posts Stephane Faroult: 22 posts
show more