FAQ

Oracle > oracle-l > October 2002

Search Discussions

592 discussions - 2,708 posts

  • I receive the mails of this late after a long delay approx 1-2 hours. Is this common? Sometimes i get the reply first and then i get the question Regards Naveen -- Please see the official ORACLE-L ...
    Naveen NahataNaveen Nahata
    Oct 3, 2002 at 3:58 pm
    Oct 3, 2002 at 10:01 pm
  • Hi all, I'd like to know if there is some tool we can use to automate loading data into database using SQLLDR either via GUI or scripts. I need to allow someone to login the system to bulk load data ...
    Nguyen, David MNguyen, David M
    Oct 2, 2002 at 5:44 pm
    Oct 2, 2002 at 7:58 pm
  • Hmmmm. How come I always seem to be the DBA who can't say no - you don't seem to have that problem at all. -----Original Message----- Sent: Monday, September 30, 2002 3:58 PM To: Multiple recipients ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Oct 1, 2002 at 10:28 am
    Oct 1, 2002 at 7:24 pm
  • Hello We are doing database design for a project. We have 10 distinct transactions types and the total number of records is expected to be around 5,00,000 taking all transactions together.We have ...
    PK_Deepa/VGIL_at_vguard.satyam.net.inPK_Deepa/VGIL_at_vguard.satyam.net.in
    Oct 30, 2002 at 6:28 am
    Oct 31, 2002 at 4:53 am
  • I was reading one of the papers on the quest website about data modeling. An example was presented and I did not believe the results so I tried it out. Of course the writer ( Phd) was correct. Does ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 30, 2002 at 4:08 pm
    Oct 31, 2002 at 1:33 am
  • To ALL, About a week ago I asked if anyone had an opinion of CA's AutoSys product. Thanks to those who replied, but that was a pretty SMALL number. Therefore the boss is asking what product(s) are ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 25, 2002 at 6:04 pm
    Oct 29, 2002 at 4:09 pm
  • Does anyone have experience with a product called Shareplex by Quest Software. We have some remote access performance issues and my management is looking at this product as a possible solution for a ...
    Schauss, PeterSchauss, Peter
    Oct 28, 2002 at 4:13 pm
    Oct 29, 2002 at 2:09 am
  • Hey all, Looking at doc 189908.1 on MetaLink (it's been much better lately, so no "MetaClink" for now), I see that patches for 9.2.0.2 on all platforms have an alert for BUG 2632931. Of course, I ...
    Jesse, RichJesse, Rich
    Oct 28, 2002 at 4:58 pm
    Oct 28, 2002 at 7:24 pm
  • i wanted a script which contains the create table/schema's for a existing database. How to get this script ? any utitlity or which option to be selected for achieving this after i install Oralce ? i ...
    Santosh VarmaSantosh Varma
    Oct 25, 2002 at 7:03 am
    Oct 28, 2002 at 4:13 pm
  • Hi all, I need your idea. I got laid off as an Oracle DBA (3 yrs experience), and it's hard to find a DBA position here(I'm in Colorado). I had couple of years experience programming (3 yrs) in VB, ...
    Janet LinsyJanet Linsy
    Oct 25, 2002 at 10:13 pm
    Oct 26, 2002 at 5:43 pm
  • Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for "Oracle Nwtwork Security". Any help ...
    MURAT BALKASMURAT BALKAS
    Oct 24, 2002 at 12:08 pm
    Oct 26, 2002 at 4:03 am
  • Have we had several cases where oracle.exe on NT during patching of Oracle Apps 11i gets a runaway thread. This thread is not known to Oracle - not in v$session. Even if shutdown database, still at ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 24, 2002 at 12:54 pm
    Oct 26, 2002 at 12:58 am
  • Hi I have a very large DW table in which there are only inserts and NO updates/deletes. The table grows by around 2-5 % every week due to new inserts. I need to return the rows for each customer in ...
    Ratnesh Kumar SinghRatnesh Kumar Singh
    Oct 22, 2002 at 10:38 am
    Oct 23, 2002 at 8:58 am
  • Hello Gurus Does Oracle reuse ROWID "numbers", once a delete of a row has been done? The reason I ask is because, I need to delete duplicate records from a very large table. However I must keep the ...
    Denham EvaDenham Eva
    Oct 22, 2002 at 2:49 pm
    Oct 23, 2002 at 8:03 am
  • Dear Listers, I hope you won't mind a question that (I think) looks unfit for this list: "Can we prevent a delete trigger from deleting a row?" To make it clear, here's the code for a trigger: CREATE ...
    Charu JoshiCharu Joshi
    Oct 14, 2002 at 6:13 pm
    Oct 22, 2002 at 11:49 am
  • Not a particularily technical query but a rather practical one. With a named user licence is one user taken per each username returned from a select username from dba_users? Seán O' Neill Organon ...
    O'Neill, SeanO'Neill, Sean
    Oct 21, 2002 at 12:58 pm
    Oct 21, 2002 at 7:29 pm
  • Hi gurus, I have analyzed my table A but I get no stats for the table. What could be the problem? I set TIMED_STATISTICS = TRUE and SQL_TRACE=TRUE before issuing the ANALYZE TABLE A COMPUTE ...
    Moyam_at_mtn.co.ugMoyam_at_mtn.co.ug
    Oct 15, 2002 at 12:18 pm
    Oct 16, 2002 at 6:38 am
  • I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started ...
    Nguyen, David MNguyen, David M
    Oct 15, 2002 at 12:19 am
    Oct 15, 2002 at 9:10 pm
  • Lewis, I can understand where Eva is coming from. I had a demo of a similar product some time ago. Their BIG selling point is that you have a production server and a backup that is close in time with ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 15, 2002 at 2:03 pm
    Oct 15, 2002 at 6:50 pm
  • Dennis, I also have a driving commute, and I was also thinking about asking her to voice record her book. But I think I would get into an accident hearing her sexy voice describing how to recover a ...
    Grabowy, ChrisGrabowy, Chris
    Oct 14, 2002 at 9:53 pm
    Oct 15, 2002 at 5:59 pm
  • On the link below is this quote from C.J.Date: "I don't want you to think that my SQL solution to your problem means I advocate the use of nulls. Nulls are a disaster." Of course, he doesn't expound ...
    Jesse, RichJesse, Rich
    Oct 14, 2002 at 5:33 pm
    Oct 15, 2002 at 9:53 am
  • I'm working on an AIX (4.3) box which seems to be CPU bound. vmstat and iostat -t both show idle cpu and iowait at 0%. User and system cpu are about 40/60. While trying to track down the source of ...
    Henry PorasHenry Poras
    Oct 9, 2002 at 5:03 pm
    Oct 10, 2002 at 4:28 pm
  • Hi! DBAs, If I modify the "Process" in init.ora after database was created and running for quite a long while, is it true that the maximum of the process will increase as what i changed? do i need to ...
    shuan.tay\(PCI�G�R��\)shuan.tay\(PCI�G�R��\)
    Oct 8, 2002 at 1:23 pm
    Oct 8, 2002 at 4:03 pm
  • Hi . This is a very easy question. I'm usually working with Oracle on UNIX, but today I need to connect to a remote instance from my NT desktop. Is there an equivalent to TNS_ADMIN varaiable in NT? ( ...
    GureleiGurelei
    Oct 7, 2002 at 4:36 pm
    Oct 7, 2002 at 7:28 pm
  • I've used cpio, dd, and fbackup to do hot and cold backups before, but never again. With those utilities the burden of keeping track of what is on which tape rests with you and normally a stubby ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 3, 2002 at 6:43 pm
    Oct 3, 2002 at 10:08 pm
  • How to create this view X$KSPPI ? I am trying to install statspack, and it missing this view. ! ! ! Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert ...
    Bernard, GilbertBernard, Gilbert
    Oct 2, 2002 at 5:39 pm
    Oct 3, 2002 at 1:33 pm
  • Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C268F2.3CDCC1B0" ------_=_NextPart_001_01C268F2.3CDCC1B0 Content-Type: text/plain; charset="iso-8859-1" Matt, optimizer_mode = ...
    Alexander.Feinstein_at_mitchell1.comAlexander.Feinstein_at_mitchell1.com
    Oct 1, 2002 at 3:28 am
    Oct 1, 2002 at 6:43 pm
  • Advice for those seeking to have the Internals seminars presented in their area/region/continent (from Lex de Haan, original curriculum developer of the Internals seminars series, based in Oracle ...
    Tim GormanTim Gorman
    Oct 30, 2002 at 11:58 pm
    Oct 31, 2002 at 8:38 pm
  • Dear gurus ! We are trying to analyze a table partition (estimate 2 %) and it takes forever. analyze table ... partition (P20021022) estimate statistics sample 2 percent; For instance, select ...
    Andrey BronfinAndrey Bronfin
    Oct 29, 2002 at 3:49 pm
    Oct 31, 2002 at 2:03 pm
  • Hi, I've sent a couple of questions on queues and got no answers - that's fine and I understand we're all busy. What I'm wondering though is whether anyone is actually using Oracle queues at all? Any ...
    Reardon, Bruce (CALBBAY)Reardon, Bruce (CALBBAY)
    Oct 30, 2002 at 6:58 am
    Oct 30, 2002 at 6:14 pm
  • Hello All, I am writing an perl script. I cann't figure out and have been going through the docs, but cann't find exactly what I need. A way to access Oracle Parameters as they are set up in the ...
    Denham EvaDenham Eva
    Oct 29, 2002 at 8:43 am
    Oct 30, 2002 at 8:03 am
  • Does anyone have benchmark or comparative figures for Sun SPARC v Compaq (thenewhp) Alpha for Oracle Databases ? I found some benchmark figures for Datawarehouses at the Oracle website but not for ...
    Hemant K ChitaleHemant K Chitale
    Oct 28, 2002 at 2:18 pm
    Oct 29, 2002 at 2:43 pm
  • Hi I am having following error message in alert log on standby database at time of recovery. ORA-00600: internal error code, arguments: [3020], [46191421], [1], [8439], [18903], [16], [], [] Metalink ...
    Seema SinghSeema Singh
    Oct 23, 2002 at 7:33 pm
    Oct 27, 2002 at 3:59 am
  • Greetings, SQL select value from v$nls_parameters where parameter='NLS_CHARACTERSET'; VALUE US7ASCII Now in the Unix shell script I want to pass this character set as follows ...
    Mandal, AshokeMandal, Ashoke
    Oct 22, 2002 at 9:54 pm
    Oct 25, 2002 at 8:18 pm
  • Hi Can some one suggest whats wrong in this query?The same query run fine on development db but not running on production? select count(a.xxx_id) from gorp_cats_stats_view a, static_pages b where ...
    Seema SinghSeema Singh
    Oct 24, 2002 at 4:39 pm
    Oct 24, 2002 at 6:34 pm
  • I'm back on 8i for a different client who wants to implement standby database. other than the whole possibility of losing data during a failover, i've not been able to find anything about doing ...
    Joe TestaJoe Testa
    Oct 23, 2002 at 4:14 pm
    Oct 23, 2002 at 6:16 pm
  • Is there a way of capturing info on people who issue CREATE DATABASE statements? My Oracle Support technician says auditing won't catch this, only catches successful attempts. Regards, Patrice Boivin ...
    Boivin, Patrice JBoivin, Patrice J
    Oct 17, 2002 at 4:41 pm
    Oct 20, 2002 at 4:03 pm
  • Hi, We want to create a database trigger to maintain the log history of transaction tables (Not the Oracle Archive Log). Our requirement is to create a common Oracle database trigger. Only the table ...
    PK_Deepa/VGIL_at_vguard.satyam.net.inPK_Deepa/VGIL_at_vguard.satyam.net.in
    Oct 17, 2002 at 7:13 am
    Oct 19, 2002 at 9:38 am
  • What does the background job queue acronym SNP stand for ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markham, Richard INET: RMarkham_at_hafeleamericas.com Fat City ...
    Markham, RichardMarkham, Richard
    Oct 17, 2002 at 9:29 pm
    Oct 18, 2002 at 3:13 pm
  • I need to release blocks belonging to the initial extent of a table. CTAS is not an option. Optionally how can I decrease the value of initial extent so I can export and import into smaller size. I ...
    Yechiel AdarYechiel Adar
    Oct 17, 2002 at 6:20 pm
    Oct 18, 2002 at 12:43 pm
  • Hi, what's the best method to remove a user absolutely. I want to remove the user's tables, indexes, ... etc. move a user absolutely to another tablespace. Thanks, Murat Bu e-posta sadece yukarida ...
    MURAT BALKASMURAT BALKAS
    Oct 7, 2002 at 7:28 am
    Oct 17, 2002 at 9:18 am
  • Help! Anybody have a quick and dirty to parse the 4 octets of a typical IP address into 4 separate values. I will insert these into a table where database checks may verify that the data is in fact a ...
    Johan MullerJohan Muller
    Oct 16, 2002 at 8:32 pm
    Oct 16, 2002 at 9:26 pm
  • Dear ALL, Is there any way to see the currently running SQL in one session? I used v$open_cursor, but there might be many SQL statements, I don't know which one is currently running. And more, if I ...
    Chuan ZhangChuan Zhang
    Oct 16, 2002 at 1:28 am
    Oct 16, 2002 at 5:04 pm
  • Hello, How many people here have RPG - AS400 - iSeries in their shops? Curious question: What makes your shop use the IBM iSeries? Do you use RPG or SQL for your database? Thank you. -- Lyndon Tiu -- ...
    Lyndon TiuLyndon Tiu
    Oct 15, 2002 at 4:58 am
    Oct 15, 2002 at 10:33 pm
  • MessageHello all HELP - and I am not an idiot. Oracle 8.1.6.3.4 on NT. We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB. We are getting ora-01115 ...
    Yechiel AdarYechiel Adar
    Oct 10, 2002 at 3:08 pm
    Oct 15, 2002 at 2:49 pm
  • I am running tkprof on some trace files with the following options: (Oracle 8.1.7) explain=/ sort=exeqry,fchqry,execu,fchcu Output after each query includes the following two tables: Rows Row Source ...
    Schauss, PeterSchauss, Peter
    Oct 13, 2002 at 8:03 pm
    Oct 14, 2002 at 7:03 pm
  • Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn ...
    Jenner MikeJenner Mike
    Oct 11, 2002 at 6:08 pm
    Oct 12, 2002 at 12:43 am
  • Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary ...
    HukangangHukangang
    Oct 11, 2002 at 7:38 am
    Oct 11, 2002 at 10:18 pm
  • Hi Can any one share data migration from sun solaris to linux ? Thx -Seema Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ ...
    Seema SinghSeema Singh
    Oct 9, 2002 at 9:18 pm
    Oct 10, 2002 at 8:41 pm
  • Hello, I successfully traced a long running session by using dbms_system.set_ev procedure, and moved the trace file to somewhere else. However, when I used the same command to re-trace the same ...
    Xie, TomXie, Tom
    Oct 8, 2002 at 6:03 pm
    Oct 8, 2002 at 8:28 pm
Oct 2002
12345…12
Group Navigation
period‹ prev | Oct 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions592
posts2,708
users383
websiteoracle.com

383 users for October 2002

DENNIS WILLIAMS: 106 posts Jared.Still_at_radisys.com: 95 posts Tim Gorman: 79 posts Rachel Carmichael: 70 posts Deshpande, Kirti: 65 posts Dgoulet_at_vicr.com: 53 posts Yechiel Adar: 50 posts Jamadagni, Rajendra: 49 posts Naveen Nahata: 47 posts Fink, Dan: 45 posts Mercadante, Thomas F: 44 posts Jesse, Rich: 43 posts Rajesh.Rao_at_jpmchase.com: 38 posts Igor Neyman: 37 posts Gogala, Mladen: 36 posts Ray Stell: 35 posts Connor McDonald: 33 posts Grabowy, Chris: 31 posts Paquette stephane: 31 posts Rick_Cale_at_teamhealth.com: 31 posts
show more
Archives