FAQ

Search Discussions

664 discussions - 2,091 posts

  • How do you protect your "private life" time from your role of DBA?. Do you have formalised detailed job contracts with your employer covering such issues?. What perks/incentives do you receive for ...
    O'Neill, SeanO'Neill, Sean
    Dec 20, 2000 at 4:22 pm
    Dec 27, 2000 at 6:02 pm
  • Hi friends! There is a lots of talk about Paper DBAs on this message board. With due respect to all the veteran DBAs without OCP and new DBAs with OCP, I would like to make few comments from my own ...
    Rama MalladiRama Malladi
    Dec 4, 2000 at 10:51 pm
    Dec 7, 2000 at 3:25 am
  • guys we are goona have OPS setup soon and I am goona maintain it. this is scaring.... can u just brief out the difficulties that u face with raw.. i was told that sun cluster is not administer ...
    Ravindra BasavarajaRavindra Basavaraja
    Dec 4, 2000 at 4:27 pm
    Dec 8, 2000 at 4:56 am
  • and when he's not connected to the network(while at work or at home), he tries to connect and gets a 3113 error, i'm sure its a networking thing but since i'm remote(and its NT) i can't exactly logon ...
    Joseph S. TestaJoseph S. Testa
    Dec 19, 2000 at 7:22 pm
    Dec 29, 2000 at 1:59 pm
  • i have a user named abc ... he had a password of 22xyz ... i had to temporarily change the password to abc_temp ... i tried to change the password back to 22xyz ... and get the following error .. ...
    Glasrot, NechamaGlasrot, Nechama
    Dec 28, 2000 at 7:08 pm
    Dec 29, 2000 at 1:46 pm
  • hello, how I can solve this problem that always appears in the file trace: "ORA-12571: TNS: 'chec ... l''criture du paquet", I use oracle 7.3 for netware; thanks
    GP2Z/INF/RAHALGP2Z/INF/RAHAL
    Dec 4, 2000 at 9:20 am
    Dec 29, 2000 at 5:18 am
  • All, =20 I have been made aware of a problem at our site. =20 Apparently we have a DB that was historically created with the wrong character set. It should be WE8ISO8859P1 but has been set at ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Dec 15, 2000 at 8:37 am
    Dec 15, 2000 at 8:16 pm
  • Hi! Is there any 'standard' about the physical location of servers? I mean some 'standard' which takes care of issues of safety like fire,disaster..etc... Not to speak of issues of how to move in and ...
    Cyril ThankappanCyril Thankappan
    Dec 8, 2000 at 7:21 am
    Dec 9, 2000 at 1:30 am
  • Speaking of beer... It's spool-down time here; management just brought in beer and pizza, so I'm currently sipping on a cold one whilst staring at my monitor pretending to get work done. I'm not sure ...
    Weaver, WaltWeaver, Walt
    Dec 21, 2000 at 7:54 pm
    Dec 22, 2000 at 8:35 pm
  • Hello again list, Anyone out there familar with the 3-dimensional data reporting tool called Cognos? Can anyone direct me to a list of site or consultant who might specialize in the area? Thanks, ...
    Hannah.M.Doran_at_sb.comHannah.M.Doran_at_sb.com
    Dec 14, 2000 at 1:09 pm
    Dec 15, 2000 at 3:39 pm
  • Hello, I have a PL/SQL procedure that send me one unique number. Sometime I can receive more than one number back. How can I read all this answer from Java ? Have someone a hint. Today I can only ...
    Henrik EkenbergHenrik Ekenberg
    Dec 1, 2000 at 3:01 pm
    Dec 5, 2000 at 12:48 pm
  • List, i quick question... the Doc. does not mention anything regarding the online redo logs of STANDBY DB !! i have copied all the DB files to the standby host, but what about the online redo files ...
    RahulRahul
    Dec 15, 2000 at 8:10 am
    Dec 16, 2000 at 11:04 pm
  • Alex, Alex Hillman wrote: This list is for free - *you* can _choose_ to participate or not, and choose whether you want to ask/answer questions. There have been so many threads of late in this list ...
    John KanagarajJohn Kanagaraj
    Dec 12, 2000 at 12:10 am
    Dec 15, 2000 at 7:20 pm
  • hi all, Thanks in advance. how to create new user for the newly created database.. with regards, siva
    SivaSiva
    Dec 29, 2000 at 3:19 am
    Dec 29, 2000 at 5:35 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0034_01C06502.3EBC9460 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Can anyone tell ...
    Sanjay KumarSanjay Kumar
    Dec 13, 2000 at 8:43 pm
    Dec 20, 2000 at 2:50 am
  • Hello, does anybody know if there is a way to change the name of an already created tablespace ? Oracle version is 8.0.6. Thanks, Yannick
    Yannick TirefordYannick Tireford
    Dec 6, 2000 at 2:49 pm
    Dec 12, 2000 at 3:19 am
  • Hi list: I'd like to know when should I colaesce an index? When should I rebuild it? What views should I be looking at? thank you
    Pablo kskskskPablo ksksksk
    Dec 21, 2000 at 7:51 pm
    Dec 27, 2000 at 1:49 pm
  • Hi all, Does anyone out there have any suggestions as to why it would take 12 minutes to drop tables. Where should I look first? Thanks Larry
    Larry TaylorLarry Taylor
    Dec 19, 2000 at 7:13 pm
    Dec 22, 2000 at 3:09 pm
  • Hello everyone, A couple of days ago I had posted a response to someone's query about copy latches and in that discussion I had mentioned that the 1/3 full event of the redo log buffer will really ...
    Gaja Krishna VaidyanathaGaja Krishna Vaidyanatha
    Dec 13, 2000 at 5:43 pm
    Dec 18, 2000 at 3:44 am
  • The dba left and now we are stuck! We know the SYSTEM password, but we don't know the SYS password. Is there= any way that this can be "hacked" (Ver 8.0.5.1.1) so we can know what it= is? Yes, we ...
    Don Dealy IIDon Dealy II
    Dec 4, 2000 at 6:11 am
    Dec 16, 2000 at 5:06 am
  • I would like to be convinced one way or the other on the following issue : What is the best way to take a database down for a cold backup ? SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN NORMAL or SHUTDOWN ...
    Pat Howe - ContractorPat Howe - Contractor
    Dec 7, 2000 at 7:01 pm
    Dec 11, 2000 at 12:45 am
  • Hi list, I have a NT Box with Oracle 7.3.4 and Oracle 8.1.5 installed. Now I = like to install Oracle 8.1.6 on the same box (no upgrade, parallel to the other versions). Anyone had done the same or ...
    Schoen VolkerSchoen Volker
    Dec 7, 2000 at 4:20 pm
    Dec 8, 2000 at 4:34 pm
  • To all observing the month of Ramadhan, A very Happy Ramadhan with all its benefits. Aleem
    Abdul AleemAbdul Aleem
    Dec 5, 2000 at 6:25 am
    Dec 6, 2000 at 3:56 am
  • I have come across a strange problem on one of my production machines and the more I think about it the more confused I'm getting (maybe the right approach is to act first, think later). The problem ...
    Henry PorasHenry Poras
    Dec 8, 2000 at 4:18 pm
    Dec 19, 2000 at 4:11 am
  • Hi folks, Does anyone know the best way to grant a user select any table of another users tables? Thanks in advance Larry
    Larry TaylorLarry Taylor
    Dec 14, 2000 at 5:41 pm
    Dec 15, 2000 at 12:28 pm
  • ALL nations are countries of immigrants. Go back far enough, and there is sure to be warfare, natural disaster, migration, expansion, etc. in every country's history. --Scott
    Scott.Shafer_at_dcpds.cpms.osd.milScott.Shafer_at_dcpds.cpms.osd.mil
    Dec 12, 2000 at 5:30 pm
    Dec 13, 2000 at 2:53 am
  • I need help with a question that is RTFM-able, but I'm swamped, so I'm throwing myself at everyone's mercy. I have a full export file from a 7.3.4 database, and I need to load it into an 8.1.5 ...
    Dennis TaylorDennis Taylor
    Dec 11, 2000 at 8:04 pm
    Dec 12, 2000 at 3:39 pm
  • save the political correctness, too much of that crap goes on already, people are entitled to their opinion whether you or anyone like it or not. This crap of "what i think is right and what you ...
    Testa, Joe STesta, Joe S
    Dec 6, 2000 at 2:09 pm
    Dec 7, 2000 at 1:42 pm
  • Yep, you can share to Unix and NT. On the NetApp filer you create volumes, then qtrees on each volume. Then, export at the qtree level, NFS for Unix and/or CIFS for NT. dgoulet_at_vicr.com wrote:
    Suzy VordosSuzy Vordos
    Dec 2, 2000 at 7:34 am
    Dec 7, 2000 at 12:14 am
  • Hi Everyone: I have Oracle 7.3.4 database on NT. I have run the DBVERIFY to check a corrupted file, and I have received the following error : DBV-0103-The specifies blocksize(2048) is differ from the ...
    Majid KazemiMajid Kazemi
    Dec 20, 2000 at 7:21 pm
    Dec 21, 2000 at 5:14 pm
  • I need to move some tables out of a tablespace into another. Is there another option other than dropping the tables and recreating them in the new tablespace? I have exported the user, but if I ...
    Achoto_at_american.eduAchoto_at_american.edu
    Dec 14, 2000 at 7:45 pm
    Dec 16, 2000 at 5:39 pm
  • Dear all, I am running Oracle 8.1.5 on Windows NT 4.0. I am getting the above error whenever I am changing any user's password or trying to drop the user when connected as sys or system user. Can ...
    RanganathK_at_lgcommerznow.comRanganathK_at_lgcommerznow.com
    Dec 7, 2000 at 7:25 am
    Dec 14, 2000 at 12:36 pm
  • Hello All I am looking for a software that will extract to a Oracle database and extract a Entity relationship diagram ! Regards -- Sajid Iqbal | Mail : sajid_at_vianetworks.co.uk Oracle Database ...
    Sajid IqbalSajid Iqbal
    Dec 11, 2000 at 12:05 pm
    Dec 11, 2000 at 7:16 pm
  • set the LD_LIBRARY_PATH to point to the java lib files /usr/java/lib(i have no reason as to why this should be done..strange..but it solved the problem ..i was having the same errors ). also check if ...
    Ravindra BasavarajaRavindra Basavaraja
    Dec 5, 2000 at 10:05 am
    Dec 11, 2000 at 1:42 am
  • Hi List, The following query gives out results after allmost 5 minutes : select a.table_name,a.index_name,b.bytes from dba_indexes a, dba_segments b where a.table_name=b.segment_name and ...
    Sukumar KurupSukumar Kurup
    Dec 7, 2000 at 11:00 pm
    Dec 8, 2000 at 11:18 pm
  • hello all...I've been asked about an issue with a database not shutting down after executing shutdown immediate. over 6 hours later the database is still not down...what should I look at? running ...
    Roy FergusonRoy Ferguson
    Dec 6, 2000 at 12:35 am
    Dec 7, 2000 at 8:43 am
  • Hi listers, I've been off the list for some time, but I'm back with a nice problem! Hope to resume helping you with your's too. I have a database with tables of 10Gb. Creating the export-file fails, ...
    Eric.lansu_at_dutchtone.nlEric.lansu_at_dutchtone.nl
    Dec 22, 2000 at 11:29 am
    Dec 28, 2000 at 4:27 pm
  • Hi DBAs I am facing following problem at time of installation of oracle8.1.6 on sun solaris 2.6. The following are the error messgae.If any one faced such kind of problem earlier please suggest ...
    Mala singhMala singh
    Dec 16, 2000 at 7:12 pm
    Dec 20, 2000 at 9:32 pm
  • Hi List, I want to konw when I need to re-create my control files. If I add a tablespace to my database or add a datafile to one of my existing tablespaces do I need to re-create my controlfiles .. ...
    Fred SmithFred Smith
    Dec 8, 2000 at 3:40 pm
    Dec 16, 2000 at 6:40 am
  • Hi all, Since the sys admin is available 15min per week, I've started to play with truss to make sure asynch IO was done. This is on Solaris 2.7, Oracle 8.1.6 and Veritas Quick IO. I've done truss ...
    Paquette stephanePaquette stephane
    Dec 7, 2000 at 4:20 pm
    Dec 15, 2000 at 2:26 pm
  • Hi, Is it possible to send email in PL/SQL ? Is there any Oracle function that send email in PL/SQL ? If not, I guess I've to write the email information into a table, use a C-program to extract the ...
    CHAN Chor Ling Catherine (CSC)CHAN Chor Ling Catherine (CSC)
    Dec 14, 2000 at 7:26 am
    Dec 15, 2000 at 9:50 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_01C06489.0E681EF0 Content-Type ...
    Satar NaghshinehSatar Naghshineh
    Dec 12, 2000 at 10:15 pm
    Dec 14, 2000 at 3:49 pm
  • Gurus Can anybody please tell, from where I can get the X$tables information (not the DDL) like what is the purpose of the table and description of columns and when/how they get updated ? Thanks & ...
    Sood, KamalSood, Kamal
    Dec 11, 2000 at 4:27 pm
    Dec 12, 2000 at 3:24 am
  • Hi Gurus As per my understanding, when Oracle needs to copy the changes to the redo log buffer it needs to acquire the latch and there are two types of latches 'redo allocation' and 'redo copy'. And ...
    Sood, KamalSood, Kamal
    Dec 5, 2000 at 10:08 am
    Dec 12, 2000 at 2:21 am
  • Hi DBAs, I think having a 'functional Oracle DBA lab' at home is useful thing. Previously I got some 'Trial Pack' CDs or Oracle 7.x which I used to use for 90 days or so. I donot see those packs ...
    Rahul DandekarRahul Dandekar
    Dec 1, 2000 at 1:16 pm
    Dec 5, 2000 at 3:08 pm
  • hi all, We have a production db. (oracle 7.2 on unix) - Source. We r planning to have a seperate db. for another application - Destination(oracle 8 on NT). Source & Destination r in two different ...
    Arul kumarArul kumar
    Dec 18, 2000 at 11:16 am
    Dec 29, 2000 at 7:25 pm
  • --0-304089172-977419118=:18392 Content-Type: text/plain; charset=us-ascii It's always been my understanding that when a tablesapce has multiple datafiles, extents are allocated in 1 datafile at a ...
    Chuck HamiltonChuck Hamilton
    Dec 21, 2000 at 5:18 pm
    Dec 27, 2000 at 4:30 pm
  • hi all, whenever executing this statement as below mentioned .. iam getting this type of error. create table siva as select * from shipref * ERROR at line 1: ORA-01552: cannot use system rollback ...
    Sivakumar kalyanasundaramSivakumar kalyanasundaram
    Dec 20, 2000 at 5:12 am
    Dec 21, 2000 at 10:18 am
  • Hie list, I use export for my back ups. I want to prevent users from connecting to Oracle while backup is proceeding. I have in mind "stopping Oracle listener" before backup and "starting it" ...
    Zhou, TapiwanasheZhou, Tapiwanashe
    Dec 18, 2000 at 2:25 pm
    Dec 19, 2000 at 6:43 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C0668D.CB51C710 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I issed the ...
    Sanjay KumarSanjay Kumar
    Dec 15, 2000 at 7:54 pm
    Dec 18, 2000 at 5:24 pm
Group Navigation
period‹ prev | Dec 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions664
posts2,091
users405
websiteoracle.com

405 users for December 2000

Eric D. Pierce: 79 posts Rachel Carmichael: 48 posts Hannah.M.Doran_at_sb.com: 38 posts Jared still: 37 posts Ron Rogers: 37 posts Kevin Kostyszyn: 36 posts Mohan, Ross: 35 posts Dgoulet_at_vicr.com: 34 posts Joseph S. Testa: 27 posts Paquette stephane: 27 posts Koivu, Lisa: 25 posts Satar Naghshineh: 24 posts Alex Hillman: 23 posts Scott.Shafer_at_dcpds.cpms.osd.mil: 23 posts Dash, Saroj (CAP,CEF): 22 posts Cyril Thankappan: 21 posts Gogala, Mladen: 21 posts Gregory Conron: 21 posts Ramamohan B N: 21 posts Shevtsov, Eduard: 19 posts
show more
Archives