Search Discussions

147 discussions - 684 posts

  • Compiling a list of major blunders to avoid: Don't use the number 8 for scripting or ORACLE_SID due to the wild card character * above it. Don't use rm *.* .... Anyone else have some to contribute? ...
    April SimsApril Sims
    Oct 7, 2009 at 3:41 pm
    Oct 17, 2009 at 7:11 am
  • Hi all, Env: Oracle EE RH 4.6 I'm doing exports to a filesystem with limited space so want to compress the export on the fly, e.g. . . cd $BACKUP_DIR if [ ! -p $PIPE ]; then mkfifo $PIPE fi ...
    Tony AdolphTony Adolph
    Oct 6, 2009 at 12:53 am
    Oct 12, 2009 at 7:50 pm
  • Is it feasible to patCh 10.2.01. directly to 10.2.04. Anyone done this? -- http://www.freelists.org/webpage/oracle-l
    John DunnJohn Dunn
    Oct 21, 2009 at 2:48 pm
    Oct 22, 2009 at 3:19 pm
  • My manager is asking about positive and negative feedback on 11g now that R2 has been announced. I have not heard anything specific outside of a few patch issues. Anyone have feedback for me on 11g? ...
    Kellyn PedersenKellyn Pedersen
    Oct 21, 2009 at 10:42 pm
    Apr 22, 2010 at 4:16 am
  • Hi Is it correct to say that I can have Datagaurd where Primary is AIX and Dataguard (Logical) is Linux. Is this Correct to say that Physical Standby is not possible but Logical Standby is possible ...
    Sanjay MishraSanjay Mishra
    Oct 20, 2009 at 4:35 pm
    Oct 23, 2009 at 8:43 pm
  • Am I the only one who gets very worried when developers complain about making a table join? I would use the lookup table just so I could have a single place to update a description if it ever changes ...
    Christopher BoyleChristopher Boyle
    Oct 16, 2009 at 5:11 pm
    Oct 19, 2009 at 6:38 pm
  • I have not monitored this list much lately. I saw a post from last week about issues with flash. Anyone else find that it takes 2-5 minutes for your SRs to come up? I do a search by my name. This is ...
    Dba DBADba DBA
    Oct 20, 2009 at 2:15 pm
    Oct 26, 2009 at 3:48 pm
  • I'm trying to decide whether to use bigfiles for some of our datawarehouse tablespaces. What are the advantages/disadvantages of using bigfiles instead of several, say 2GB datafiles? Thank you Ana ...
    Ana ChotoAna Choto
    Oct 26, 2009 at 3:31 pm
    Oct 26, 2009 at 5:10 pm
  • I am having an issue with my support, after doing a search the documents list comes up and when I click on the document, I just get a blank screen, if I print the screen I can see the data. Has ...
    Kenneth NaimKenneth Naim
    Oct 12, 2009 at 6:56 pm
    Oct 14, 2009 at 3:37 pm
  • Hi Gurus, This request is intended to Mark Bobak or anyone using/familiar with tnsManager. I came across the recommendation of using tnsManager in place of OID for the use of names resolution in ...
    Sundar mahadevanSundar mahadevan
    Oct 23, 2009 at 3:21 pm
    Oct 26, 2009 at 8:07 pm
  • The reference manual has the answer (database limits -- logical limits) Users and Roles Maximum 2,147,483,638 Cheers Stefan Stefan P Knecht CEO & Founder s_at_10046.ch 10046 Consulting GmbH ...
    Stefan KnechtStefan Knecht
    Oct 12, 2009 at 7:12 pm
    Oct 20, 2009 at 3:59 pm
  • Hello all, if memory serves me right then the use of OID was free if it's used for name resolution (i.e. as replacement for tnsnames.ora), amongst other things. I am wondering if anyone uses OID for ...
    Martin BachMartin Bach
    Oct 22, 2009 at 3:50 pm
    Oct 22, 2009 at 11:02 pm
  • I would be careful about disabling or stopping it. Not necessarily because doing so will break anything, but more for patches, upgrades, or the potential that a future release may make it mandatory ...
    Dan NorrisDan Norris
    Oct 16, 2009 at 7:09 pm
    Oct 18, 2009 at 3:13 pm
  • Hi! Can you please check that your ld_library_path is set correctly? -TL Hello list, This combination (RHEL5 x86-64 and Oracle is not oracle certified but i have to install for test ...
    Teijo LallukkaTeijo Lallukka
    Oct 21, 2009 at 8:08 pm
    Oct 28, 2009 at 7:42 am
  • Hi List, I have a shell script report the following output for my daily check routine. I found the SQL SQL SQL is very annoying, is it possible to get rid off the "lines from coonected to:" to 2 3 ...
    Joan HsiehJoan Hsieh
    Oct 6, 2009 at 3:20 pm
    Oct 6, 2009 at 6:17 pm
  • Have a simple question. When we delete a row based on rowid from an indexed table, how the index entry gets deleted? DELETE t WHERE rowid=''; Am asking this because in my case Oracle is doing a full ...
    DBA DeepakDBA Deepak
    Oct 5, 2009 at 10:34 am
    Oct 6, 2009 at 2:52 pm
  • Good Morning, I've got a requirement to move about 300GB of table and index data from the current tablespaces into new tablespaces. There is a physical standby in place. The standby is located in ...
    David BarbourDavid Barbour
    Oct 1, 2009 at 9:44 pm
    Oct 2, 2009 at 3:10 pm
  • anyone else getting these? It must be the bad economy. I got a call from someone at oracle. I asked him what ticket the call was about and he gave me a ticket that has been closed for a month. I took ...
    Dba DBADba DBA
    Oct 28, 2009 at 7:15 pm
    Oct 29, 2009 at 1:53 pm
  • Hi I need some advice/suggestion as how Oracle environment is different in OpenVMS vs Unix environment. I had never worked with OpenVMS and was checked to Tune some RAC on OpenVMS to increase the ...
    Sanjay MishraSanjay Mishra
    Oct 28, 2009 at 4:41 pm
    Oct 28, 2009 at 8:53 pm
  • Hi all, Well, I am new to Linux. Trying to upgrade our current OEL 4 to the latest release. Opened an SR with Oracle Support where I was advised to run up2date. Configured, ran it till it said that ...
    Eugene PipkoEugene Pipko
    Oct 27, 2009 at 8:56 pm
    Oct 28, 2009 at 4:16 pm
  • Hi We had an discussion about how we could solve the problem with no downtime during upgrades and I want to know if anyone of you have had an similiar problem before and if you could help me with ...
    Johan ErikssonJohan Eriksson
    Oct 27, 2009 at 1:44 pm
    Oct 27, 2009 at 7:16 pm
  • Here are some facts that may contribute to your discussion: The Oracle Database Machine databases are created and tested with 8k blocks. That goes for DW and OLTP databases. 21GB/s scan rate from ...
    Dan NorrisDan Norris
    Oct 26, 2009 at 7:02 pm
    Oct 27, 2009 at 5:48 pm
  • Thanks Tanel and I have some interesting findings when I retrieve a single row from a table with 255 columns (348 columns). For the table definition in my test case, if I fetch the 95th column or ...
    Hemant K ChitaleHemant K Chitale
    Oct 18, 2009 at 8:23 am
    Oct 26, 2009 at 3:52 pm
  • First of all I would like to say that finding detailed information about Oracle's implementation of regular expressions is next to impossible. Either that, or I am looking in all the wrong places ...
    Michael MooreMichael Moore
    Oct 23, 2009 at 6:01 pm
    Oct 25, 2009 at 7:44 pm
  • I am using the rotatelog function for my Apache logs. ErrorLog "|/u01/Apache/Apache/bin/rotatelogs /u01/app/oracle/product/sso10g/Apache/Apache/logs/error_log.%Y%m%d 86400" While this does rotate the ...
    Kathy duretKathy duret
    Oct 16, 2009 at 3:26 pm
    Oct 21, 2009 at 2:31 pm
  • Would anyone care to hazard a guess as to what happened? Purely as an academic exercise, you understand. http://www.theregister.co.uk/2009/10/19/sidekick_rac/ I am actually genuinely curious as to ...
    Johnson, GeorgeJohnson, George
    Oct 19, 2009 at 4:17 pm
    Oct 21, 2009 at 2:05 am
  • We have a requirement to disallow access to a few columns of a table. Any suggestions on how to do this? I was thinking of Virtual Private Database but that would exclude the entire row. Jeffrey ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 5, 2009 at 7:35 pm
    Oct 6, 2009 at 7:12 am
  • Hi all, We're running Oracle 8,9,10 on Windows. Third party scheduler program executes scripts against Oracle as: sqlplusw.exe user/pwd_at_db _at_c:\jobs\task1.sql What are the ways of hiding ...
    Eugene PipkoEugene Pipko
    Oct 30, 2009 at 10:22 pm
    Nov 2, 2009 at 10:28 pm
  • Hi Oracle-L, I understood from the documentation that avg_space field in dba_tables should contain "Average amount of free space, in bytes, in a data block allocated to the table". So, I figured that ...
    Chen ShapiraChen Shapira
    Oct 27, 2009 at 2:03 am
    Oct 29, 2009 at 1:38 am
  • Just happened to read about - hadoop, cloudbase etc. are these real threat to RDBMS or just passing clouds ?!! What would be nextgen database or data storage (sounds better) technology ? Thoughts ?! ...
    Oct 27, 2009 at 6:22 pm
    Oct 28, 2009 at 6:59 pm
  • Hi all, I'm trying to figure out how to implement an automated monitoring regarding the above mentioned "event". When it happens the instance hang may become a problem and *I believe* that monitoring ...
    Radoulov, DimitreRadoulov, Dimitre
    Oct 26, 2009 at 11:29 am
    Oct 27, 2009 at 5:04 pm
  • Hello list, Let's say I have select a, b, c from t1 (union/minus/intersect) select a, b, c from t2 Is there any way to avoid the sort unique step (for each table) that takes place before the ...
    Oct 22, 2009 at 8:49 pm
    Oct 23, 2009 at 11:42 am
  • I am trying to build a test lab with Oracle RAC: I have 2 servers dedicated for this purpose each with 2 gigabit interfaces. They have 1 CPU Quad core with 8GB memory, they will be running RHEL4 ...
    Upendra NUpendra N
    Oct 22, 2009 at 2:27 am
    Oct 23, 2009 at 11:17 am
  • There should be services started? For Linux, i start everything with $OMS_HOME/opmnctl startall. There's probably a service like that? I only know Linux, not Windows, sorry. HTHLyall Original Message ...
    Lyall BarbourLyall Barbour
    Oct 7, 2009 at 1:45 pm
    Oct 20, 2009 at 4:32 pm
  • All, recently we got into a database(10gR2) hang situation and we were forced to abort the instance . This database has few corrupted blocks which shows in v$database_block_corrutpion and ...
    kp Rkp R
    Oct 10, 2009 at 10:27 pm
    Oct 11, 2009 at 9:54 pm
  • We have a daily clone that we open in read-only mode. User reports the following error: select * from t_sap_cd ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for ...
    Newman, ChristopherNewman, Christopher
    Oct 7, 2009 at 3:32 pm
    Oct 9, 2009 at 5:09 pm
  • I have just started for a company that applies to the philosophy of too much of a good thing is really a good thing, so bear with me... The code has parallel hints everywhere- degrees often set to 8 ...
    Kellyn PedersenKellyn Pedersen
    Oct 1, 2009 at 4:45 pm
    Oct 5, 2009 at 7:51 pm
  • Hi, Do you know if window 2003 x64bit is certified for 11g 64 bit. I checked the platform on metalink, there is no entry for Microsoft Windows 2003 (x64), I asked our os system, he said the server is ...
    Joan HsiehJoan Hsieh
    Oct 1, 2009 at 4:17 pm
    Oct 1, 2009 at 7:40 pm
  • Hi friends, I installed Oracle XE and the tool did not show the screen for changing the character set. It installed automatically as below. NLS_CHARACTERSET AL32UTF8 Character set I need to install ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Oct 1, 2009 at 1:02 pm
    Oct 1, 2009 at 7:39 pm
  • Hi, I'm looking for a document that show the steps for creating a 1-node RAC cluster. I've checked the oracle docs, metalink, and searched the web. Does anyone know where I could find this ...
    Ed lewisEd lewis
    Oct 31, 2009 at 1:29 pm
    Nov 2, 2009 at 2:02 pm
  • Hello everyone, We recently migrated few database ( and from Solaris 9 running on E25k to Solaris 10 running on T5120 running multiple zones. Entire directory structure was moved ...
    Oct 28, 2009 at 2:54 pm
    Oct 31, 2009 at 5:00 pm
  • Hello gurus, I got this error and I want to confirm my concepts are right. Session 1 delete from tab1 where col1=20; 0 rows deleted session2 truncate table tab1; I get "ORA-00054: resource busy and ...
    Dd yakkaliDd yakkali
    Oct 27, 2009 at 9:09 pm
    Oct 31, 2009 at 7:33 am
  • Asking the basic question here: Did you make the change to the tnsnames.ora file on the server where the source database is (the one where you created the link)? A link uses the database's naming ...
    Cliff NadlerCliff Nadler
    Oct 29, 2009 at 5:15 pm
    Oct 30, 2009 at 2:08 pm
  • Listers, EE on Aix 5.3. Asked to look at a new COTS application in development environment. Huge in-lists, 1000's of literal values ("column_name in (1,2,3..1000) or column name in ...
    Larry G. ElkinsLarry G. Elkins
    Oct 23, 2009 at 4:58 pm
    Oct 23, 2009 at 6:10 pm
  • http://jkstill.blogspot.com/2009/10/oracle-open-world-2009-report-part-two.html<http://jkstill.blogspot.com/2009/10/oracle-open-world-2009-report-part-two.html Jared Still Certifiable Oracle DBA and ...
    Jared StillJared Still
    Oct 15, 2009 at 7:16 pm
    Oct 21, 2009 at 6:55 pm
  • Hi All, I've been asked to provide our marketing people select access on some large tables, but want to stop them using "stupid" where clauses that stop partition pruning / index lookup. E.g ...
    Tony AdolphTony Adolph
    Oct 19, 2009 at 3:45 am
    Oct 19, 2009 at 1:01 pm
  • Hi, could you clarify how partitions are being added? Are they using alter table add partition or do they have, say, one partition with MAVALUE and they do alter table split partition ? -- Alex ...
    Alex FatkulinAlex Fatkulin
    Oct 15, 2009 at 5:46 pm
    Oct 16, 2009 at 2:57 pm
  • Hi listers, As usual we are having discussions regarding backups... this time it's exports. Should we take exports of databases? Assuming we have a valid and reliable tape backup structure (TSM with ...
    Guillermo Alan BortGuillermo Alan Bort
    Oct 7, 2009 at 8:31 am
    Oct 7, 2009 at 10:39 am
  • Ok so i'm trying to setup a process so we have an alternate location to write out archive logs. It appears the log_archive_dest_state_2 with an option of alternate would fit the bill. No matter what ...
    Oct 5, 2009 at 5:25 pm
    Oct 6, 2009 at 2:39 pm
  • So I log into My Oracle Support, I have an small issue and click the feedback button and post my issue. I get an email saying my SR has been updated and to log in, click SR tab and have a look. I do ...
    Ethan PostEthan Post
    Oct 28, 2009 at 3:09 pm
    Oct 28, 2009 at 8:07 pm
Group Navigation
period‹ prev | Oct 2009 | next ›
Group Overview
grouporacle-l @

194 users for October 2009

Jared Still: 40 posts Robert Freeman: 30 posts Rich Jesse: 20 posts : 19 posts Niall Litchfield: 18 posts Sanjay Mishra: 16 posts D'Hooge Freek: 15 posts Allen, Brandon: 14 posts Bobak, Mark: 13 posts Kenneth Naim: 12 posts Karl Arao: 11 posts Martin Bach: 11 posts Guillermo Alan Bort: 10 posts Kellyn Pedersen: 10 posts Goulet, Richard: 9 posts Hemant K Chitale: 9 posts Matthew Zito: 9 posts Yong Huang: 9 posts Alessandro Vercelli: 8 posts Tanel Poder: 8 posts
show more