FAQ

Oracle > oracle-l > November 2003

Search Discussions

400 discussions - 2,016 posts

  • The recent article that mentioned sequences got me to thinking. I might pitch a more detailed article on sequences to Builder.com. But a more interesting article might be one that explored various ...
    Jonathan GennickJonathan Gennick
    Nov 5, 2003 at 1:19 pm
    Nov 12, 2003 at 3:39 pm
  • Well with RH latest ordeal of jumping out of simple ISOs and basically no more free software, what is oracle's stand on running on RH?, the paid version only from now on and those linux users out ...
    Joe TestaJoe Testa
    Nov 4, 2003 at 1:54 am
    Nov 5, 2003 at 12:15 pm
  • Suppose I have the following settings which happen to be the defaults as well: PCTFREE 10 PCTUSED 40 I am trying to figure out what PCTUSED is really used for. My book is telling me that is used so ...
    Maryann AtkinsonMaryann Atkinson
    Nov 4, 2003 at 11:09 pm
    Nov 10, 2003 at 2:44 pm
  • We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of ...
    Smith, Ron L.Smith, Ron L.
    Nov 12, 2003 at 8:04 pm
    Nov 14, 2003 at 4:59 pm
  • I have a weird problem. It seems that execution speed of pl/sql proc can slow down dramatically as the size of the proc goes up even if nothing gets executed. Let me explain: I have a proc that looks ...
    Khedr, WaleedKhedr, Waleed
    Nov 8, 2003 at 6:09 pm
    Nov 11, 2003 at 7:44 am
  • I see it referred to on metalink alot. I know its seperate from the rdbms. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fat City Network Services -- 858-538-5051 ...
    Ryan_oracle_at_cox.netRyan_oracle_at_cox.net
    Nov 24, 2003 at 8:49 pm
    Nov 29, 2003 at 3:34 pm
  • I never use those. I find it better not to be overly smart with sqlplus. Sqlplus is a program for ad-hoc queries from the command line and for the administrative functions (startup/shutdown, alter ...
    Mladen GogalaMladen Gogala
    Nov 12, 2003 at 2:19 pm
    Nov 18, 2003 at 6:14 pm
  • Hi, I had sent this some time back but got no answer for version 8.1.7. For table I understand auditing is an option. What about for index? Thank You A Joshi wrote: Hi, Is there an easy way to find ...
    A JoshiA Joshi
    Nov 18, 2003 at 5:49 pm
    Nov 20, 2003 at 7:34 am
  • I have a table with like this: Usr val GAP 1 GAP 5 GAP 7 JKL 8 JKL 5 I need a query that returns the user (GAP o JKL) that has ALL the values in a list. Example: Having the list: 1,5,7 the result ...
    Gabriel AragonGabriel Aragon
    Nov 13, 2003 at 10:04 pm
    Nov 18, 2003 at 6:04 pm
  • The last statements in the article are really telling: Yet, despite MySQL's progress in the market, "we haven't found very much MySQL out there," says Microsoft's Rizzo. "That's the best news I could ...
    Goulet, DickGoulet, Dick
    Nov 6, 2003 at 10:59 pm
    Nov 10, 2003 at 12:24 pm
  • Guys, Happy Thanksgiving to everyone. May your bellies be full but your waistline not expand, may you enjoy the time with your family and friends and avoid any of the other drama .... Thanks so much ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Nov 26, 2003 at 3:34 pm
    Nov 27, 2003 at 9:19 pm
  • I have been working with Oracle on Unix - various platforms since Version 6.X. For the first time a vendor has sent us an install that installs under the C-shell. Up until this point I have always ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Nov 10, 2003 at 9:09 pm
    Nov 11, 2003 at 7:04 pm
  • Friends -- Why would these two queries return different results? This query works. SQL l 1 select a.tablespace_name,megs_allocated,megs_used,round(megs_used/b.megs_allocated, 2)*100 pct 2 from ...
    Bellow, BambiBellow, Bambi
    Nov 14, 2003 at 5:44 pm
    Nov 15, 2003 at 4:29 am
  • I agree with you, that's why I wrote "REAL high availability" in my previous post. Btw, my colleague was working on a 9.0.1.3 RAC project where hang of one node caused hang of all other ones. Now ...
    Tanel PoderTanel Poder
    Nov 20, 2003 at 4:19 pm
    Nov 20, 2003 at 11:29 pm
  • Hi, In a SQL statement I want a certain where clause to be done first. Is it enough to list it first as follows or do I (and can I) do something else to make it get checked first before other ...
    A JoshiA Joshi
    Nov 4, 2003 at 9:34 pm
    Nov 6, 2003 at 9:59 pm
  • Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Nov 3, 2003 at 7:24 pm
    Nov 5, 2003 at 7:54 am
  • List, When I create a table as select * from another table across a dblink, how do I find out how many rows were created in the table? Is there a statistic somewhere, documented or otherwise, that ...
    Arup NandaArup Nanda
    Nov 7, 2003 at 8:34 pm
    Nov 11, 2003 at 12:44 am
  • Hi all, We'll do a conversion from IMS to Oracle (817). The conversion team wants to move data on Oracle then processed it. Off course, in the file format, the cobol redefine command is used on a ...
    Stephane PaquetteStephane Paquette
    Nov 26, 2003 at 9:34 pm
    Nov 30, 2003 at 10:59 am
  • Hi List, One of my customers gets HP Servicedesk 4.5 implemented. The database that has been created by on of the DBA's for the application is Oracle 8.1.7.4, on AIX 4.3. The database has ...
    Carel-Jan EngelCarel-Jan Engel
    Nov 17, 2003 at 10:49 am
    Nov 26, 2003 at 6:54 pm
  • Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net ...
    VirVitVirVit
    Nov 12, 2003 at 6:24 am
    Nov 19, 2003 at 5:35 pm
  • Ryan, hypothetically, When you have a requirement that no gaps allowed in a sequence no matter what, would you still use sequences? Raj Rajendra dot Jamadagni at nospamespn dot com All Views ...
    Jamadagni, RajendraJamadagni, Rajendra
    Nov 5, 2003 at 6:14 pm
    Nov 9, 2003 at 11:24 pm
  • List, I have a shell script that executes a sql*plus script (which executes a procedure) based on user input. But what if the user inputs an invalid datatype? The exception section handles the error ...
    Saira Somani-MendelinSaira Somani-Mendelin
    Nov 6, 2003 at 8:44 pm
    Nov 7, 2003 at 9:19 pm
  • Hello all, I'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: "GRANT SELECT ON "DOWNLOAD_SEQ" TO ...
    Barry DeeveyBarry Deevey
    Nov 18, 2003 at 1:04 pm
    Nov 18, 2003 at 5:04 pm
  • I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, ...
    Jonathan GennickJonathan Gennick
    Nov 12, 2003 at 2:34 pm
    Nov 12, 2003 at 9:44 pm
  • i dont think social security number is actually unique. I heard that there are some repeats and there are problems with people who are 80 years old drawing money out of accoutns of people who are 25 ...
    Ryan_oracle_at_cox.netRyan_oracle_at_cox.net
    Nov 5, 2003 at 2:24 pm
    Nov 9, 2003 at 10:54 pm
  • http://www.ecommercetimes.com/perl/story/32200.html I have yet to see an objective, detailed comparison of Oracle, DB2 and SQL Server. From a technical (i.e. what can it do) as well as from an ...
    Boivin, Patrice JBoivin, Patrice J
    Nov 27, 2003 at 4:04 pm
    Nov 30, 2003 at 10:19 pm
  • Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any ...
    Shibu MBShibu MB
    Nov 19, 2003 at 1:50 pm
    Nov 21, 2003 at 1:54 pm
  • Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We don't have the SAN yet, but it is due to arrive any week (if not any day). I passed Cary's "Is RAID ...
    Sam BootsmaSam Bootsma
    Nov 19, 2003 at 3:55 pm
    Nov 21, 2003 at 2:05 am
  • List, i need some help on this... i am trying to get information on this but, and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my ...
    Rahul sharmaRahul sharma
    Nov 12, 2003 at 12:30 pm
    Nov 14, 2003 at 8:49 am
  • Hey all, I'm trying to get a simple query running in Perl 5.6.1, DBI 1.30, DBD::Oracle 1.14, Oracle 8.1.7 on HPUX 11.0 talking to a 9.2.0.4 RAC DB on Linux (whew!). Here's the pertinent part of the ...
    Jesse, RichJesse, Rich
    Nov 6, 2003 at 9:29 pm
    Nov 7, 2003 at 10:34 pm
  • Redhat recommending windoze for desktop. http://zdnet.com.com/2100-1104_2-5101690.html -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- ...
    Joe TestaJoe Testa
    Nov 5, 2003 at 12:19 am
    Nov 6, 2003 at 6:34 pm
  • Walked in to major problems this morning, and I cannot log into metalink. I keep getting invalid password errors. (We have 3 CSI's and I cannot get in on any of them) Anyone else having problems? ...
    Barbara BakerBarbara Baker
    Nov 6, 2003 at 2:49 pm
    Nov 6, 2003 at 6:29 pm
  • I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does ...
    Jonathan GennickJonathan Gennick
    Nov 30, 2003 at 1:34 am
    Nov 30, 2003 at 3:54 pm
  • Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01 ...
    Ross ColladoRoss Collado
    Nov 25, 2003 at 5:24 am
    Nov 26, 2003 at 1:59 pm
  • Hello. I'am a newbie in Oracle, so I have some questions to experts :) What difference between SPFILE and PFILE? Where by default Oracle search these files when instance starts? Where oracle searches ...
    VirVitVirVit
    Nov 24, 2003 at 6:34 am
    Nov 24, 2003 at 9:54 pm
  • Congratulations to the following folks that appeared in the 2003 Editors Choice Awards ( I finally received my issue of the mag ) Arup Nanda - DBA of the Year Tony Jambu - Consultant of the Year ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Nov 20, 2003 at 7:04 pm
    Nov 21, 2003 at 1:09 pm
  • Mladen, The reason for existence of PCTFREE parameter is completely irrelevant to free space management issues, regardless whether we use FLM or ASSM. The only reason for PCTFREE is ...
    Tanel PoderTanel Poder
    Nov 12, 2003 at 2:09 am
    Nov 13, 2003 at 10:39 am
  • Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like "Woah! Dudes! Let's just chill on this for a couple of minutes". So, I ...
    Bellow, BambiBellow, Bambi
    Nov 6, 2003 at 5:04 pm
    Nov 9, 2003 at 9:54 pm
  • Reference: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1542606219593 Tom... I was told once that if you only need a single char use CHAR(1) since using VARCHAR2(1) has overhead ...
    SaminathanSaminathan
    Nov 1, 2003 at 1:44 am
    Nov 4, 2003 at 4:14 pm
  • Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my ...
    Luc.Demanche_at_astrazeneca.comLuc.Demanche_at_astrazeneca.com
    Nov 25, 2003 at 1:09 pm
    Nov 25, 2003 at 10:04 pm
  • Does anyone know what this table (sys.col_usage$) is used for? To me it sounds like something that CBO might appreciate ... but any ideas? It is referenced by dbms_stats and dbms_stats_internal ...
    Jamadagni, RajendraJamadagni, Rajendra
    Nov 18, 2003 at 4:29 pm
    Nov 19, 2003 at 1:20 pm
  • List, I have 50 lookup tables and all of them have effective date & end date I want to create a rule or some thing like this which any select statement select the data from these lookup where the ...
    Hamid AlaviHamid Alavi
    Nov 14, 2003 at 5:49 pm
    Nov 14, 2003 at 9:29 pm
  • Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- ...
    Juan MirandaJuan Miranda
    Nov 12, 2003 at 1:09 pm
    Nov 12, 2003 at 8:34 pm
  • I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) 1 ...but we had a problem 2 weeks ago where the comparison ...
    Chris StephensChris Stephens
    Nov 11, 2003 at 5:19 pm
    Nov 12, 2003 at 2:44 pm
  • Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Nov 6, 2003 at 1:44 pm
    Nov 9, 2003 at 10:59 pm
  • Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I ...
    Renu rRenu r
    Nov 6, 2003 at 2:14 am
    Nov 7, 2003 at 3:09 am
  • As it was recently discussed, Insert /*+ append */ into select * from will produce minimum redo/undo if specified as "nologging". But, what if is index-organized table? Is it possible to achieve the ...
    Igor NeymanIgor Neyman
    Nov 5, 2003 at 1:59 pm
    Nov 5, 2003 at 7:44 pm
  • everything is analyzed. For all indexes, for all indexed columns. I used analyze. its the same as dbms_stats, just not as robust. I use it when I dont feel like typing out dbms_stats. Are there ...
    Ryan_oracle_at_cox.netRyan_oracle_at_cox.net
    Nov 4, 2003 at 8:29 pm
    Nov 5, 2003 at 6:54 pm
  • List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Nov 3, 2003 at 6:34 pm
    Nov 3, 2003 at 9:49 pm
  • Hi List, Almost fro all SQLs I am getting Prase count is same as Execute count. How to reduce parse count? We are using bind variable session_cached_cursors set to 100 call count cpu elapsed disk ...
    Jaysingh1_at_optonline.netJaysingh1_at_optonline.net
    Nov 26, 2003 at 6:14 pm
    Nov 30, 2003 at 7:59 pm
Nov 2003
12345…8
Group Navigation
period‹ prev | Nov 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions400
posts2,016
users284
websiteoracle.com

284 users for November 2003

Tanel Poder: 95 posts Mladen Gogala: 91 posts Jared.Still_at_radisys.com: 69 posts Jamadagni, Rajendra: 65 posts Ryan_oracle_at_cox.net: 60 posts DENNIS WILLIAMS: 45 posts Yong Huang: 43 posts Jared Still: 42 posts Bellow, Bambi: 40 posts Jesse, Rich: 40 posts Jonathan Gennick: 36 posts Daniel W. Fink: 32 posts Mladen Gogala: 32 posts Carel-Jan Engel: 29 posts Mercadante, Thomas F: 28 posts Khedr, Waleed: 26 posts Yechiel Adar: 25 posts Goulet, Dick: 24 posts Wolfgang Breitling: 23 posts Igor Neyman: 22 posts
show more
Archives