FAQ

Oracle > oracle-l > June 2000

Search Discussions

926 discussions - 3,655 posts

  • Just out of curiosity I was wondering if we could mention our city, country etc., with our signatures. I know this is a large group with people from all around the world. It's another matter if ...
    Deepak SharmaDeepak Sharma
    Jun 9, 2000 at 3:00 pm
    Jun 18, 2000 at 7:44 am
  • Hi I am just enquiring about the average salary of an Oracle DBA in the US. I know that this is a broard topic and can vary from state to state, = experience, qualifications, etc. Someone with about ...
    Suhen PatherSuhen Pather
    Jun 29, 2000 at 1:16 pm
    Jun 30, 2000 at 11:14 pm
  • A junior DBA at one of my clients has just tried to register on Metalink and here is what he got : Request Failed We were unable to process your request at this time. Error occured while accessing ...
    Stephane FaroultStephane Faroult
    Jun 9, 2000 at 9:15 am
    Jun 13, 2000 at 4:38 pm
  • Just out of curiousity.....What kind of reporting tool is it??? Christine Turner Database Administrator IPS-Sendero Scottsdale, Arizona Phone: (800) 321-6899 ext. 3286 Fax: (480) 946-8224 E-mail ...
    Christine TurnerChristine Turner
    Jun 13, 2000 at 1:27 pm
    Jun 16, 2000 at 8:56 am
  • How many of the DBAs out there frankly work more than 40 Hrs a week on an average ? I have seen DBAs, specifically contrators (I'm one myself) put in 10 or 12 Hrs a day on the paper. In reality, it's ...
    Deepak SharmaDeepak Sharma
    Jun 2, 2000 at 4:30 pm
    Jun 9, 2000 at 11:13 am
  • Please settle a discussion amongst our DBA team: Is there ANY I/O that takes place to the database files (*.DBF) during a HOT backup? (That is, ALTER TABLESPACE BEGIN BACKUP). If not, how does the ...
    Dan.Hubler_at_midata.comDan.Hubler_at_midata.com
    Jun 19, 2000 at 5:04 pm
    Jun 23, 2000 at 6:49 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0011_01BFD3BA.BFA802A0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable HK ...
    YaxlYaxl
    Jun 11, 2000 at 7:36 am
    Jun 19, 2000 at 6:09 pm
  • Hope someone's around tonight... I have some datasets in the 'wrong' place, and the database is failing to open with this error: Database mounted. ORA-01157: cannot identify data file 1 - file not ...
    Linda HagedornLinda Hagedorn
    Jun 6, 2000 at 7:37 am
    Jun 6, 2000 at 1:17 pm
  • Guys, I know this has been covered before, but I cleared out my archive, and now=20= have no listing of it=2E I would be interested in getting your feedback as to=20= the tasks a DBA should have to ...
    Mleith_at_bradmark.co.ukMleith_at_bradmark.co.uk
    Jun 26, 2000 at 11:55 am
    Jun 30, 2000 at 6:05 pm
  • You think that's expensive? I'v converted the gallon to 3.78541 Liter, and the Dollar to f2.30 dutch guilder. 1 Liter of unleaded fuel costs f2.70 here so; The gallon would cost us here in Holland ...
    Eric LansuEric Lansu
    Jun 16, 2000 at 11:09 am
    Jun 19, 2000 at 5:18 pm
  • work 1 marriage 0 and getting worse. -- Bill Thater Certified ORACLE DBA Telergy, Inc. thaterw_at_telergy.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Do or not do. There is no try. -- Yoda ...
    Bill thaterBill thater
    Jun 1, 2000 at 1:25 pm
    Jun 5, 2000 at 4:00 pm
  • E-cmmmerce related firm in Boca Raton, Florida needs an Oracle DBA/Developer to join it's I.T. team. This position is new due to explosive growth and could lead to management, if desired. This is a ...
    OraStaffOraStaff
    Jun 7, 2000 at 9:18 pm
    Jun 9, 2000 at 2:15 pm
  • I'm writing a magazine article on locally managed tablespaces, and I'd like to get some opinions and feedback from anyone who might be using these in a production environment. If you are using ...
    Jonathan GennickJonathan Gennick
    Jun 15, 2000 at 6:42 pm
    Jun 23, 2000 at 2:31 am
  • Kirsten, has there been a logswitch? If not, the dir can be empty. You can try ALTER SYSTEM SWITCH LOGFILE to force a logswitch and see if there is a file in the logdir. Regards, Richard Klavers.
    Klavers, RichardKlavers, Richard
    Jun 6, 2000 at 9:47 am
    Jun 21, 2000 at 7:01 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0009_01BFD49D.5DAA9E80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If your an Oracle ...
    Mr. MajesticMr. Majestic
    Jun 12, 2000 at 10:38 pm
    Jun 14, 2000 at 10:45 am
  • Listers, My first inclination is to wonder if my ISP is having problems; but, before going to them, I was wondering if others are seeing replies to messages prior to the original message appearing on ...
    Larry G. ElkinsLarry G. Elkins
    Jun 14, 2000 at 1:06 am
    Jun 15, 2000 at 6:17 pm
  • Recently on one of our test systems the Buffer Cache Hit Ratio was showing 80%. I increased db_block_buffers from 6000 to 16000, and the after that the hit ratio has dropped to 55%. It seemed strange ...
    Deepak SharmaDeepak Sharma
    Jun 21, 2000 at 4:07 pm
    Jun 24, 2000 at 9:19 pm
  • Hi All: There is a question about performance. Table name : subscriber, primary key : subscr_id, with over 5000000 records . CASE 1 : select * from subscriber; (FULL TABLE SCAN) CASE 2 : select * ...
    ���J�����J��
    Jun 21, 2000 at 2:22 am
    Jun 22, 2000 at 1:27 pm
  • A quick question for all you Oracle/UNIX people...... I need to create a file with the permissions 775 ( rwxrwxr-x ) and I have set the umask to what all the books recommend.... with no luck.... The ...
    Stephen J PalmerStephen J Palmer
    Jun 2, 2000 at 3:08 pm
    Jun 27, 2000 at 3:18 pm
  • Chris brings up something that I was just thinking about the other day. There are some key things about Oracle that system administrators may not understand by default. What are they? What do you ...
    Jonathan GennickJonathan Gennick
    Jun 13, 2000 at 3:45 pm
    Jun 17, 2000 at 1:53 am
  • --0-1714636915-960842030=:19079 Content-Type: text/plain; charset=us-ascii Here is the list of members who replied to this thread so far. There may have been unintentional errors/omissions, such as ...
    Deepak SharmaDeepak Sharma
    Jun 12, 2000 at 8:33 pm
    Jun 14, 2000 at 8:14 pm
  • I have this error in the alert log (7.3.2.1.0 on AIX): ORA-00600: internal error code, arguments: [3382], [1], [134231590], [134235708], [], [], [], [] After that, there are other errors and my ...
    Steven MonaghanSteven Monaghan
    Jun 8, 2000 at 12:49 pm
    Jun 9, 2000 at 7:16 am
  • Amen Patrice! Your spouse is extremely lucky! From: Boivin, Patrice J[SMTP:BoivinP_at_mar.dfo-mpo.gc.ca] Reply To: ORACLE-L_at_fatcity.com Sent: Thursday, June 01, 2000 8:36 AM To: Multiple ...
    Christine TurnerChristine Turner
    Jun 1, 2000 at 10:12 am
    Jun 2, 2000 at 4:20 pm
  • I've seen a number of threads at various stages about whether OCP is of any real practical value. For example some have expressed the point of view that it's a memory test and whilst it's fine to ...
    O'Neill, SeanO'Neill, Sean
    Jun 27, 2000 at 8:14 am
    Jun 30, 2000 at 6:38 pm
  • I seem to have lost the ability to reply direct to the originator of any message. Regardless of whether I pick reply or reply to all the only entry in the 'to' list is ORACLE-L_at_fatcity.com. On ...
    Diane WhiteheadDiane Whitehead
    Jun 28, 2000 at 2:51 pm
    Jun 30, 2000 at 2:18 pm
  • Hi All, This is more of a survey than a question, but how many of you DBAs out there who are administering production databases that don't have a test database to go with it? We are a new but rapidly ...
    David LeeDavid Lee
    Jun 22, 2000 at 6:11 pm
    Jun 23, 2000 at 8:49 pm
  • How many people runs Oracle on a Linux? What type experience good, bad, problems? Regards Phil Tully
    Philip J. TullyPhilip J. Tully
    Jun 12, 2000 at 6:45 pm
    Jun 19, 2000 at 7:06 pm
  • Good morning - I've created about 5 databases in the last week. Why is it that I can set log_archive_start=TRUE but when the database comes up the first time it's in noarchive mode? I have to ...
    Lisa_Koivu_at_gelco.comLisa_Koivu_at_gelco.com
    Jun 13, 2000 at 1:26 pm
    Jun 15, 2000 at 7:44 pm
  • After waiting on the phone to support for an inordinate amount of time I jokingly asked the support rep if they had been told not to answer the phone for 30 minutes in an attempt to encourage people ...
    Bill WagmanBill Wagman
    Jun 8, 2000 at 12:49 am
    Jun 13, 2000 at 2:55 am
  • Hi Gurus, which privilege(s) should I give a user to authorize it to truncate a table belonging to another schema. e.g. how could TOTO truncate SCOTT.EMP ? TIA Franck
    Franck_Vasseur_at_ingerrand.comFranck_Vasseur_at_ingerrand.com
    Jun 9, 2000 at 1:12 pm
    Jun 9, 2000 at 11:00 pm
  • Okay, even goddesses need help sometimes :) I KNOW I can create bitmap indexes in 7.3.4, I've done it at other jobs. But for the life of me, I can't remember what it is that I need to do that I am ...
    Rachel CarmichaelRachel Carmichael
    Jun 23, 2000 at 9:06 am
    Jun 25, 2000 at 5:31 pm
  • Hi All, Since yesterday, I am not able to logon to Metalink...it says "The requested item could not be loaded by the proxy Document contains no data" My proxy server is up. I could visit other sites ...
    Vidya KalyanaramanVidya Kalyanaraman
    Jun 21, 2000 at 7:11 pm
    Jun 22, 2000 at 2:59 pm
  • Hi Fellow DBAs Today I created a TEMP Tablespace in TEST env. Dropped the Tablespace, and again I tried to create the same tablespace (with same datafile), it gives error. I checked dba_data_files ...
    Rajesh DayalRajesh Dayal
    Jun 21, 2000 at 10:14 am
    Jun 22, 2000 at 11:07 am
  • I tried to increase the db_block_size from 8k to 16k. What's the maximum block size allowed on NT 4 serverice pack 5 and Soloris 2.4. Thanks. Eric Fang
    Eric FangEric Fang
    Jun 6, 2000 at 6:00 pm
    Jun 15, 2000 at 7:11 am
  • a little bird once told me that resize/autoextend df has known to lead towards dB corruptions .. anyone out there seen that happen to their db"s tia -deepAk -----Original Message----- From ...
    Thapliyal, DeepakThapliyal, Deepak
    Jun 9, 2000 at 6:21 pm
    Jun 12, 2000 at 4:21 pm
  • Okay, we finally got enough storage space to hold an export of our datawarehouse so I'm going to change the block size from 4 to 16. Obviously I'm testing this on a small play database first, but ...
    Miller, JayMiller, Jay
    Jun 6, 2000 at 3:30 pm
    Jun 8, 2000 at 1:36 am
  • Hi all, I have a small basic question. If I say Alter Tablespace 't.s name' Begin Backup, where is this backup getting stored. Is there any init.ora parameter which controls this one. couldn't find ...
    Mayan CheriyaMayan Cheriya
    Jun 3, 2000 at 3:58 am
    Jun 7, 2000 at 5:52 pm
  • Here I am.... A female DBA, single mom of a wonderful 2 1/2 year old little boy. I have no one to call "the" or "my" except my son. Who in fact keeps me as busy as my job does. Talk about 24/7!!!! ...
    Christine TurnerChristine Turner
    Jun 1, 2000 at 4:23 pm
    Jun 2, 2000 at 9:23 pm
  • 13

    test

    http://babelfish.altavista.com the rain in spain falls mainly on the plain la lluvia en Espa=F1a cae principalmente en el llano my husband is a warm, fuzzy huggy bear mi marido es caliente, borroso ...
    Eric D. PierceEric D. Pierce
    Jun 8, 2000 at 1:00 am
    Jun 29, 2000 at 3:41 pm
  • Hi guys In a database which i am desiging to prevent users from entering blank spaces into columns i am also adding a check condition like check column < ' ' to almost every column.. Does this add to ...
    Anand RamanAnand Raman
    Jun 13, 2000 at 5:43 am
    Jun 14, 2000 at 2:06 pm
  • Looking for some information on the following: We had an incident last week where an Oracle instance (7.3.4.4) on NT was running into problems acquiring space for additional extents on the defined ...
    Dan.Hubler_at_midata.comDan.Hubler_at_midata.com
    Jun 5, 2000 at 5:52 pm
    Jun 12, 2000 at 2:15 am
  • Hello, Is there a way to set the archive destination on a system which is running, or will I have to change the config file and shutdown/startup the database? Thanks, Linda
    Linda HagedornLinda Hagedorn
    Jun 13, 2000 at 7:45 pm
    Jun 15, 2000 at 3:51 pm
  • How can you tell that it is time to rebuild an index? What are the various signs?
    Connie MillikenConnie Milliken
    Jun 8, 2000 at 3:55 pm
    Jun 10, 2000 at 4:54 am
  • Hi all, I'm more on the db side than on the unix side. This is Oracle 8.1.5 on Solaris 2.6. Oracle intallation guide says to start Oracle in level 2 : /etc/rc2.d/... Wouldn't be better to start ...
    Paquette stephanePaquette stephane
    Jun 5, 2000 at 2:10 pm
    Jun 7, 2000 at 12:44 pm
  • Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
    vivek Manianvivek Manian
    Jun 1, 2000 at 10:05 pm
    Jun 30, 2000 at 12:02 am
  • Hi All, I have to move all indexes of a schema from one Tablespace to another Tablespace (currently Tables as well as Indexes are in the same TS;-((. But when I query DBA_OBJECTS/DBA_INDEXES for that ...
    Rajesh DayalRajesh Dayal
    Jun 27, 2000 at 6:00 am
    Jun 28, 2000 at 1:15 pm
  • Hi all, I'm new to DBA related jobs. My boss wants to grant sysdba to a user . regards, Raman
    Raman.yagna_at_db.comRaman.yagna_at_db.com
    Jun 27, 2000 at 6:22 am
    Jun 27, 2000 at 7:00 pm
  • I inherited a production, 'mission critical' (according to damagement) database 'running' on an NT server connected to an EMC box. We kept experiencing corrupt blocks, and after many q&a sessions ...
    Rsands_at_lendleaserei.comRsands_at_lendleaserei.com
    Jun 12, 2000 at 1:52 pm
    Jun 21, 2000 at 9:31 pm
  • Hello, I'm having a hang/wait problem with one of my systems, and this is the information I've gleaned. I want to alter a table nologging: SVRMGR alter table bvadmin.MR_purchased_items nologging ...
    Linda HagedornLinda Hagedorn
    Jun 9, 2000 at 6:59 pm
    Jun 14, 2000 at 2:40 pm
  • Can anybody teach me how to findout current month without using sysdate. Regards Veera
    Veera PrasadVeera Prasad
    Jun 12, 2000 at 2:49 pm
    Jun 13, 2000 at 7:02 pm
Jun 2000
12345…19
Group Navigation
period‹ prev | Jun 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions926
posts3,655
users555
websiteoracle.com

555 users for June 2000

Rachel Carmichael: 116 posts Dgoulet_at_vicr.com: 106 posts Jared Still: 83 posts Winnie_Liu_at_infonet.com: 74 posts Steve Orr: 64 posts Ruth Gramolini: 60 posts Eric D. Pierce: 55 posts Lisa_Koivu_at_gelco.com: 44 posts Singla, Sanjeev: 42 posts Gurgaon, DBA (CAP, GECSI, CONTRACTOR): 41 posts Guy ruth hammond: 39 posts Gaja Krishna Vaidyanatha: 38 posts Jonathan Gennick: 37 posts Thapliyal, Deepak: 36 posts Boivin, Patrice J: 35 posts Miller, Jay: 35 posts Chuck Hamilton: 34 posts A. Bardeen: 33 posts Chris Royce: 33 posts Deshpande, Kirti: 32 posts
show more
Archives