FAQ

Search Discussions

186 discussions - 270 posts

  • Jim, I tried both and 0001 goes in, 9999 is out of range (-4731 to +4731 I think it said were valid). I tried selecting the 0001 and it displays in default dd-mon-yy format, but when I try to convert ...
    Scott MattesScott Mattes
    Feb 3, 1996 at 11:27 am
    Feb 29, 1996 at 6:37 pm
  • (snip) I am 'pro' the idea of an organized file architecture, but very 'con' on this implementation of it. The pathnames are excessively long and cumbersome. On one machine where Oracle was installed ...
    Helena WhitakerHelena Whitaker
    Feb 7, 1996 at 9:37 am
    Feb 29, 1996 at 11:15 am
  • Hi all, I created a table and inadvertently named it 'junk' instead of 'JUNK'. Now I can't drop it. Does anyone have a solution for me other than recreating the schema without it? Thanks, Marta
    Marta LordMarta Lord
    Feb 5, 1996 at 9:42 am
    Feb 29, 1996 at 6:09 am
  • Are you using rule or cost based optimization? If cost, then do both instances have accurate statistics? We've had problems with views using cost based optimizer. For the worst offenders, we alter ...
    David WhiteDavid White
    Feb 1, 1996 at 12:24 pm
    Feb 13, 1996 at 9:21 am
  • Hi Dave & Sanjay ! Thanks 4 your replies regarding the above qn. Dave Ans: Sanjay Ans: However, that's not what I am asking 4. Let me rephrase my qn again. My table Table1 contains field : 1) userid ...
    CHANCLCHANCL
    Feb 28, 1996 at 2:33 am
    Feb 29, 1996 at 8:14 pm
  • Hi Gurus, I am new to ORACLE. I know that tablespaces group all of an application's objects to SIMPLIFY certain administrative operations. 1) What are admn. operations on all application's objects ...
    Rajesh.S.BhaveRajesh.S.Bhave
    Feb 13, 1996 at 8:34 am
    Feb 13, 1996 at 10:44 am
  • I have code with nested loops which is changing and updating information on the form. At times the code performs a COMMIT_FORM. This produces an acknowledgement display ... FRM-40400 Transaction ...
    Dennis PikeDennis Pike
    Feb 8, 1996 at 7:35 am
    Feb 8, 1996 at 9:06 am
  • --Boundary-8702645-0-0 Yes it does. Rollback segments are used to preserve a consistent view of data for select. If it's a long running select, and the data you are reading is being updated a lot, ...
    TSAWMILL.US.ORACLE.COMTSAWMILL.US.ORACLE.COM
    Feb 29, 1996 at 1:55 pm
    Feb 29, 1996 at 10:49 pm
  • I have a problem with my oracle database. I am on a dg with Oracle 7.1.6.2. I was creating a number of tablespaces this afternoon and during one of them the pmon process crashed. Now after shutting ...
    <remund_at_DLGEH.CR.USGS.GOV><remund_at_DLGEH.CR.USGS.GOV>
    Feb 29, 1996 at 3:16 pm
    Feb 29, 1996 at 6:05 pm
  • Greetings, On our ALPHA OpenVMS 6.1 with Oracle 7.1.3, I've got some VMS processes showing as ORA__Pnnn. Are these parallel processes? I was about to kill them from the o/s until I realised that the ...
    Kaing, Leng MKaing, Leng M
    Feb 6, 1996 at 1:34 am
    Feb 27, 1996 at 11:16 pm
  • Hi! Count me in, please! Kindest regards! * * * * * * * -- Mladen Gogala ASTER Ljubljana Tel : ++386 61 1683-511 Snail-mail: FAX : ++386 61 1683-165 ASTER Ljubljana Email: gogi_at_aster.si Nade ...
    Mladen GogalaMladen Gogala
    Feb 16, 1996 at 3:19 am
    Feb 19, 1996 at 4:32 am
  • Is there a maximum number of indexes ORACLE will use when setting the execution plan for a query?
    Ken DullKen Dull
    Feb 13, 1996 at 10:10 am
    Feb 13, 1996 at 11:06 am
  • On VMS there is a logical (like a UNIX env variable) which you need to set to pick up the shared libraries. You add this into your LINK_whatever.COM (or makefile on UNIX, I suppose(?).). The info on ...
    Peter MoorePeter Moore
    Feb 6, 1996 at 1:34 am
    Feb 9, 1996 at 1:25 pm
  • --Boundary-8184038-0-0 Are you absolutely sure no one is accessing the table? Maybe even a hung process? You might try shutting down the database and starting it restricted mode to see if a DBA can ...
    TSAWMILL.US.ORACLE.COMTSAWMILL.US.ORACLE.COM
    Feb 2, 1996 at 9:33 am
    Feb 2, 1996 at 6:17 pm
  • YOu do need to make sure you have a bullet proof network to use this feature Steve Lemme DBA Motorola Date: 2/14/96 8:55 PM To: Steve Lemme From: ORACLE database mailing list. I think one of the true ...
    Steve LemmeSteve Lemme
    Feb 19, 1996 at 3:15 pm
    Feb 29, 1996 at 10:11 pm
  • Hi everyone, This is for a friend of mine who does not have access to internet. He has application in VISAUL BASIC and the server is located at some other site. Right now they are imporing and ...
    Praveen K. GopuPraveen K. Gopu
    Feb 29, 1996 at 11:43 am
    Feb 29, 1996 at 8:44 pm
  • Execute the following query, and lots of documentation on using dynamic SQL within PL/SQL (not within PRO*C) will appear... select text from all_source where name='DBMS_SQL' order by type,line ...
    Toon KoppelaarsToon Koppelaars
    Feb 29, 1996 at 3:16 pm
    Feb 29, 1996 at 4:13 pm
  • I too was at the ODC. My opinion? The keynote speakers were great! Listening to McNeeley & Jobs was almost worth the price of the conference. Of the tech sessions I attended I would say 1/4 were ...
    D.DavisD.Davis
    Feb 29, 1996 at 1:23 pm
    Feb 29, 1996 at 3:16 pm
  • Does anyone know of a good tip to perform export by tablespace? Any help would be appreciated. We are running Oracle 7.1.4 on a Netware environment. Kian Chung
    Chung KianChung Kian
    Feb 28, 1996 at 9:00 pm
    Feb 29, 1996 at 2:47 pm
  • Help! - Oracle Graphics SET ORACLE-L REPRO Hi Oracle Gangs, Has anybody used Oracle graphics 2.0, or above? Do you know if it is capable of creating boxplots and connect means? TIA, Shirin Sebty, ...
    Shirin SebtyShirin Sebty
    Feb 28, 1996 at 8:22 pm
    Feb 28, 1996 at 9:54 pm
  • We are currently looking for a contractor to do maintenance on a large legacy Oracle system. A possibility also exists for some new development depending on skill levels of the contractor. I ...
    Jan Baumgras, 566 Bldg., 6-0443Jan Baumgras, 566 Bldg., 6-0443
    Feb 28, 1996 at 11:19 am
    Feb 28, 1996 at 9:00 pm
  • I just happen to be reading that book now. Not bad. Morgan Kaufmann Publishers Inc. Editorial and Sales Officw 340 Pine Street, 6th Floor San Francisco, CA 94104-3205 Internet mkp_at_mkp.com ISBN ...
    John FlackJohn Flack
    Feb 28, 1996 at 8:44 am
    Feb 28, 1996 at 10:21 am
  • Hi all, I am new to devt 2k and have a problem regarding multiple forms accessing different columns of a table. Let me illustrate with an example, A table with 3 columns: TABLE1 KEY1 -- primary key ...
    Ang Kheng San ( khengsan)Ang Kheng San ( khengsan)
    Feb 27, 1996 at 9:46 pm
    Feb 28, 1996 at 8:44 am
  • There were recently a series of article about Ram Doubler and such and the recommendations were very strongly against them. You can use Po7 with 8 megs of Ram if you do not plan to use the PL/SQL ...
    Michel Durand & Basha ZapatkaMichel Durand & Basha Zapatka
    Feb 26, 1996 at 10:51 pm
    Feb 27, 1996 at 12:47 am
  • Good day to all, I have this problem of painting a table consisting of dymanic columns and fixed rows, ie the dimension of the table can be 5x2, 5x3, 5x4 etc, and each cell is an individual record ...
    Ang Kheng San ( khengsan)Ang Kheng San ( khengsan)
    Feb 14, 1996 at 2:54 am
    Feb 26, 1996 at 1:09 am
  • I'm sure I don't understand the question, because surely all you want to do is this: DELETE FROM emp WHERE emp.rowid IN (SELECT row_id FROM exceptions);
    Peter MoorePeter Moore
    Feb 22, 1996 at 2:39 am
    Feb 22, 1996 at 3:29 am
  • Joe Celko has a solution to a version of this problem in his book "SQL for Smarties" (an excellent resource by the way). In his case the problem is to find the settlement date (5 working days after ...
    Mark SaltzmanMark Saltzman
    Feb 19, 1996 at 2:12 pm
    Feb 20, 1996 at 9:17 pm
  • Hi there, Please help me out... In Oracle manual it is written that only one type of database trigger like(before insert, for each row) can be written on a single table. But, I am able to write ...
    Ajay AroraAjay Arora
    Feb 20, 1996 at 12:47 am
    Feb 20, 1996 at 4:09 am
  • I send again the above mail ( i sent it two weeks before as well but for some unknown reason i stopped receiving the mails of the list, so i didn't get any answers.. I would be grateful if you could ...
    Andreas MalandrinosAndreas Malandrinos
    Feb 19, 1996 at 5:57 am
    Feb 20, 1996 at 1:12 am
  • I have installed Developer/2000 ver. 2.0 on Personal Oracle7 Enterprise edition,and I was able to install it without any problem. When starting sql, I am getting error like profile is not loaded, ...
    Palvai ReddyPalvai Reddy
    Feb 13, 1996 at 12:38 pm
    Feb 17, 1996 at 12:49 am
  • Help, Anyone using oracle reports, I want to use a parameter in the Order By clause of my query. I have created a user parameter and prefixed this parameter in my group by using the colon. How do I ...
    Gavin GossGavin Goss
    Feb 16, 1996 at 4:56 am
    Feb 16, 1996 at 6:26 am
  • Hi Peter, The PL/SQL compiler imposes a limit on program size. The limit depends on the mix of statements in your PL/SQL program and the memory available on your platform. Programs that exceed the ...
    TRL_IndiaTRL_India
    Feb 16, 1996 at 1:52 am
    Feb 16, 1996 at 2:10 am
  • We are trying to remove the null list element value that always appears in a poplist's pulldown list. Does anyone know how to do this, or is a null always required? Thanks in advance ...
    Michael T. ButlerMichael T. Butler
    Feb 16, 1996 at 12:48 am
    Feb 16, 1996 at 2:10 am
  • �����Hi Is anybody out there accessing data from an ADABAS Natural database using the Oracle tools ? If so what 'ware' are you using to do it ? What are your experiences ? Thanks Glenn ...
    Pearce, GlennPearce, Glenn
    Feb 15, 1996 at 8:12 pm
    Feb 16, 1996 at 12:48 am
  • My Oracle server uses SQLNet2 over TCPIP to talk to clients. I regularly connect from home via SLIP (serial line ip). Our campus has a bank of slip servers that basically turn home machines into ...
    Andrew McAllisterAndrew McAllister
    Feb 2, 1996 at 11:32 am
    Feb 13, 1996 at 10:44 am
  • Hi, Gary: I am using Netscape as a Web browser, but I can not find neither http://www.asknpac.npac.syr.edu/cgi-bin/news/hypermail_home or comp.databases.oracle from the Web. The message I got was ...
    Tracy WangTracy Wang
    Feb 13, 1996 at 9:39 am
    Feb 13, 1996 at 10:44 am
  • Sorry, I got blinded by our own internal rules (no hard-coded userid/passwords in any scripts, period) so I just ignored that one. I guess the answer is, if one is worried about security, your method ...
    Winegarden, Gary NY PO1Winegarden, Gary NY PO1
    Feb 7, 1996 at 4:37 pm
    Feb 8, 1996 at 9:52 am
  • Susanne, I assume you've got the AXP/Alpha version of the RDBMS.... One change I noticed when converting from VAX to Alpha was the huge increase in resources required - both disk space and global ...
    Hutchinson, Scott, A,Hutchinson, Scott, A,
    Feb 8, 1996 at 7:53 am
    Feb 8, 1996 at 9:30 am
  • So what's the difference between parallel query and parallel server? My init.ora has: parallel_max_servers=20 parallel_min_servers=6 No 'shared' but certainly 'parallel'. v$thread shows: THREAD# ...
    Kaing, Leng MKaing, Leng M
    Feb 7, 1996 at 2:07 am
    Feb 7, 1996 at 3:08 pm
  • I am using TRUNC to try and get the Monday of a given week for any date I have in my table. TRUNC doesn't seem to be doing as advertised. Could anyone tell me if they get the same results, or if I'm ...
    Andersen ConsultantAndersen Consultant
    Feb 7, 1996 at 9:57 am
    Feb 7, 1996 at 10:48 am
  • agree Jared Budnarowski Oracle DBA Derwent Information London
    Jared BudnarowskiJared Budnarowski
    Feb 7, 1996 at 3:13 am
    Feb 7, 1996 at 7:28 am
  • Currently we are using Enterprise version of Oracle running on Sun 1000E server. Its performance is quite well. Could anybody tell the difference between Enterprise version and Workgroup version ...
    Jason Luk Chi FaiJason Luk Chi Fai
    Feb 7, 1996 at 3:13 am
    Feb 7, 1996 at 4:10 am
  • Have a look with SQLPLUS to the following system tables: Currently logged in user SESSION_ROLES : : all roles USER_ROLE_PRIVS : privileges on roles above ROLE_SYS_PRIVS : all system rights All ...
    Heiko HermsHeiko Herms
    Feb 6, 1996 at 3:16 am
    Feb 6, 1996 at 5:11 am
  • Help, we wish to show a progress bar on the screen while the procedure runs - what is the best method to use ? Louise
    Louise ToucherLouise Toucher
    Feb 1, 1996 at 7:16 am
    Feb 5, 1996 at 12:53 pm
  • Is there any CBT courseware for developer 2000? Is the Oracle training for this worthwhile or is this something you are better off learning hands on with books, etc? I would appreciate any input ...
    Mark allenMark allen
    Feb 5, 1996 at 11:54 am
    Feb 5, 1996 at 12:28 pm
  • �Excuse the ignorance, but we are very new to Oracle. We are about to install for the first time on an RS-6000. I am concerned about access from our home pc's. What are our requirments for accessing ...
    JfmJfm
    Feb 1, 1996 at 8:01 pm
    Feb 2, 1996 at 10:52 am
  • Any transaction uses a single rollback segment, it cannot use more than one rollback segment. For your large transactions, you need to explicitly assign it to your big rollback segment: begin ...
    Sue BrunkowSue Brunkow
    Feb 1, 1996 at 8:19 pm
    Feb 2, 1996 at 1:33 am
  • SET ORACLE-L DIG Received: by ccmail from Inf.COM X-Envelope-From: owner-oracle-l_at_CCVM.SUNYSB.EDU Received: by Inf.COM (4.1/SMI-4.1) id AA07628; Wed, 31 Jan 96 08:36:05 EST Message-Id ...
    RAJESHKSRAJESHKS
    Feb 1, 1996 at 2:58 am
    Feb 1, 1996 at 9:15 am
  • Apologies in advance if you object to jobs postings. MAT Transport (based in Shoreditch, just north of the Broadgate Centre/Liverpool St) is looking for two Development Team members. Both positions ...
    John ThomasJohn Thomas
    Feb 29, 1996 at 8:44 pm
    Feb 29, 1996 at 8:44 pm
  • You might check to be sure that c:\orawin\bin is in your path. Good luck. By the way, I enjoyed your book! Tom Tom Robbins, Sr. DBA, Washington Mutual Bank (206)554-4166 robbins_at_halcyon.com
    Tom RobbinsTom Robbins
    Feb 29, 1996 at 7:25 pm
    Feb 29, 1996 at 7:25 pm
Group Navigation
period‹ prev | Feb 1996 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions186
posts270
users174
websiteoracle.com

174 users for February 1996

TSAWMILL.US.ORACLE.COM: 9 posts Mladen Gogala: 7 posts Avnish Rastogi DTA: 6 posts : 5 posts Madhu. Motukuri: 5 posts Peter Moore: 5 posts CHANCL: 4 posts GurPratap Singh: 4 posts Jack Bezalel: 4 posts John Flack: 4 posts TRL_India: 4 posts Ang Kheng San ( khengsan): 3 posts Anton Dischner: 3 posts David White: 3 posts Duraikannu Rudra Murthy: 3 posts Jason Luk Chi Fai: 3 posts Kaing, Leng M: 3 posts Kjetil Nordstrand: 3 posts Michel Durand & Basha Zapatka: 3 posts Patrick Housholder: 3 posts
show more
Archives