FAQ

Search Discussions

579 discussions - 2,131 posts

  • Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so ...
    Regina HarterRegina Harter
    Nov 14, 2001 at 6:06 pm
    Nov 25, 2001 at 10:18 pm
  • hai list, my system (compaq deskpro under os- windows nt)is connected to a printer -HP deeskjet 870cxi professional series.. i want to print one file through the text_io utility of D2k . .i called ...
    linsonpaul/VGIL_at_vguard.satyam.net.inlinsonpaul/VGIL_at_vguard.satyam.net.in
    Nov 1, 2001 at 9:33 am
    Nov 30, 2001 at 11:15 am
  • Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these ...
    Jeffery StevensonJeffery Stevenson
    Nov 13, 2001 at 1:57 pm
    Nov 16, 2001 at 5:59 am
  • A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 by using export/import. This will probably work, but wouldn't it be easier to just do a cold backup and open them using the COMPATIBLE ...
    EdEd
    Nov 20, 2001 at 11:29 pm
    Nov 23, 2001 at 3:23 am
  • Can't log in to Metalink today either.......am getting the opening page but gives the 'Page temporarily unavailable' after that......anybody else sharing the same problem ???? Samir Sarkar Oracle DBA ...
    SARKAR, SamirSARKAR, Samir
    Nov 20, 2001 at 3:13 pm
    Nov 21, 2001 at 3:29 pm
  • I'm looking for comments on disk to disk backups and their compatibility with backup cataloging software such as RMAN. The problem that I see with disk to disk is that although recovering from the ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Nov 15, 2001 at 8:57 pm
    Nov 19, 2001 at 2:47 pm
  • I am creating a database from a DDL SQL script. I have created the primary and temp tablespaces because their names were referenced in the code. However, there is no name reference anywhere that I ...
    Ken JanuszKen Janusz
    Nov 20, 2001 at 7:42 pm
    Nov 21, 2001 at 5:30 pm
  • Hi i'd like to know what average salarys are in european countries for a medium skilled DBA. my first contribution is 40 USD vr. gr. g.g. kor rdw ict the netherlands -- Please see the official ...
    GKor_at_rdw.nlGKor_at_rdw.nl
    Nov 12, 2001 at 10:21 am
    Nov 15, 2001 at 12:16 pm
  • Hi ladies & gents, I think I am having a blonde Monday (no I have nothing against blondes, or Mondays for the matter.. but anyway :) ). I've got essentially a new PC (new HD), that I would *like* to ...
    Mark LeithMark Leith
    Nov 12, 2001 at 2:15 pm
    Nov 13, 2001 at 6:22 pm
  • Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this ...
    Thomas, KevinThomas, Kevin
    Nov 28, 2001 at 11:30 am
    Nov 30, 2001 at 8:14 pm
  • I have this large DB (approx. 250 tables) that has the tables and indexes in the same tablespace (not my design). Is there a way I can move all of the indexes to a separate tablespace en-mass? I know ...
    Ken JanuszKen Janusz
    Nov 27, 2001 at 2:56 pm
    Nov 27, 2001 at 9:53 pm
  • Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut
    Daiminger, HelmutDaiminger, Helmut
    Nov 26, 2001 at 1:28 pm
    Nov 26, 2001 at 5:08 pm
  • Hi list people :) We have a customer who has been running a particular delete statement against a table for a while now, which usually ran within minutes. All of a sudden this table has suddenly gone ...
    Mark LeithMark Leith
    Nov 27, 2001 at 7:21 pm
    Nov 29, 2001 at 4:00 pm
  • DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the 8.1.6/7 doc sets. The package (and the procedure) exists, though even the package spec source code is wrapped. What gives? Is this package ...
    Paul BaumgartelPaul Baumgartel
    Nov 19, 2001 at 3:26 pm
    Nov 20, 2001 at 6:43 pm
  • Hi lists, We can see users password using ps -ef |grep sqlplus (if we run a job using sqlplus scott/tiger @${runfile} ). To prevent this we can run our code sqlplus -s < -- Please see the official ...
    Tatireddy, Shrinivas (MED, Keane)Tatireddy, Shrinivas (MED, Keane)
    Nov 15, 2001 at 1:29 pm
    Nov 16, 2001 at 8:35 am
  • FYI, I just submitted feedback to Oracle re. their OEM 2.2. product. So far I have had to rebuild the repository three times. With fifteen servers, this is a major hassle. We have Oracle on NT, on ...
    Boivin, Patrice JBoivin, Patrice J
    Nov 9, 2001 at 3:36 pm
    Nov 9, 2001 at 11:35 pm
  • Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a ...
    EdEd
    Nov 29, 2001 at 12:11 am
    Nov 30, 2001 at 3:05 pm
  • Hello everyone, I'm certain that this is a FAQ, but I thought I would make a request here. I have a client whose management is requesting us to make a business case for keeping our Oracle on UNIX ...
    Paul ValleePaul Vallee
    Nov 27, 2001 at 6:07 pm
    Nov 29, 2001 at 10:32 pm
  • Compressed indexes: The docs don't say that compressed indexes cannot be rebuilt online but it doesn't work for me. I can rebuild normal indexes online, I can rebuild an index and compress it but I ...
    Orr, SteveOrr, Steve
    Nov 14, 2001 at 7:47 pm
    Nov 16, 2001 at 8:50 am
  • To continue the discussion on getting together at Openworld: How about Tuesday evening, around 7:00? Someone who knows downtown SF want to suggest a place? My preference is not too loud or too ...
    Jeremiah WiltonJeremiah Wilton
    Nov 27, 2001 at 8:25 pm
    Nov 29, 2001 at 6:59 pm
  • Briefly, our current setup includes Web enabled forms (PL/SQL Cartridges) accessing an 8i database via 9ias (currently OAS 4.2 but will be moving to 9ias in a month). Btw, we also use ORACLE APPS ...
    Sunny VergheseSunny Verghese
    Nov 28, 2001 at 8:25 pm
    Nov 29, 2001 at 7:00 pm
  • Hi WHen I execute ps -ef |grep LOCAL on Solaris server the following output i see in 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) What is the ...
    Seema SinghSeema Singh
    Nov 27, 2001 at 6:15 pm
    Nov 29, 2001 at 9:39 am
  • A user has asked me about identifying most recently created trace files on a VMS system. I have shown him where they are and how to do a DIR/SIN=TODAY command to get todays files. However he was ...
    Hallas JohnHallas John
    Nov 16, 2001 at 11:02 am
    Nov 22, 2001 at 6:37 am
  • Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Nov 13, 2001 at 4:29 pm
    Nov 13, 2001 at 11:38 pm
  • Given a business rule that says a combination of three columns must be unique if and only if a fourth column equals a certain value, and if the table in question contains rows that violate this ...
    Paul BaumgartelPaul Baumgartel
    Nov 1, 2001 at 8:38 pm
    Nov 2, 2001 at 6:34 pm
  • My CIO woes continue. My manager has been told by the CIO that Oracle has a product called "mirror accessible" which allows the database to be mirrored for reporting purposes. He wants us to use this ...
    Miller, JayMiller, Jay
    Nov 30, 2001 at 5:54 pm
    Nov 30, 2001 at 11:36 pm
  • Hi Guys, I am newbie oracle DBA and want to duplicate my development database to Test database and want to change ORACLE_SID, Could anyone tell exact steps that I have to follow. My database is on ...
    MRavalMRaval
    Nov 28, 2001 at 7:16 pm
    Nov 30, 2001 at 6:12 pm
  • Henry, I am sorry to have to admit it, but my experience with third party software is that all of them don't want to imbed their referential integrity into the database. I like you also believe it is ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Nov 29, 2001 at 3:33 pm
    Nov 30, 2001 at 1:37 pm
  • What is the general consensus from the list on using RMAN? Pros? Cons? Any previous experience with problems as a result of using RMAN versus cold and hot backups. I would appreciate your inputs ...
    Btaylor3_at_gmu.eduBtaylor3_at_gmu.edu
    Nov 29, 2001 at 12:49 pm
    Nov 29, 2001 at 6:15 pm
  • Yeah I had a problem recently were I was exporting a 45Gigg database, the export will continue until at a end it will come up with a warning that export was completed successfully with warnings ...
    Jackson DumasJackson Dumas
    Nov 16, 2001 at 2:52 pm
    Nov 19, 2001 at 7:50 pm
  • Listers, Okay, I've been googling for about an hour now and can't find it. It seems like I remember seeing a white paper, note, or some sort of reference detailing "preferred" file layouts based on ...
    Larry ElkinsLarry Elkins
    Nov 14, 2001 at 9:23 pm
    Nov 16, 2001 at 5:15 pm
  • Been here 18 hours. No database. Looks grim. Hardware blew chunks. Major ugly. Plan is to reconstruct entire system on new hardware. If I get my dbf files from last night's cold backup (as well as ...
    Baker, BarbaraBaker, Barbara
    Nov 1, 2001 at 6:56 am
    Nov 1, 2001 at 4:54 pm
  • This is a cross post folks... so...unfortunately, Susan McClain will not be able to attend OOW, and it now seems I AM presenting (where the heck did I put that skirt?)... I will be giving her ...
    Rachel CarmichaelRachel Carmichael
    Nov 27, 2001 at 4:10 pm
    Nov 29, 2001 at 10:26 pm
  • hI GURUS' How can i enable the partitioning option in database?. Any idea? SYSTEM_at_ORANS.QTEL.COM.QA SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETER VALUE Partitioning FALSE ...
    Nirmal Kumar Muthu KumaranNirmal Kumar Muthu Kumaran
    Nov 28, 2001 at 2:30 pm
    Nov 29, 2001 at 7:04 pm
  • Well said Mark. David, you could also re-able the constraint 'novalidate' if you wanted to ignore the validity of any new input. If that was the case then why have an integrity constraint in the ...
    Hallas JohnHallas John
    Nov 28, 2001 at 11:36 am
    Nov 29, 2001 at 12:35 am
  • Hi when writing a program PROC .NEXTVAL points to the next value of a sequence, is there anything like .SOMETHING that returns current value of sequence. Thanks E.
    Ehsan sinavaldaEhsan sinavalda
    Nov 26, 2001 at 1:20 pm
    Nov 26, 2001 at 4:18 pm
  • OK, I think I figured it out - had to clear the Internet Cache for IE. After I did that, I could access MetaLink. Don't know why though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) ...
    Boivin, Patrice JBoivin, Patrice J
    Nov 21, 2001 at 1:20 pm
    Nov 21, 2001 at 5:02 pm
  • Write out of good old relational theory.. So is it (too pul). or (tuh pall).. Thanks, D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: dcowles_at_i84.net Fat ...
    Doug CDoug C
    Nov 14, 2001 at 5:44 am
    Nov 14, 2001 at 10:38 pm
  • Guys, I'd appreciate any help that I could get. I was trying to import to another tablespace, same user. I hadn't had a need to do this in a while but thought this shouldn't be too difficult. So I ...
    George HofilenaGeorge Hofilena
    Nov 27, 2001 at 8:15 pm
    Nov 28, 2001 at 1:13 am
  • Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ ...
    Ball, TerryBall, Terry
    Nov 21, 2001 at 9:53 pm
    Nov 23, 2001 at 5:42 am
  • Anyone seen this fecality in their listener.ora? It's a new one on me, but then again, what with all the "newfangled" features in this here product, I am probably just losing track...... (DESCRIPTION ...
    Mohan, RossMohan, Ross
    Nov 21, 2001 at 3:51 pm
    Nov 22, 2001 at 12:53 pm
  • comes up fine for me. -- -- Bill "Shrek" Thater ORACLE DBA Telergy,Inc. thaterw_at_telergy.net ------------------------------------------------------------------------ You gotta program like you ...
    Thater, WilliamThater, William
    Nov 15, 2001 at 6:53 pm
    Nov 16, 2001 at 11:46 am
  • hi, is there a dba checklist to know a dba does? Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET ...
    GraceGrace
    Nov 15, 2001 at 4:53 am
    Nov 15, 2001 at 6:21 pm
  • Hi All, We are looking at purchasing TOAD or SQL Navigator from Quest. I think they have purchase EZSQL also which I liked(good and cheap). I guess there goal is to eliminate the competition. I have ...
    Cale, Rick T (Richard)Cale, Rick T (Richard)
    Nov 1, 2001 at 3:39 pm
    Nov 2, 2001 at 1:06 pm
  • This info isn't forthcoming on metalink or in the doco as far as I can tell. Can anyone tell me how to change the directory associated with the rman command 'allocate channel disk'? Or at least ...
    Koivu, LisaKoivu, Lisa
    Nov 29, 2001 at 10:09 pm
    Nov 30, 2001 at 3:47 pm
  • Hi Gang, Does anybody use Siebel - I believe it's a CRM package? I'm trying to find out of the Siebel application enforces RI within the database or the application? Anybody know? Cheers Mark Mark ...
    Mark LeithMark Leith
    Nov 28, 2001 at 5:05 pm
    Nov 29, 2001 at 12:43 am
  • List hi! Oracle 8.1.7 on WinNT. Our Windows guys want to rename disc drives for some administration reasons. I'm really in UNIX so I'm wondering could you give me some advices on this matter. As far ...
    Sonja �ehovi�Sonja �ehovi�
    Nov 28, 2001 at 10:43 am
    Nov 28, 2001 at 5:16 pm
  • sqlldr is not a sqlplus command - it needs to be called from the OS command line. Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Tuesday, November 27, 2001 5:00 PM -- Please ...
    Joe RaubeJoe Raube
    Nov 27, 2001 at 10:32 pm
    Nov 28, 2001 at 1:56 pm
  • Hi Listers, How can we revoke 'delete privilege' from the schema owner of the table and also from DBA ? If it is not possible, can we set through trigger ? Thanks. Aldi Get your FREE download of MSN ...
    Aldi BarcoAldi Barco
    Nov 27, 2001 at 9:39 pm
    Nov 28, 2001 at 6:24 am
  • Well, I'm way behind on my reading so I am just finishing a quick (?) skim of the May proceedings of the 2001 ACM SIGMOD Conference on Management of Data. There is some interesting stuff in there so ...
    Henry PorasHenry Poras
    Nov 26, 2001 at 10:48 pm
    Nov 27, 2001 at 9:08 pm
Group Navigation
period‹ prev | Nov 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions579
posts2,131
users376
websiteoracle.com

376 users for November 2001

Mark Leith: 64 posts Deepak Thapliyal: 51 posts Mohan, Ross: 50 posts Rachel Carmichael: 50 posts Connor McDonald: 36 posts Boivin, Patrice J: 34 posts Ken Janusz: 33 posts DENNIS WILLIAMS: 31 posts Jared.Still_at_radisys.com: 31 posts Robertson Lee - lerobe: 30 posts Kimberly Smith: 27 posts Mercadante, Thomas F: 26 posts Dgoulet_at_vicr.com: 25 posts Jamadagni, Rajendra: 25 posts Scott Shafer: 25 posts Hallas John: 23 posts Koivu, Lisa: 23 posts SARKAR, Samir: 23 posts Tatireddy, Shrinivas (MED, Keane): 23 posts Jared Still: 22 posts
show more
Archives