FAQ

Search Discussions

489 discussions - 1,975 posts

  • Hi listers, I was wondering how do you decide your backup strategy..... I do daily full exports and weekly full backups with database in archivelog mode. Plus weekly Operating System Backup. Is this ...
    Veronica LevinVeronica Levin
    Oct 3, 2001 at 4:44 pm
    Oct 22, 2001 at 6:31 pm
  • Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you ...
    Thanh-truc NguyenThanh-truc Nguyen
    Oct 1, 2001 at 9:15 pm
    Oct 3, 2001 at 9:40 pm
  • I am working on oracle as a developer and have done some primary level DBA activities and want to go for Oracle DBA certification .Can anyone please suggest som ways how to go about. Thakyou Bye
    AshishK_at_silverline.comAshishK_at_silverline.com
    Oct 1, 2001 at 2:24 pm
    Oct 30, 2001 at 6:25 am
  • Out of curiosity, is anyone using the java engine for procedural code, or are most people still using PL/SQL? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations ...
    Boivin, Patrice JBoivin, Patrice J
    Oct 25, 2001 at 4:20 pm
    Oct 31, 2001 at 9:36 pm
  • Hi list, Sorry for posting this strange question, but I am hopeful that I will get some explanation ... Question : Can we drop user SYSTEM ? How we will recover that ?( I know that nobody should do ...
    Ahmed Gholam HussainAhmed Gholam Hussain
    Oct 4, 2001 at 8:55 am
    Oct 22, 2001 at 5:45 pm
  • Hi! Has anyone tried installing v8.1.7 or v9i on Windows XP??? Cheers, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET ...
    Sujatha MadanSujatha Madan
    Oct 29, 2001 at 4:51 am
    Oct 29, 2001 at 8:35 pm
  • I know there is a way in SQL server to query oracle tables, is there a way to do the reverse? I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL ...
    Christopher SpenceChristopher Spence
    Oct 2, 2001 at 6:21 pm
    Oct 3, 2001 at 3:08 pm
  • Post justification... :-) This is ON topic (sorta) 'cause it's related to password security and the validity of a "fuzzy match." First of all, when applying for an ID card the prospective holder of ...
    Orr, SteveOrr, Steve
    Oct 18, 2001 at 2:53 pm
    Oct 19, 2001 at 6:45 pm
  • Hello ! I need to know what is the meaning of the "save undo block" and "save undo header" statistics in the V$WAITSTAT view. TIA. Alejandra. Descargue GRATUITAMENTE MSN Explorer en ...
    Alejandra Pazos FreireAlejandra Pazos Freire
    Oct 1, 2001 at 7:18 pm
    Oct 3, 2001 at 3:53 pm
  • Hi, According to the Veritas manual, they claim that a db_block_size of 2K when using the quick-io files and an oltp system has the most performance according to benchmarks. I know full well that ...
    Brian HaasBrian Haas
    Oct 2, 2001 at 7:12 pm
    Oct 5, 2001 at 2:20 am
  • Hi Friends, Excuse me for this dumb question, how do I display the instance name in the sql prompt. Have 3 DB and would like to know to which one I am connected. I mean something like that. DBA1 DBA2 ...
    Ramon EstevezRamon Estevez
    Oct 25, 2001 at 1:34 pm
    Oct 29, 2001 at 4:45 am
  • We are trying to recover a database to another server. The backup was a hot backup. The files are all copied to the new server, along with the archive log that was created a few seconds after the hot ...
    Smith, Ron L.Smith, Ron L.
    Oct 24, 2001 at 3:32 pm
    Oct 25, 2001 at 12:50 pm
  • if they aren't I still have a few 7.3.4 doc CDs around, if you can't get them any other way Scott Shafer wrote:
    Rachel CarmichaelRachel Carmichael
    Oct 18, 2001 at 4:03 am
    Oct 18, 2001 at 8:44 pm
  • Hi, How can I allow root to connect to the database as system. At the moment when I try this, I keep getting a ORA-01034: Oracle not available error, even though the database is up and running fine ...
    Sujatha MadanSujatha Madan
    Oct 30, 2001 at 12:39 am
    Oct 30, 2001 at 10:55 pm
  • hi gurus, Our shop ( GIS oracle spatials ) attempting to provide a production database (7x 24 hours), currently we have to offline database for users while loading of data. we donot what users to ...
    Narender AkulaNarender Akula
    Oct 18, 2001 at 9:05 pm
    Oct 24, 2001 at 5:40 pm
  • Hi Lists, Shall I close the unix session after submitting my job (compressing the dmp file after importing) in the background on solaris. $ compress /u01/dmps/zvr_dd.dmp & is this harmful ? (like ...
    Tatireddy, Shrinivas (MED, Keane)Tatireddy, Shrinivas (MED, Keane)
    Oct 2, 2001 at 4:36 am
    Oct 3, 2001 at 9:36 pm
  • Hi All, I am trying for hot backup restore/recovery. Oracle 8.1.7.0.0 on WIN 2K Server. I am performing the operations in following order: Put all the tablespaces in backup mode. Copy all the ...
    Rajesh DayalRajesh Dayal
    Oct 1, 2001 at 11:06 am
    Oct 3, 2001 at 5:20 am
  • Just thought I would ask. How does everyone feel about Oracle Open World this year. Will attendance be down? Ron Smith Database Administrator rlsmith_at_kmg.com -- Please see the official ORACLE-L ...
    Smith, Ron L.Smith, Ron L.
    Oct 1, 2001 at 6:00 pm
    Oct 2, 2001 at 3:26 pm
  • Dear All, I hit upon this site. I thought its worth sharing http://docs.oracle.com/ Venkat -- On Fri, 19 Oct 2001 06:25:21 Deshpande, Kirti wrote: Make a difference, help support the relief efforts ...
    C.S.Venkata SubramanianC.S.Venkata Subramanian
    Oct 30, 2001 at 10:39 am
    Oct 31, 2001 at 9:26 pm
  • Anyone else get this spam? -----Original Message----- From: Cindy Connors [SMTP:cconnors_at_intertrain.net] Sent: Friday, October 26, 2001 6:47 PM To: Bambi Bellows; Brian Norrell; Charlie Mengler ...
    Koivu, LisaKoivu, Lisa
    Oct 26, 2001 at 7:44 pm
    Oct 29, 2001 at 3:13 pm
  • Okay, this is weird. I'm trying to rebuilding my QC database from a hot backup. As always, I copied all the hot backup files, all the archive logs from the period of the hot backup and the control ...
    Miller, JayMiller, Jay
    Oct 25, 2001 at 10:06 pm
    Oct 26, 2001 at 4:14 pm
  • How can I tell if a stored procedure or package is in the middle of execution? (for lack of doing what it does).. I've heard of parse locks, is that a way? Thanks, D -- Please see the official ...
    Doug CDoug C
    Oct 25, 2001 at 3:03 am
    Oct 30, 2001 at 12:18 pm
  • Hi all, Sorry about the non-DBA related post...but I reckon you guys will be able to point me in the right direction! Our client is running some Oracle Reports (v2.5) that are killing our database, ...
    Thomas, KevinThomas, Kevin
    Oct 25, 2001 at 10:13 am
    Oct 26, 2001 at 11:16 am
  • Hallo, Can you please tell how to move one table from one tablespace to another? I have data inthistable. Thanks in advance Roland Sköldblom -- Please see the official ORACLE-L FAQ ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Oct 25, 2001 at 9:45 am
    Oct 25, 2001 at 1:53 pm
  • --____CIVUFTDKZVQDOGJWYCGU____ Content-Type: multipart/alternative; boundary="____HALPYZPZYFFYCGAKLKOY____" --____HALPYZPZYFFYCGAKLKOY____ Content-Type: text/plain; charset=iso-8859-1 ...
    Danny Hughes<dhughes_at_knobias.com>Danny Hughes<dhughes_at_knobias.com>
    Oct 19, 2001 at 5:28 pm
    Oct 22, 2001 at 3:24 pm
  • Hi Bing, I meant the case when the load (number of requests) is much higher on a particular latch comparing to over latches Regards, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com ...
    Edward ShevtsovEdward Shevtsov
    Oct 18, 2001 at 4:55 am
    Oct 19, 2001 at 8:10 pm
  • Hi All, I am trying to drop a table. It is not locked and has very few records in it. I am trying to drop it but it will not. What can I check to find out why it will not drop? Thanks Rick -- Please ...
    Cale, Rick T (Richard)Cale, Rick T (Richard)
    Oct 4, 2001 at 4:40 pm
    Oct 4, 2001 at 8:13 pm
  • Okay People, I am not the DBA and don't have all the details but this is our situation the way it was explained to me: We had a server crash to the point where Unix and Oracle had to be reinstalled, ...
    Regina HarterRegina Harter
    Oct 26, 2001 at 10:33 pm
    Oct 30, 2001 at 2:58 am
  • Hi, Is there any function that can display out "last day of the month" for example lastday(Oct,2001) return me 31 Or a variable that store this value. Is Date an object in unix ? Sinardy -- Please ...
    Sinard XingSinard Xing
    Oct 29, 2001 at 8:06 am
    Oct 29, 2001 at 9:47 pm
  • Can I move a tablespace and all it's associated datafiles to a new disk device with no downtime? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET ...
    Greg MooreGreg Moore
    Oct 25, 2001 at 2:53 am
    Oct 26, 2001 at 5:11 am
  • I've got 885 triggers with hard-coded fully qualified table names in DBA_TRIGGERS. Problem is, the vendor changed the ownership on these tables, and now I've got 885 invalid triggers. I'd just like ...
    DBarbour_at_austin.isd.tenet.eduDBarbour_at_austin.isd.tenet.edu
    Oct 25, 2001 at 5:55 pm
    Oct 25, 2001 at 8:28 pm
  • Hallo, what does this errormessage mean. I get it when i try to do this select statement. If I dont include the last two lines in the statement it works fine. What does this depend on? and which ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Oct 19, 2001 at 3:02 pm
    Oct 23, 2001 at 8:55 am
  • hello! our developers here are requesting that I put defaults (' ' for chars/varchars, 0 for numbers, etc) in place instead of nulls in all columns that would supposedly allow null values... they are ...
    Maria Aurora VT de la VegaMaria Aurora VT de la Vega
    Oct 19, 2001 at 12:07 pm
    Oct 19, 2001 at 3:24 pm
  • Lee, Did you come up with a workable solution for this? Preliminary testing of the v$session_longops view gave me some weird data returned in the in the start_time column: SQL edit Wrote file ...
    Mark LeithMark Leith
    Oct 18, 2001 at 1:53 pm
    Oct 19, 2001 at 8:43 am
  • Hi Jared, Excuse me for contact you directly not throug the list. The past week you post an answer to someone trying to write to excel, I took the example to generate a file comma separated, but ...
    Ramon EstevezRamon Estevez
    Oct 4, 2001 at 9:09 pm
    Oct 5, 2001 at 9:50 pm
  • I'm a little perplexed by this query and it's associated plan. It's also a big performance problem. The problem is the 35 million row table clearly. But looking at the plan at the bottom, I'm not ...
    Doug CDoug C
    Oct 5, 2001 at 2:27 pm
    Oct 5, 2001 at 9:45 pm
  • Hi, I've read in Tom Kyte's book the following technique: For i in (Select statement ) Loop Process records here End Loop; I have tried it and it works great. The question is that what is the ...
    Csillag ZsoltCsillag Zsolt
    Oct 1, 2001 at 8:21 pm
    Oct 2, 2001 at 5:38 pm
  • Yesterday I was at my local OfficeMax where I found a copy of XP Home edition for $467.00US and Professional for $867.00US. I had a good laugh on my way out too!! Dick Goulet ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 29, 2001 at 5:07 pm
    Oct 29, 2001 at 9:44 pm
  • What are the advantages/disadvantages to doing a alter index rebuild (Oracle 8.0.X) versus dropping and recreating the index. Thanks, Casey -- Please see the official ORACLE-L FAQ ...
    Cjordan_at_smcwv.comCjordan_at_smcwv.com
    Oct 22, 2001 at 5:38 pm
    Oct 28, 2001 at 5:20 am
  • I've taken all the standard Oracle database administration classes such as perf tuning, backup and recovery, replication, etc. What I am looking for is a really good class that's more advanced. Does ...
    David TurnerDavid Turner
    Oct 25, 2001 at 6:08 pm
    Oct 25, 2001 at 11:24 pm
  • Hallo you DBA' Can anyone give me a good example on a sql select statement checking which ids exists in table one but not in table two? Table two also contains the corresponding id field but with ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Oct 25, 2001 at 7:19 am
    Oct 25, 2001 at 4:18 pm
  • Hello all, Although I have installed Intermedia as part of my general DBA duties before I have not experienced any particular requirements on throughput rate or indexing. I need some information on ...
    Martin KendallMartin Kendall
    Oct 4, 2001 at 2:15 pm
    Oct 5, 2001 at 10:45 pm
  • Somebody has remapped the value that is expressed when the ' @ ' key is pressed. A session trace file, from a Secure CRT emulation, shows that a hex 0d 0a, is being expressed instead. As a result, we ...
    DonDon
    Oct 4, 2001 at 1:00 am
    Oct 4, 2001 at 1:57 pm
  • I have a question concerning the init.ora file and using the supplied package UTL_FILE.... I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, ...
    Kempf, ReedKempf, Reed
    Oct 2, 2001 at 10:59 pm
    Oct 4, 2001 at 8:10 am
  • hi, I have a requirement as per which i have to send a mail on insertion/updation of a record. How this can be done using PL/SQL (i.e. triggers). Does mail server i.e. Lotus or Exchange server ...
    SUNILSHIVAPPASUNILSHIVAPPA
    Oct 3, 2001 at 9:03 am
    Oct 4, 2001 at 5:21 am
  • Hello Can you please clarify the relation between 'save undo headers' and Billy Graham. If making a joke out of what is 'unplatable' or 'inconvenient' to believe is comforting you by all means go ...
    Cyril ThankappanCyril Thankappan
    Oct 2, 2001 at 4:29 pm
    Oct 3, 2001 at 2:57 pm
  • Dear list ! If my NT server (which runs an Oracle instance) gets rebooted accidentally, how can i bring up the Oracle services without starting up the instance ? I want to startup the instance with a ...
    Andrey BronfinAndrey Bronfin
    Oct 31, 2001 at 9:32 am
    Oct 31, 2001 at 2:51 pm
  • List, Sorry to deviate from the topic, but I am writing a korn shell script that would exit if the date format is incorrect. I just need something to compare the date format passed in with ...
    Suhen PatherSuhen Pather
    Oct 26, 2001 at 1:57 am
    Oct 31, 2001 at 1:07 am
  • Could be worse - could be raining, Replacing those awkward characters comes down to distinguishing between them used as quotes and used to search for that character. The sql functions ASCII() and ...
    Simon.Anderson_at_scisys.co.ukSimon.Anderson_at_scisys.co.uk
    Oct 22, 2001 at 3:58 pm
    Oct 23, 2001 at 6:25 am
  • Greetings All; I am confused and hope someone can straighten me out. My confusion surrounds temporary segments and where they are created. I had assumed that temporary segments were created in a ...
    Petrus, Mike (CAP, GEFA)Petrus, Mike (CAP, GEFA)
    Oct 18, 2001 at 7:52 pm
    Oct 19, 2001 at 3:36 pm
Group Navigation
period‹ prev | Oct 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions489
posts1,975
users368
websiteoracle.com

368 users for October 2001

Christopher Spence: 82 posts Rachel Carmichael: 60 posts Kimberly Smith: 44 posts Jared.Still_at_radisys.com: 36 posts Dgoulet_at_vicr.com: 34 posts Mercadante, Thomas F: 34 posts Deepak Thapliyal: 32 posts Jacques Kilchoer: 32 posts Koivu, Lisa: 30 posts Mohan, Ross: 29 posts Connor McDonald: 28 posts DENNIS WILLIAMS: 25 posts Steve Adams: 24 posts Thomas, Kevin: 23 posts Mark Leith: 22 posts Tday6_at_csc.com: 22 posts Amar Kumar Padhi: 21 posts Tatireddy, Shrinivas (MED, Keane): 21 posts Gogala, Mladen: 20 posts Guy Hammond: 20 posts
show more
Archives