FAQ

Oracle > oracle-l > May 2003

Search Discussions

567 discussions - 2,891 posts

  • So, did you get to see Oracle 10 in action at the IOUG? I wasn't there, but am curious. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET ...
    Boivin, Patrice JBoivin, Patrice J
    May 5, 2003 at 1:31 pm
    May 7, 2003 at 6:51 am
  • Okay, I have a developer here who has been reading the docs (this can be dangerous!) we are adding functionality to one of our applications, this will involve using multiple fulfillment houses, so ...
    Rachel CarmichaelRachel Carmichael
    May 28, 2003 at 10:59 am
    May 29, 2003 at 7:31 pm
  • Hi All, In Oracle8i Backup & Recovery Handbook pg 13 it states "Finally, online redo log files should never be backed up....So, it is good practice not to back up online log files for ANY kind of ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    May 22, 2003 at 6:27 pm
    May 26, 2003 at 6:31 pm
  • Though I have only been to three IOUG conferences prior to this year's, I would have to say that this has been one of the best, if not *the* best, IOUG I have attended. Great technical content, more ...
    Jared StillJared Still
    May 3, 2003 at 9:51 pm
    May 8, 2003 at 5:07 pm
  • Hello Gurus, I've been wondering about something, at best this can be dangerous :-) Is anyone else been doing some serious career path evaluation? I have been wondering seriously about the future of ...
    Denham EvaDenham Eva
    May 6, 2003 at 1:21 pm
    May 8, 2003 at 1:16 pm
  • Hi all, hope you can give some input ideas. I am in the process of designing a system for a client of ours for a proposal The sizing information I have been given is as follows. 58.1 million ...
    George.Leonard_at_za.didata.comGeorge.Leonard_at_za.didata.com
    May 20, 2003 at 7:06 am
    May 27, 2003 at 7:31 am
  • anyone considered going beyond the DB market? Im doing a masters in Software Engineering and when Im done may do one in Computer Science or do a Ph.D. in Information Technology. Yeah its a bit of ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    May 6, 2003 at 7:58 pm
    May 8, 2003 at 4:11 pm
  • I'm curious to know whether anyone out there has seen a comparison discussing the pros and cons and/or results of any simulation tests that compare the speed with which data can be loaded into a ...
    Carol LegrosCarol Legros
    May 14, 2003 at 9:57 pm
    May 31, 2003 at 11:04 pm
  • Dear All, how can i check if my buffer cache is bigger than necessary ?oracle db version is 8.1.7. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar ...
    Arvind KumarArvind Kumar
    May 5, 2003 at 10:41 am
    May 12, 2003 at 9:26 pm
  • tablespace name needs to be unique. So we import a tablespace. Drop the old one. Rename the new one to the name of the old one. Allows us to keep the system in real time. Otherwise we have to take ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    May 9, 2003 at 3:42 pm
    May 10, 2003 at 6:11 pm
  • Hi Jeremiah, Now that was a RIGHTEOUS rant I can identify with! A glorious indignation indeed. Don't you just want to stick your head out the window and shout: "I'm as mad a hell and I'm not taking ...
    Orr, SteveOrr, Steve
    May 20, 2003 at 6:13 pm
    May 31, 2003 at 4:49 am
  • Hi List, DB 8.1.7.4.0 on Sun sparc solaris 2.6 This is oracle applications 11.5.4 One of the program was running for very long time. So checked out v$session_wait for that perticular session. It was ...
    DilipDilip
    May 14, 2003 at 10:36 am
    May 29, 2003 at 3:19 am
  • Is there a way to track the activity associated with a batch job, to see: the execution plans and costs for all the code it submits memory used cpu used time to complete. I like explain plan very ...
    Boivin, Patrice JBoivin, Patrice J
    May 6, 2003 at 1:26 pm
    May 16, 2003 at 4:31 am
  • Hi listers, I'am in oracle 8i on window 2000 server. In this month my database down almost everyday and the only thing I can do is stop dan restart the database and it makes me curious what's going ...
    Zions swordfishZions swordfish
    May 12, 2003 at 3:41 pm
    May 17, 2003 at 6:56 am
  • Hello All, I am looking into options for creating a copy of a production database (Oracle 8.1.7 Enterprise Edition, Windows 2000) for reporting/querying purposes. The database should be hosted on a ...
    Patterson, MarkPatterson, Mark
    May 2, 2003 at 12:37 pm
    May 9, 2003 at 3:21 am
  • With the career path discussion in full swing I would like to remind folks that (IMHO) we are the keepers of the data and as such we have a duty. A duty to maintain an ethical approach to performing ...
    Odland, BradOdland, Brad
    May 7, 2003 at 8:32 pm
    May 8, 2003 at 9:43 pm
  • 19

    V$

    I've just installed Oracle 91 on my machine. Earlier I used to see the V$ views but am no longer able to see them. Is there a way I can find out if any objects have been deleted or not and such ...
    Amit ValiaAmit Valia
    May 6, 2003 at 7:03 am
    May 9, 2003 at 4:06 am
  • After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as the options for tablespace management. Does anyone have any bad experiences with these? AUTOALLOCATE seems to come up with ...
    Thomas DayThomas Day
    May 29, 2003 at 7:25 pm
    May 31, 2003 at 4:04 pm
  • Since there does not appear to be a version of dbd-oracle for Perl 5.8 on windows, any suggestions on how to access Oracle from Perl. I do not have a C compiler and thus can not compile the source ...
    Jeffrey BeckstromJeffrey Beckstrom
    May 23, 2003 at 1:55 pm
    May 27, 2003 at 7:59 am
  • Looking for advise on storing bits in the Oracle database column.The scenario goes like this: define column statusFlag NUMBER(x)statusFlag can represent the following: verified set to 1nonverified ...
    Laura penaLaura pena
    May 7, 2003 at 2:22 pm
    May 8, 2003 at 10:48 pm
  • What is the way to shrink temp tablespace . I tried alter tablespace colesce .. doesn't seems to work and I can't bring down the db . -ak -- Please see the official ORACLE-L FAQ ...
    AKAK
    May 16, 2003 at 4:42 pm
    May 23, 2003 at 7:27 pm
  • I went to the ioug webpage. anyway to buy that CD? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: http://www.fatcity.com San Diego, California -- Mailing list and web ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    May 7, 2003 at 2:22 pm
    May 22, 2003 at 7:51 am
  • Here is what was caught by my co-worker recently. One of the Developers, of our Preferred Vendor, actually wrote this stuff. This is invoked by the one of the forms on the intranet Web application. I ...
    Deshpande, KirtiDeshpande, Kirti
    May 9, 2003 at 4:21 pm
    May 10, 2003 at 3:14 am
  • 16

    10i

    Got my first look at the 10i beta last night. I can't tell you much about it except to say that looking at some of the new stuff.... oooooooohhhhhhhhhhhhhhhhhhhhh........;-) While I'm certain many of ...
    Freeman Robert - ILFreeman Robert - IL
    May 29, 2003 at 3:54 pm
    May 31, 2003 at 3:59 am
  • Let me give you the scenarios. Maybe I can get a good explanation from someone. Tablespace A locally managed uniform extents size 512M. Tablespace B locally managed uniforma extents size 1M. Create ...
    Rick StephensonRick Stephenson
    May 19, 2003 at 8:41 pm
    May 21, 2003 at 1:21 pm
  • We are using dictionary managed tablespacse and yes I know I should use locally managed, but I am not allowed to change. I have significant fragmentation. I moved all my tables to a new tablespace, ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    May 15, 2003 at 1:52 pm
    May 17, 2003 at 5:56 pm
  • OK, i've been told by several people [i do question their sanuty.;-)] that i should present at one of these conference things. so, from you experienced presenters, what's the precedure? any tips? am ...
    Bill thaterBill thater
    May 7, 2003 at 5:26 pm
    May 9, 2003 at 1:31 pm
  • Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A ...
    Walter KWalter K
    May 29, 2003 at 4:54 pm
    May 31, 2003 at 9:39 pm
  • The past few months I've been wondering when MySQL would start putting pressure on Oracle in the same way that Linux is putting pressure on MS. Maybe sooner than you think ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    May 28, 2003 at 6:01 pm
    May 29, 2003 at 10:25 pm
  • Hello everyone, Is anyone using dbms_stats and gather stale or gather auto in 9.2? I'm trying to use dbms_stats gather schema stats with the stale option and it just isn't working in 8.1.7.4. This is ...
    Koivu, LisaKoivu, Lisa
    May 29, 2003 at 2:24 am
    May 29, 2003 at 8:42 pm
  • Most of us have used named pipe on unix with export/import, it's fairly easy. Has anyone done this with named pipes on Windows 2000/NT? ( not as easy ) I'm considering putting together scripts to use ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    May 15, 2003 at 11:06 pm
    May 20, 2003 at 11:16 pm
  • Hmm, Oracle 10 and Star Trek mentioned in the same message... Perhaps I should start the rumour that SYSDATE will be replaced by STARDATE in Oracle 10? What other rumours have people heard? Cheers, ...
    Mark RichardMark Richard
    May 1, 2003 at 11:21 pm
    May 9, 2003 at 6:38 pm
  • Hi all, Is there any "best practice" regarding practical limits on PL/SQL tables? We've got an issue here which may potentially invalidate data, no error messages. Here is the case: Oracle9i ...
    Gorbounov,VadimGorbounov,Vadim
    May 20, 2003 at 3:16 pm
    May 28, 2003 at 8:54 pm
  • Dear All, Can somebody help me on this question ? I have a db server with ip address, say ip1 and an application server with ip address say, ip2 ? Can I say in my Oracle db server that I will accept ...
    Pradeep_at_ibsplc.comPradeep_at_ibsplc.com
    May 22, 2003 at 1:11 pm
    May 23, 2003 at 11:51 am
  • List, There are a lot of prime job openings that I am interested but they require a Security Clearance. If I have a job that provided the security clearance I am all set....But if I do not need one ...
    Ron RogersRon Rogers
    May 7, 2003 at 7:07 pm
    May 9, 2003 at 2:21 pm
  • HI everyone I recently joined the list, and I think it is meant only for DBAs. Is that true? Also, can anyone suggest any similar mailing list meant for Oracle developers (that is those working with ...
    Ajay K. GargAjay K. Garg
    May 29, 2003 at 12:45 pm
    May 29, 2003 at 9:26 pm
  • 13

    flag

    Would you use a number or char for a flag in a table? Would you use a char since it's one byte and a number is 22 bytes? Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- ...
    David TurnerDavid Turner
    May 21, 2003 at 8:16 pm
    May 23, 2003 at 7:21 pm
  • Hi list, I came across a question while preparing for my exam QUESTION : You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample ...
    Bulbultyagi_at_now-india.net.inBulbultyagi_at_now-india.net.in
    May 21, 2003 at 3:01 pm
    May 22, 2003 at 7:53 pm
  • Someone telling you that the cpu should be at zero percent is just being silly, however running at 100% is not an optimum condition. As one of the evil Sys Admins that you mentioned, I personally ...
    Chris BerryChris Berry
    May 20, 2003 at 2:26 am
    May 21, 2003 at 1:21 am
  • Hi, Some weeks ago, I post a question on the future of hints. Today, as I was browsing on asktom, I found this : In Oracle Applications development (11i apps - HR, CRM, etc) Hints are strictly ...
    Stephane PaquetteStephane Paquette
    May 14, 2003 at 8:21 pm
    May 16, 2003 at 2:31 pm
  • I have a strange tuning issue, that I have not been able to resolve. Since this is the first time I have had to progress further down the statement tuning road than 'explain plan', I am not even sure ...
    Steve McClureSteve McClure
    May 9, 2003 at 11:31 pm
    May 15, 2003 at 5:06 pm
  • Guys, I felt like I have been reading your work, studying your white papers, worshiping many of you from afar. Then at the IOUG I finally met you. I was so pleasantly surprised by your ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    May 2, 2003 at 7:06 pm
    May 7, 2003 at 5:47 pm
  • I have table invoice with columns ( organization, invdate, amount ) there are tons of query which do search on organization and invdate. But there is only one distinct value for organization . which ...
    AKAK
    May 2, 2003 at 8:26 pm
    May 6, 2003 at 8:26 pm
  • Speaking of GUIs, lets hear it for the most horrendous GUI of them all, the nearly unusable Oracle Universal Installer. Although I avoid it religiously, opting to copy around tarballs instead, I ...
    Jeremiah WiltonJeremiah Wilton
    May 20, 2003 at 5:26 pm
    May 31, 2003 at 4:59 am
  • Dear All, how can i check if my buffer cache is bigger than necessary ?oracle db version is 8.1.7. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar ...
    Arvind KumarArvind Kumar
    May 6, 2003 at 9:36 am
    May 12, 2003 at 10:41 pm
  • I've just discovered why TUSC has such a great opinion of itself. From the website: At TUSC, if we identify a project where the odds of success are low and we won't be able to sustain the type of ...
    Jonathan LewisJonathan Lewis
    May 11, 2003 at 8:01 pm
    May 12, 2003 at 10:41 pm
  • Guys, create table Tab1 ( name varchar2(100),age int,state varchar2(100),country varchar2(100)); insert into tab1 values ('SCOTT',25,'TN','India'); I have 20,00,000 records like above. create index ...
    Prem Khanna JPrem Khanna J
    May 29, 2003 at 6:54 am
    May 30, 2003 at 1:39 pm
  • IBM and Oracle are contesting whose database is easier to manage. http://www.esj.com/news/article.asp?EditorialsID=559 (easier to read if you go to the bottom and select printer-friendly) But wait, ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    May 27, 2003 at 1:45 pm
    May 28, 2003 at 11:39 pm
  • Hi all here is a question Q. You need to determine the amount of space currently used in each tablespace. You can retrieve this information in a single SQL statment using only one DBA view in the ...
    Bulbultyagi_at_now-india.net.inBulbultyagi_at_now-india.net.in
    May 22, 2003 at 6:31 am
    May 23, 2003 at 3:31 pm
  • Hello list the "backup and recovery concepts" manual says :"Each redo record contains both the old and the new values. Oracle also records the old value to an undo block located either in a rollback ...
    Bulbultyagi_at_now-india.net.inBulbultyagi_at_now-india.net.in
    May 18, 2003 at 2:08 am
    May 20, 2003 at 7:11 pm
May 2003
12345…12
Group Navigation
period‹ prev | May 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions567
posts2,891
users374
websiteoracle.com

374 users for May 2003

DENNIS WILLIAMS: 157 posts Jamadagni, Rajendra: 103 posts Ryan: 90 posts Jared.Still_at_radisys.com: 83 posts Paula_Stankus_at_doh.state.fl.us: 78 posts Deshpande, Kirti: 61 posts Rachel Carmichael: 57 posts Gogala, Mladen: 55 posts Mladen Gogala: 50 posts Goulet, Dick: 45 posts Boivin, Patrice J: 41 posts Jared Still: 39 posts Orr, Steve: 39 posts Stephen Lee: 36 posts Tim Gorman: 34 posts Mercadante, Thomas F: 33 posts Bulbultyagi_at_now-india.net.in: 32 posts Khedr, Waleed: 32 posts Ron Rogers: 30 posts Arup Nanda: 29 posts
show more
Archives