FAQ

Search Discussions

592 discussions - 2,708 posts

  • Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another ...
    Robyn Anderson SandsRobyn Anderson Sands
    Oct 3, 2002 at 12:08 am
    Oct 7, 2002 at 8:18 pm
  • Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 21, 2002 at 11:19 pm
    Oct 31, 2002 at 10:29 pm
  • I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in ...
    Boivin, Patrice JBoivin, Patrice J
    Oct 28, 2002 at 6:53 pm
    Oct 30, 2002 at 5:03 am
  • DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 ...
    Rachna VaidyaRachna Vaidya
    Oct 16, 2002 at 6:12 pm
    Oct 24, 2002 at 11:28 pm
  • Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance ...
    Miller, JayMiller, Jay
    Oct 9, 2002 at 6:53 pm
    Oct 14, 2002 at 3:08 pm
  • I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the ...
    Grabowy, ChrisGrabowy, Chris
    Oct 24, 2002 at 5:34 pm
    Oct 30, 2002 at 3:54 pm
  • Anybody seen anything like this? I am running 9.2.0.1 OEM auto discovery. The Intelligent Agent is running on the target node. For some reason, it seems unable to discover 1 instance, the other 3 on ...
    John WeathermanJohn Weatherman
    Oct 17, 2002 at 8:10 pm
    Oct 23, 2002 at 8:48 pm
  • The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders ...
    Craig HealeyCraig Healey
    Oct 23, 2002 at 5:45 pm
    Oct 25, 2002 at 11:23 am
  • Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So ...
    GKor_at_rdw.nlGKor_at_rdw.nl
    Oct 23, 2002 at 7:38 am
    Oct 31, 2002 at 9:08 pm
  • Hi guys I am trying to create the following trigger. The user in question is logging in using siebel application and siebel does not allow multiple SQL statements during login so we through this ...
    George Leonard (ZA)George Leonard (ZA)
    Oct 2, 2002 at 3:23 pm
    Oct 31, 2002 at 1:23 pm
  • Position: Sr. Oracle 8i DBA Location: New York, New York Industry: Publishing, Ecommerce Salary Range: 90-110K-depends on experience plus excellent benefits and bonus plan. *PLEASE DO NOT send your ...
    OraStaffOraStaff
    Oct 3, 2002 at 7:37 pm
    Oct 14, 2002 at 3:23 pm
  • Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on ...
    Jamadagni, RajendraJamadagni, Rajendra
    Oct 23, 2002 at 9:38 pm
    Oct 27, 2002 at 10:33 pm
  • Dear list, I found something rather interesting on MetaLink today. While doing a little research on UTL_FILE, I came across document # 1050919.6. This document deals with how to dump a table to an ...
    Jared StillJared Still
    Oct 10, 2002 at 7:13 am
    Oct 11, 2002 at 4:14 pm
  • I have a table test((NAME VARCHAR2(10),AGE NUMBER(2)); data of the table is NAME AGE ---------- --------- ANAND 1 BALU 2 CHANDU 3 DAVID 4 I want a query which give me the result as NAME AGE ...
    Anand Kumar NAnand Kumar N
    Oct 3, 2002 at 8:03 am
    Oct 4, 2002 at 4:29 pm
  • As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 24, 2002 at 4:29 pm
    Oct 31, 2002 at 10:49 pm
  • List, i have two heavily inserted tables, the structures are same. currently these tables reside on separate disks, can i increase the performance of inserts if i create these tables in a cluster ? ...
    RahulRahul
    Oct 25, 2002 at 12:18 pm
    Oct 28, 2002 at 3:23 am
  • Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after ...
    Seema SinghSeema Singh
    Oct 24, 2002 at 6:49 pm
    Oct 25, 2002 at 6:39 pm
  • how to create a new user ? in oracle 8.1.7 ? and i want to import a dump file into that user so that i could create the tables. How to acheive this ? any help will be appreciated. Thanks and regards, ...
    Santosh VarmaSantosh Varma
    Oct 22, 2002 at 11:43 am
    Oct 22, 2002 at 11:43 pm
  • My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with ...
    JOE TESTAJOE TESTA
    Oct 21, 2002 at 1:28 pm
    Oct 21, 2002 at 6:08 pm
  • Hello, list: We have a unix nightly job which will send an email to a user. However, the file size is very large, so we need to zip the file before we send it out. Does anyone know the syntax or ...
    WLSHWLSH
    Oct 16, 2002 at 10:43 pm
    Oct 17, 2002 at 7:37 pm
  • Hi All, In session 1 I am loading data into a global temp table. Is there any way to see contents of that table? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 7, 2002 at 1:43 pm
    Oct 7, 2002 at 6:49 pm
  • Ave ! I like to hear Your opinion about the most importat issues, what should be monitored from the database (8.1.7, SUN) during perfomance testing. The purpose in this case, is limit the monitoring ...
    Jorma.Vuorio_at_nokia.comJorma.Vuorio_at_nokia.com
    Oct 2, 2002 at 6:08 am
    Oct 4, 2002 at 5:43 am
  • the vms user oracle needs rights to the directory. List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure ...
    Gene SaisGene Sais
    Oct 1, 2002 at 2:48 pm
    Oct 3, 2002 at 10:34 pm
  • Hi All, I want to feed my shell script with the names of currently running databases. I thought of using ps -ef|grep [p]mon. What I got was the following: oracle 20113 1 0 Oct 25 ? 0:01 ...
    Ross ColladoRoss Collado
    Oct 28, 2002 at 1:43 am
    Oct 29, 2002 at 3:13 am
  • Dear All, We are planning to implement ORAC for our application, can anybody tell me where to get good information on the system requirements for implementing the same. Regards Prem -- Please see the ...
    Prem_at_ibsplc.comPrem_at_ibsplc.com
    Oct 23, 2002 at 7:04 am
    Oct 24, 2002 at 6:19 pm
  • Jesse, I'll refrain from personal comments, but on CJ's quote, he's correct. Nulls are an oddity. They cannot be true or false ( = NULL or != NULL), nor can they equal anything. They are in effect a ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 14, 2002 at 6:28 pm
    Oct 15, 2002 at 12:28 pm
  • I am creating a stored proc that will export a tablespace. One task it needs to perform is to place the tablespace(s) in read only mode to make a copy. Based upon the application and proc logic, ...
    Fink, DanFink, Dan
    Oct 9, 2002 at 8:48 pm
    Oct 11, 2002 at 7:05 pm
  • I just wanted to ping the list to see what other people have done to control or constrain adhoc query users??? We have a group that is struggling with the adhoc query piece that's in production. Some ...
    Grabowy, ChrisGrabowy, Chris
    Oct 29, 2002 at 7:29 pm
    Oct 30, 2002 at 4:54 pm
  • 13

    Linux

    Greetings ALL! Have a question for anyone who has info....I'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will ...
    Turner, ChristineTurner, Christine
    Oct 23, 2002 at 4:14 pm
    Oct 23, 2002 at 7:44 pm
  • SET ORACLE-L NOMAIL Mit freundlichen Grüßen, Brigitte Türk KAUFHOF WARENHAUS AG Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 223-21 88 eMail: Brigitte.Tuerk_at_kaufhof.de -- Please see the ...
    Brigitte.Tuerk_at_kaufhof.deBrigitte.Tuerk_at_kaufhof.de
    Oct 15, 2002 at 3:33 pm
    Oct 16, 2002 at 5:43 pm
  • Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh) called from elsewhere that shuts down the database. I REALLY want to echo the name of the database into my log file before I shut down ...
    Baker, BarbaraBaker, Barbara
    Oct 2, 2002 at 11:28 pm
    Oct 4, 2002 at 8:08 am
  • Hi guru, I need your advise, currently our customer have a production and development system, if there is a problem log being raise, then we need to port the data from development to production but ...
    RaymondRaymond
    Oct 1, 2002 at 2:18 am
    Oct 1, 2002 at 9:43 pm
  • Hi, I want to know the location of trace file.I do not know location of init.ora. How to get it. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET ...
    Cosltemp-g.manoj_at_orbitech.co.inCosltemp-g.manoj_at_orbitech.co.in
    Oct 25, 2002 at 8:08 am
    Oct 28, 2002 at 8:58 pm
  • Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it...... hmmmmm.... let's ...
    Freeman, RobertFreeman, Robert
    Oct 24, 2002 at 2:44 pm
    Oct 24, 2002 at 9:26 pm
  • Hi DBAs, A co-worker and I disagree on impact of slightly different B&R scenarios and I would like your thoughts. Environment for both scenarios: Oracle 8.1.6, WinNt, Archivelog mode, not using RMAN ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 23, 2002 at 3:15 pm
    Oct 24, 2002 at 2:28 am
  • An recent oraperf report included the comment: "Never split index and data files to different sets of disks." It goes on to state that striping is better. If the system in question does not have raid ...
    Ray StellRay Stell
    Oct 21, 2002 at 8:43 pm
    Oct 23, 2002 at 9:58 am
  • Hello all, I am going to install a product in a client's place where oracle is installed. I am new to oracle. I wanted to know what all needs to be installed .. i mean like tables,tablespace etc.. ...
    Santosh VarmaSantosh Varma
    Oct 21, 2002 at 10:38 am
    Oct 22, 2002 at 10:54 am
  • So every few months my Lookout reminder pops up to remind me to check out what new Oracle books have been released. I stumbled upon a new book called CodeNotes for Oracle9i on Amazon.com, but the ...
    Grabowy, ChrisGrabowy, Chris
    Oct 8, 2002 at 8:04 pm
    Oct 21, 2002 at 10:53 pm
  • Hi all, Does anyone have the appropriate time on implementing replication for a newbe? I am given a time frame on doing the replication for 10 days which is including testing on test server and move ...
    Robin LiRobin Li
    Oct 14, 2002 at 1:58 pm
    Oct 15, 2002 at 5:50 pm
  • Has anybody tried installing it? Any experiences/remarks/problems/rantings? Any RH 8.0 comments in general? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen ...
    Gogala, MladenGogala, Mladen
    Oct 8, 2002 at 4:08 pm
    Oct 11, 2002 at 6:33 pm
  • We have a developer here, installing a third party application, who claims one of his "delete campaign" process is hanging. I looked at the wait events, saw nothing, and asked him to politely to go ...
    Rajesh.Rao_at_jpmchase.comRajesh.Rao_at_jpmchase.com
    Oct 9, 2002 at 9:28 pm
    Oct 10, 2002 at 8:28 pm
  • 9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003. <-- yes in like 8 months 9.2, aka9ir2, ECS ends sep 30, 2005. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- ...
    JOE TESTAJOE TESTA
    Oct 8, 2002 at 7:59 pm
    Oct 9, 2002 at 11:43 am
  • Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the ...
    Jesse, RichJesse, Rich
    Oct 1, 2002 at 3:28 pm
    Oct 3, 2002 at 2:33 pm
  • Hi! I was wondering what sqlplus /nolog actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- ...
    Daiminger, HelmutDaiminger, Helmut
    Oct 29, 2002 at 1:29 pm
    Oct 30, 2002 at 5:09 am
  • Deepak, If there are many columns on these tables, your method may be best. However, this will generate a lot of redo. You can usually accomplish this with a CTAS nologging, which won't generate ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Oct 24, 2002 at 8:35 pm
    Oct 25, 2002 at 6:09 pm
  • Please forgive the cross postings, but I am hoping that someone in all of the sets of eyes that see this might have an idea I haven't thought of. *** Facts aix 4.3.3 oracle 9.0.1.3 new instance, up ...
    April WellsApril Wells
    Oct 10, 2002 at 3:13 pm
    Oct 11, 2002 at 12:58 am
  • Hi All, We have users that have OPS$ accounts that have full DML privs when they run forms application via citrix. Currently they do not have sqlplus,etc. There is a requirement that some can have ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 3, 2002 at 2:33 pm
    Oct 8, 2002 at 6:34 pm
  • Arrgggg... So anyway, I am thinking, hey it's high time I start using DBMS_STATS instead of my own procedure so I kick of the following (Oracle 8.1.7.4). After the first run I have SYS and SYSTEM ...
    Post, EthanPost, Ethan
    Oct 4, 2002 at 10:08 pm
    Oct 8, 2002 at 9:11 am
  • Ok so the qa environment we've been fooling around with rman for testing backup/recovery. tonite they say " we want a backup restored from rman from 2 incarnations ago(for those of u who dont know ...
    JOE TESTAJOE TESTA
    Oct 4, 2002 at 1:23 am
    Oct 5, 2002 at 12:13 am
  • We have experienced a sudden and dramatic decrease in performance sometime over the weekend (after Sat but before Monday 4 am). In following Gaja's tuning philosophy, I've found that the top 2 waits ...
    Stephen AndertStephen Andert
    Oct 30, 2002 at 12:28 am
    Oct 30, 2002 at 6:42 pm
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