FAQ

Oracle > oracle-l > April 2000

Search Discussions

129 discussions - 356 posts

  • Why would you see an increase in fragmentation? You may see more fragments in the free space, but they will be coalescable. Part of Oracle's extent allocation algorithm is to coalesce free space as ...
    Jared StillJared Still
    Apr 26, 2000 at 2:30 pm
    Apr 27, 2000 at 5:27 pm
  • Hello All How can I tell what objects are in a particular tablespace eg select object_name, object_type from xxxx where tablespace_name = xxx using Oracle 8.0.4.0 TIA Saj Iqbal -- U-NET Ltd a VIA ...
    Sajid IqbalSajid Iqbal
    Apr 27, 2000 at 11:22 am
    Apr 28, 2000 at 6:44 pm
  • Hello all, I hate to bring up a topic that's been beaten to death but here goes. I passed OCP exam on Backup and Recovery this morning. I feel that I understand the do's and dont's of restore fairly ...
    Lisa_Koivu_at_gelco.comLisa_Koivu_at_gelco.com
    Apr 27, 2000 at 7:33 pm
    Apr 29, 2000 at 12:24 pm
  • Hi All, Our test team wants to run the following select every 5 seconds on our test database to monitor some stuff. What would be the impact and is it possible using dbms_job (Howto?) ...
    Jack van ZanenJack van Zanen
    Apr 26, 2000 at 10:12 am
    Apr 28, 2000 at 1:42 pm
  • Actually, no. A B-tree (or variation thereof) uses NO hashing techniques. That would be a Hash Index. A B-tree is a sorted (or ordered) index. Sameer: An index on columns A and B will obviously use ...
    Shawc_at_willis.comShawc_at_willis.com
    Apr 26, 2000 at 2:27 pm
    Apr 28, 2000 at 9:44 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. =_NextPart_001_01BFAFBB.399118BE Content-Type: text/plain ...
    Alvarez, CarlosAlvarez, Carlos
    Apr 26, 2000 at 8:08 pm
    Apr 28, 2000 at 2:17 pm
  • A monitoring tool that we use here is reporting that our database has a deadlock. We have not noticed it and there are no complaints. I challenged the company to tell me how they determine this. They ...
    Blair_at_pjm.comBlair_at_pjm.com
    Apr 26, 2000 at 3:48 pm
    Apr 28, 2000 at 1:48 am
  • Dear list members, I have created a catalog database name : rcat, Connect string: fis_test_rcat. The test database Name : rtest, Connect String: fis_test_rtest. Both are Oracle 8.1.5 databases(64 ...
    Janardhana BabuJanardhana Babu
    Apr 27, 2000 at 10:17 pm
    Apr 29, 2000 at 1:49 am
  • Hi list. Is it possible for Oracle to send email notification when a specified event occurs? I haven't found anything in the docs that describes this, and I really don't want to reinvent the wheel if ...
    Kevin MartinKevin Martin
    Apr 26, 2000 at 5:09 pm
    Apr 28, 2000 at 3:05 pm
  • I have the following script in a file: -- set verify off set feedback off accept SCHEMAOWNERFROM char prompt 'Enter Owner of the Schema you wish to move data FROM:' accept SCHEMAOWNERTO char prompt ...
    Guang MeiGuang Mei
    Apr 27, 2000 at 6:20 pm
    Apr 28, 2000 at 3:04 pm
  • Does anyone have the URL where I can purchase Steve Adams book TIA Saj Iqbal -- U-NET Ltd a VIA NET.WORKS Inc company Sajid Iqbal | Mail : sajid_at_u-net.net Database DBA/Developer | Ext : 4485 U-NET ...
    Sajid IqbalSajid Iqbal
    Apr 27, 2000 at 1:42 pm
    Apr 27, 2000 at 11:19 pm
  • Currently I'm starting to implement FIX (Fix Interface eXchange) Protocol in our Oracle 8i + Dev Server 6i Application. I'm new to FIX Protocol, so I will appreciate any experience, ideas, ...
    Harlin SetiadarmaHarlin Setiadarma
    Apr 27, 2000 at 1:38 am
    Apr 28, 2000 at 3:48 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0080_01BFB0A6.23FA9E30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Oracle Gurus I have ...
    Surjit SharmaSurjit Sharma
    Apr 27, 2000 at 2:10 pm
    Apr 28, 2000 at 11:30 pm
  • I'm trying to find a way to solve our ORA-4068 errors. We have persistent connections and the wonderful world of internet wants us to change the code in production pretty often. Does someone has done ...
    Paquette stephanePaquette stephane
    Apr 26, 2000 at 9:22 am
    Apr 27, 2000 at 9:38 pm
  • It appears that the transition from telelists.com to fatcity.com has gone pretty smoothly. There have been a few glitches, but everything worked out ok. I just want everyone to know that we owe a big ...
    Jared StillJared Still
    Apr 28, 2000 at 7:45 pm
    Apr 30, 2000 at 4:55 am
  • Hi Am I missing something here but it takes very long time for messages to make it to the list, or don't I get to see my own messages anymore? yesterday I did see them though. Jack De informatie ...
    Jack van ZanenJack van Zanen
    Apr 27, 2000 at 11:14 am
    Apr 28, 2000 at 1:38 pm
  • e have ORACLE 7.3.4.4 on SUN Solaris 2.6. I found there has a trace file generate by user application. The sql statement is following: SQL select * from ORA_KGLR7_IDL_SB4 2; ERROR: ORA-00600 ...
    LL
    Apr 27, 2000 at 8:12 pm
    Apr 29, 2000 at 10:52 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFAFD4.8EDFC8C0 Content-Type ...
    Alex HillmanAlex Hillman
    Apr 26, 2000 at 11:10 pm
    Apr 28, 2000 at 2:20 pm
  • test ignore
    Indy_Johal_at_prnewswire.comIndy_Johal_at_prnewswire.com
    Apr 26, 2000 at 9:11 pm
    Apr 30, 2000 at 2:58 pm
  • I'm trying to identify who has which privs in one of my instances. I have a handleful of users (schemas) that show they have been granted "HR_ALL" role. At this point in time, I'm not sure that this ...
    Charlie MenglerCharlie Mengler
    Apr 27, 2000 at 5:26 pm
    Apr 28, 2000 at 4:54 pm
  • I found a in-doute transaction through Instance Manager. The application could not query a table which was dead-locked by this in-doubt transaction. I knew nothing to clear this. I had to shutdown ...
    Cyhu_at_eachnet.comCyhu_at_eachnet.com
    Apr 28, 2000 at 3:59 am
    Apr 28, 2000 at 3:56 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0034_01BFB06C.30751800 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear DBA, I would ...
    Indra HarimurtiIndra Harimurti
    Apr 27, 2000 at 10:15 am
    Apr 28, 2000 at 1:36 am
  • Hi, Has anyone come across Segmentation Fault error with 8.1.6 Pro*C programs? The fault appears when a full path name of the Pro*C executable is longer than 54 characters. However, anything shorter ...
    Deshpande, KirtiDeshpande, Kirti
    Apr 26, 2000 at 1:00 pm
    Apr 27, 2000 at 10:14 pm
  • What is the reason for reducing the number of tablespaces and datafiles? Jared Jared Still Certified Oracle DBA and Part Time Perl Evangelist;-) Regence BlueCross BlueShield of Oregon ...
    Jared StillJared Still
    Apr 26, 2000 at 2:25 pm
    Apr 26, 2000 at 7:48 pm
  • Oracle 8.1.6 NT My problem is i had a disk failure during archiving prozess (Block Corrupted) I've changed the harddisk and know when i backup from rman i become the following error script: RMAN run ...
    Josef HuberJosef Huber
    Apr 20, 2000 at 3:21 pm
    Apr 26, 2000 at 5:43 pm
  • Solaris 2.6, using Veritas I am spending a lovely Sunday afternoon working on rearranging wasted space in our largest database. I deleted a large number of files ~30 min ago and the space does not ...
    Lisa_Koivu_at_gelco.comLisa_Koivu_at_gelco.com
    Apr 30, 2000 at 6:03 pm
    Apr 30, 2000 at 8:44 pm
  • Hi! I have SELECT like this SELECT c1.Id ID, c1.Name CNAME, t.name TNAME FROM blabla UNION ALL SELECT c1.Id ID, c1.Name CNAME, t.name TNAME FROM blabla2 MINUS SELECT c1.Id ID, c1.Name CNAME, t.name ...
    G.Plivna_at_itsystems.lvG.Plivna_at_itsystems.lv
    Apr 30, 2000 at 3:55 pm
    Apr 30, 2000 at 6:01 pm
  • Hi, I have a table in which i have to load 15 mill rows. So before start loading the data i disable the archiving in order to avoid all the space taken by the archive files. But when i run the loader ...
    salu Ullahsalu Ullah
    Apr 28, 2000 at 9:51 pm
    Apr 30, 2000 at 12:14 am
  • Hola! One of our data marts here had awful performance yesterday. The only thing that was different between yesterday and the previous days was that the load ran with all indexes, including bitmaps, ...
    Lisa_Koivu_at_gelco.comLisa_Koivu_at_gelco.com
    Apr 28, 2000 at 6:30 pm
    Apr 28, 2000 at 9:34 pm
  • Hey, I had the same experience!! And I was looking forward to seeing how someone else did this, DAMN. Actually I have the DB's sending all kinds of E-mail via a Pl/SQL package & a daily cron job ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Apr 28, 2000 at 2:16 pm
    Apr 28, 2000 at 7:25 pm
  • Has anyone succesfully installed WebDB 2.2 into an Oracle 8.1.6 repository on AIX 4.3??? Jeff T thomasje_at_tce.com
    Thomas JeffThomas Jeff
    Apr 27, 2000 at 8:29 pm
    Apr 28, 2000 at 6:58 pm
  • Anyone have a detailed 'get started' doc or some suggestions? A client wants to get started writing simple Java programs getting 'EMP and DEPT' type info from an Oracle DB. Any help would be ...
    Shaffer Earl EDShaffer Earl ED
    Apr 27, 2000 at 6:11 pm
    Apr 28, 2000 at 2:26 pm
  • Oracle support told me that the Intermedia background process connects in a special way to the db and because of that the on logon trigger is not fired. paquette stephane a icrit ...
    Paquette stephanePaquette stephane
    Apr 27, 2000 at 12:52 pm
    Apr 28, 2000 at 1:45 pm
  • Our networking folks have become highly involved in monitoring network performance for the high energy physics community. Part of this project is sending pings to the various labs and Universities ...
    Ian MacGregorIan MacGregor
    Apr 26, 2000 at 2:49 pm
    Apr 28, 2000 at 2:07 am
  • If you have not already done so, please take a look at Note # 45042.1 on Metalink (Archiver Best Practices). It offers some suggestions that may be of some help to you. Also, have you considered ...
    Deshpande, KirtiDeshpande, Kirti
    Apr 26, 2000 at 3:35 pm
    Apr 27, 2000 at 2:55 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_002B_01BFAF83.71859660 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Anyone have any ...
    RCRC
    Apr 26, 2000 at 5:29 pm
    Apr 26, 2000 at 11:40 pm
  • Hi: We have an oracle 8.1.5 db on Unix that I would like to reduce the number of oracle datafiles in order to free some disk space. After cleaning database up a little bit (deleted some old schemas), ...
    Guang MeiGuang Mei
    Apr 26, 2000 at 4:49 pm
    Apr 26, 2000 at 8:28 pm
  • Hi, I have more then 10 tables and are related by forign key combinations. I need a single query which dynamicaly fetch records from all tables, first see presence and then select only those tables ...
    Awaisb_at_paktel.comAwaisb_at_paktel.com
    Apr 26, 2000 at 10:34 am
    Apr 26, 2000 at 3:58 pm
  • Hello, NEW_TIME() expects source and target time zone for converting the date, but how can I get the local time zone string from Oracle? thanx, Marin "When brought to meaning, all importance becomes ...
    Marin DimitrovMarin Dimitrov
    Apr 26, 2000 at 1:25 pm
    Apr 26, 2000 at 3:33 pm
  • Mighty brave to write that considering the heat that the OCP program gets = around here. :) =20 How 'almost' are you? I just became 20% yesterday. 1 down 4 to go. :) Lisa 'Almost Certified' Koivu
    Stephen AndertStephen Andert
    Apr 28, 2000 at 11:04 pm
    Apr 30, 2000 at 2:31 pm
  • SSB3YW50IHRvIHF1ZXJ5IHdobyBpcyB0aGUgNTAwMDAwdGggdXNlci4NCkkgZXhlY3V0ZWQgdGhl IGZvbGxvd2luZyBzdGF0ZW1lbnRzLiAoIHVzZXJfaWQgaXMgdGhlIHByaW1hcnkga2V5IG9mDQp1 ...
    Cyhu_at_eachnet.comCyhu_at_eachnet.com
    Apr 30, 2000 at 2:32 am
    Apr 30, 2000 at 4:21 am
  • This is a multi-part message in MIME format. ------=_NextPart_000_0325_01BFB21A.BD8F9260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I have a ...
    Surjit SharmaSurjit Sharma
    Apr 29, 2000 at 10:37 am
    Apr 29, 2000 at 12:50 pm
  • I know that you can pass env vars from unix to sqlplus via: sqlplus name/password @file "$VAR1" In the called script, the value of $VAR1 can then be referenced as '&1'. This works fine, except when ...
    Bill BeckerBill Becker
    Apr 27, 2000 at 8:41 pm
    Apr 29, 2000 at 12:10 am
  • Gurus ... A single tablespace/datafile is showing a huge increase in phys reads since the end of March. The numbers are: DATE PHYRDS READ_PCT PHYWRTS WRITE_PCT Mar 22 3,863 0.21 651 0.23 Apr 28 ...
    Rsands_at_lendleaserei.comRsands_at_lendleaserei.com
    Apr 28, 2000 at 7:40 pm
    Apr 29, 2000 at 12:01 am
  • Can someone tell me what a dictionary managed tablespace is, a locally managed tablespace and, if not clear from the definitions, what the difference is. Thanks. Bill Wagman Univ. of California at ...
    Bill WagmanBill Wagman
    Apr 28, 2000 at 10:48 pm
    Apr 28, 2000 at 11:15 pm
  • What I can't figure out, is why Oracle would want to encourage fewer conferences by rolling them into one. More conferences = more publicity for their products. But then, I never did well in ...
    Burke, KathrynBurke, Kathryn
    Apr 28, 2000 at 7:06 pm
    Apr 28, 2000 at 10:53 pm
  • One of our rollback segments is showing as 'FULL'. There is a transaction running now for over 7 hours in that segment. Here is the message in the alert log: Failure to extend rollback segment 3 ...
    Achoto_at_american.eduAchoto_at_american.edu
    Apr 28, 2000 at 7:45 pm
    Apr 28, 2000 at 9:25 pm
  • Have you look into the view and see where is the error coming from? If the view is not compiled by alter view compile; that tell you something is wrong in that view. Winnie ...
    Winnie_Liu_at_infonet.comWinnie_Liu_at_infonet.com
    Apr 28, 2000 at 6:36 pm
    Apr 28, 2000 at 6:36 pm
  • We have ORACLE 8i on SUN Solaris. I has been successful setup data and index tablespace use LOCAL management. I wonder can "system" and "Rollbak" tablespace use LOCAL MAnagement? If yes, can you give ...
    LL
    Apr 28, 2000 at 3:13 pm
    Apr 28, 2000 at 6:05 pm
  • ORACLE 8.1.6 patch set already come out. The size on SUN Solaris is 86MB.
    LL
    Apr 27, 2000 at 9:52 pm
    Apr 28, 2000 at 5:36 pm
Apr 2000
123
Group Navigation
period‹ prev | Apr 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions129
posts356
users151
websiteoracle.com

151 users for April 2000

Jack van Zanen: 11 posts Jared Still: 11 posts Blair_at_pjm.com: 9 posts Deshpande, Kirti: 8 posts Lisa_Koivu_at_gelco.com: 8 posts Norwood Bradly A: 8 posts Ruth Gramolini: 8 posts Shawc_at_willis.com: 7 posts George.Brennan_at_warnermusic.com: 6 posts Guy ruth hammond: 6 posts Ian MacGregor: 6 posts Nguyen, Long: 6 posts Winnie_Liu_at_infonet.com: 6 posts Chuck Hamilton: 5 posts Cyhu_at_eachnet.com: 5 posts Janardhana Babu: 5 posts Kimberly Smith: 5 posts LBhat_at_LEVI.com: 5 posts Paquette stephane: 5 posts Sajid Iqbal: 5 posts
show more
Archives