Search Discussions

116 discussions - 607 posts

  • Any thoughts on the "new" syntax for INSERT statements below? INSERT INTO my_table ( id = seq.nexval, create_date = SYSDATE, update_date = SYSDATE, col1 = 'A', col2 = 'SOMETHING', col3 = 'SOMETHING', ...
    Chet justiceChet justice
    Sep 10, 2009 at 1:37 am
    Sep 15, 2009 at 11:12 pm
  • Hello all, A manager just asked me to make a connection from oracle to sql server and wants a view created from sql server data. I've gone the other way but never from oracle to sql server. I did a ...
    Zelli, BrianZelli, Brian
    Sep 9, 2009 at 5:12 pm
    Sep 14, 2009 at 6:23 pm
  • Ok fellow full-time employee DBAs I have a question. (Not for contractors :) How many of you use project accounting at your place of work. Where every hour has to be accounted for against projects, ...
    Taylor, Chris DavidTaylor, Chris David
    Sep 18, 2009 at 8:28 pm
    Sep 21, 2009 at 2:58 pm
  • Thanks! Is there a good synopsis of the differences between 11gR1 and R2? Not finding much yet.... The documentation does not really spell out those specific differences (that I have found so far), ...
    Charles SchultzCharles Schultz
    Sep 1, 2009 at 1:28 pm
    Sep 7, 2009 at 5:38 am
  • Did you do partprobe on your 2nd node? Karl Arao http://karlarao.wordpress.com -- http://www.freelists.org/webpage/oracle-l
    Karl AraoKarl Arao
    Sep 16, 2009 at 6:09 pm
    Sep 17, 2009 at 3:10 pm
  • Hi List, once again I stumble about two realy dumb (and related) questions: 1) what is the data dictionary (or how can I identify objects which belongs to it)? 2) is there any spyhole to view into ...
    Martin BergerMartin Berger
    Sep 21, 2009 at 8:15 pm
    Sep 23, 2009 at 11:21 pm
  • A few of the things from the 11gR2 new features guide that are interesting to me. i just cut and paste from the doc, so no value add but if anyone feels inspired to share the things from the 11gR2 ...
    Job MillerJob Miller
    Sep 3, 2009 at 2:16 pm
    Sep 17, 2009 at 4:48 am
  • Hello everybody, I'm building my first Clusterware couple of nodes (RHEL 5.3, Clusterware 11gR1, OCFS2 on ISCSI) with 2 Oracle 11gR1 databases (_single instance_); one db for each node, with failover ...
    Alessandro VercelliAlessandro Vercelli
    Sep 30, 2009 at 10:06 am
    Oct 5, 2009 at 9:30 am
  • Hi, How can I identify if the database is an Oracle Enterprise Version or an Oracle Express Version. Consider that I don´t have access privilige in the v$database and others v$. Is there another way ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Sep 24, 2009 at 11:41 am
    Sep 29, 2009 at 4:21 pm
  • Hi I have been asked to consider a RANSAN for our Oracle DW database. I was wondering if anyone had any experience of the technology? Pros and the Cons. Thanks Rob -- ...
    Rob DempseyRob Dempsey
    Sep 9, 2009 at 11:54 am
    Sep 21, 2009 at 1:19 pm
  • I've taken over a 9ir2 data warehouse and its loading process. Here are some 'highlights' of the current 9i warehouse environment(I didn't do this!) Oracle Solaris 9 4x1200mhz sparcv9 cpu ...
    Neil KodnerNeil Kodner
    Sep 14, 2009 at 1:21 pm
    Sep 16, 2009 at 6:38 pm
  • I have a table with 1 - 2 million records. I need to add a column to indicate if the records is active or not. I would guess that only 1,000 of the records would not be active. Should I make one of ...
    Steiner, RandySteiner, Randy
    Sep 16, 2009 at 6:43 pm
    Oct 1, 2009 at 4:30 pm
  • Hi One of my friend is working on the hardware selection to setup Oracle Training environment for 5-10 people. He is going to use Oracle VMWARE/OEL 5 for the setup. Does anybody has such hardware ...
    Sanjay MishraSanjay Mishra
    Sep 22, 2009 at 3:18 pm
    Sep 22, 2009 at 7:49 pm
  • Hey all, A coworker asks me about casting an NCHAR column to NUMBER in a query on (AIX), so I of course offer up the syntax of TO_NUMBER. Somewhat knowing the data, I warn that conversions ...
    Rich JesseRich Jesse
    Sep 8, 2009 at 8:49 pm
    Sep 9, 2009 at 7:31 pm
  • Howdy all, In on AIX I have two DBs, PROD and DEV. Each are backed up using RMAN with no catalog. Each has it's CONTROL_FILE_RECORD_KEEP_TIME to the default of 7. PROD has it's ...
    Rich JesseRich Jesse
    Sep 29, 2009 at 4:36 pm
    Sep 30, 2009 at 6:39 pm
  • Why not just upgrade via exp/imp or datapump? Probably much easier than running DBUA, and if they're small, then shouldn't take much time either. Regards, Brandon Privileged/Confidential Information ...
    Allen, BrandonAllen, Brandon
    Sep 29, 2009 at 7:57 pm
    Sep 30, 2009 at 12:53 pm
  • I'm curious how much "headroom" people like to maintain in their datafiles? We have a large data reorganization procedure underway as part of our DR discovery process and I was playing around with ...
    Taylor, Chris DavidTaylor, Chris David
    Sep 16, 2009 at 3:27 pm
    Sep 21, 2009 at 5:46 am
  • I recently tried to make a case for views<http://www.oraclenerd.com/2009/09/case-for-views.html , in the last line of the post I wrote: Records in a table typically constitute data. Tables, joined ...
    Chet justiceChet justice
    Sep 5, 2009 at 4:36 am
    Sep 8, 2009 at 4:21 pm
  • On ORACLE 10GR2 and 11G is it possible grant access privileges on schema level NOT table/view level. for example, I want grant 'select, update, delete" on one schema (all object under that schema) to ...
    Dba1 mccDba1 mcc
    Sep 28, 2009 at 6:07 pm
    Oct 1, 2009 at 12:07 pm
  • I found another reference that suggested LEFT join actually implies OUTER join. The ANSI standard itself is confusing to me, so I am all ears for accurate interpretations. =) Another ramification is ...
    Charles SchultzCharles Schultz
    Sep 23, 2009 at 7:41 pm
    Sep 25, 2009 at 5:51 pm
  • Hi list, I'm stumped on this one and hoping one of you will see something I'm missing. I've got a query coming in from a 3rd party app and it's using a bind variable for a date. I can see in the ...
    Allen, BrandonAllen, Brandon
    Sep 21, 2009 at 9:27 pm
    Sep 24, 2009 at 6:59 pm
  • Recently we had an issue where queries received a non-desirable explain plan, after weeks and weeks of production use. This lead to hundreds of sessions waiting on direct path write temp. I suspect ...
    Neil kodnerNeil kodner
    Sep 17, 2009 at 12:41 pm
    Sep 23, 2009 at 4:31 am
  • Hi List, I am facing a problem in our DWH database ( a query on a partition gives a ORA-8103 (object no longer exists). But I checked last_ddl_time from dba_objects which is 8-Aug-2009 ...
    Martin BergerMartin Berger
    Sep 8, 2009 at 7:03 pm
    Sep 10, 2009 at 6:54 am
  • Hi All, SQLNET.AUTHENTICATION_SERVICES = (NONE) results in ERROR: ORA-01031: insufficient privileges when I connect with "/ as sysdba". This the expected behavior. The problem is that database ...
    Sundar mahadevanSundar mahadevan
    Sep 21, 2009 at 10:05 pm
    Sep 23, 2009 at 1:51 am
  • Greetings I am using Oracle external tables to read alert log to display the content on a webpage Oracle Version :oracle and oracle10grel2 Looking for a sql to read Today's alert log contents ...
    Sep 21, 2009 at 3:58 pm
    Sep 22, 2009 at 1:22 pm
  • Hi We have a suncluster on top of which we are trying to install the clusterware. The installation is fine but when you run root.sh it fails to bring ocssd.bin. I think it is looping at ...
    Kumar MadduriKumar Madduri
    Sep 3, 2009 at 8:37 pm
    Sep 9, 2009 at 12:15 am
  • OS: RH Linux 4 Database: 32bit 10gR2 While working out a method to set some reasonable system statson our databases, I find that dbms_stats.set_system_stats is a bit of an oddity. According to the ...
    Jared StillJared Still
    Sep 25, 2009 at 6:03 pm
    Sep 29, 2009 at 6:52 pm
  • The latest version is available for download here: http://www.oracle.com/technology/software/products/sql/index21_EA1.html New Feature List can be found here ...
    Chet justiceChet justice
    Sep 24, 2009 at 9:08 pm
    Sep 25, 2009 at 4:29 pm
  • Database: DP: I've received a datapump export of our production database (objects only) so that I can test my migration script. On first go, none of the tables were created because ...
    Chet justiceChet justice
    Sep 17, 2009 at 5:45 pm
    Sep 17, 2009 at 5:56 pm
  • Ok, I'm drawing a blank here as my brain seems to hvae taken the afternoon off. I have a dataset: HOST_NAME TARGET_NAME SNAP_DATE TABLESPACE_SIZE ------------------- ------------------------ ...
    Taylor, Chris DavidTaylor, Chris David
    Sep 14, 2009 at 8:09 pm
    Sep 14, 2009 at 8:55 pm
  • Hi, I have a stored procedure that runs a simple select statement and returns a series of parameters, the total size of the parameters returned in bytes should be 1032 bytes. However when I trace the ...
    Fred TillyFred Tilly
    Sep 4, 2009 at 1:47 pm
    Sep 12, 2009 at 12:50 pm
  • Hi folks We have an issue on a database box where we have approx 1500 users connected to a database set up with shared servers (due to memory shortage). Now we have a situation where the dispatchers ...
    Stefan KnechtStefan Knecht
    Sep 8, 2009 at 7:36 am
    Sep 9, 2009 at 8:35 am
  • LinkedIn I'd like to add you to my professional network on LinkedIn. Satyanarayana Learn more: https://www.linkedin.com/e/isd/712246762/sT42kmUl/ (c) 2009, LinkedIn Corporation -- ...
    Satyanarayana Gudivada VarahaSatyanarayana Gudivada Varaha
    Sep 1, 2009 at 6:26 pm
    Sep 2, 2009 at 1:15 pm
  • All, I am not convinced this is possible. I have a consistent cold backup, however it is very large and I don't have the space to copy the entire thing to a dev box. Is it possible to restore only ...
    Josh CollierJosh Collier
    Sep 8, 2009 at 5:43 pm
    Sep 30, 2009 at 4:20 pm
  • Hi All, I would like to know if there is a way to find out if my index is scattered. Lets say I have a table and the table's primary key(or the indexed key) is inserted/updated and deleted ...
    Sundar mahadevanSundar mahadevan
    Sep 15, 2009 at 3:45 pm
    Sep 29, 2009 at 1:01 pm
  • Hi I have a 4 nodes RAC running on Solaris 10 each with 5 quadcore CPU (or Dual with Threading not sure). Shows 20 CPU in psrinfo. A few days ago we were running with two nodes only and one node ...
    LS ChengLS Cheng
    Sep 24, 2009 at 4:55 am
    Sep 28, 2009 at 8:25 am
  • � I need a script that will select the owner and table names for the user-defined schemas that do not have any columns defined with a datatype = LONG. The script need to skip the table if any column ...
    Helen MitchellHelen Mitchell
    Sep 23, 2009 at 1:11 pm
    Sep 24, 2009 at 5:52 am
  • Gurus, I would like to know if any one is running oracle ERP 11.5.9 [Production] environment on Sun Solaris 10, if yes what are the issues and risks involved and what could be the best practices. Our ...
    Avadhani mysAvadhani mys
    Sep 15, 2009 at 7:00 am
    Sep 16, 2009 at 5:20 pm
  • Hi all, Running Oracle 9.2 on Windows. I know this is Oracle forum, but it's somewhat related. This question is for those of you who run Oracle on Windows. I have several ".txt" files in a directory ...
    Eugene PipkoEugene Pipko
    Sep 8, 2009 at 9:45 pm
    Sep 9, 2009 at 7:21 pm
  • Hello people. Do any of you know of any iPhone Apps targeted at Oracle DBAs to help with Oracle DBA work? It looks like there are some apps out there for EBS but I cant find anything for generic ...
    Owen SmithOwen Smith
    Sep 7, 2009 at 7:42 am
    Sep 8, 2009 at 6:14 pm
  • Hi, We use RMAN to backup database to disk. And then use TSM TDP to backup RMAN backupsets from disk to TSM. Trouble is for each backup piece TDP is creating separate session to TSM. Has anyone else ...
    Vishal GuptaVishal Gupta
    Sep 30, 2009 at 8:36 pm
    Oct 2, 2009 at 2:14 pm
  • Does anyone have any recommendations for a good/detailed Oracle analytic SQL book (analytic functions from the "ground up")? Thanks, Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN ...
    Taylor, Chris DavidTaylor, Chris David
    Sep 29, 2009 at 8:09 pm
    Sep 30, 2009 at 4:47 pm
  • Look at my watch...9:11 pm exactly. hit return on "sleep 60"... wait until it comes back, date on server says it took 60 seconds... Look at my watch...now 9:12 and 14 seconds...huh, never seen that ...
    Ethan PostEthan Post
    Sep 30, 2009 at 2:14 am
    Sep 30, 2009 at 4:42 pm
  • Hello: I have an Oracle database running on Windows Server 2003. Deadlocks are being reported in the alert log. These deadlocks are being generated by a 3rd party application. The two ...
    Julio Aguilar-ChangJulio Aguilar-Chang
    Sep 29, 2009 at 7:06 pm
    Sep 30, 2009 at 1:49 am
  • Hello all, I have an INTERESTING scenario that I would like to run by you folks. I have been assigned the task of migrating an existing data warehouse of approximately 2 TB to a new server running ...
    Lou AvramiLou Avrami
    Sep 21, 2009 at 5:44 pm
    Sep 21, 2009 at 8:32 pm
  • Hello All, any tools/scripts out there that you are aware of, to extract all select/insert/update/delete statements from within the packages for a schema? The schema in question has very large number ...
    Rajesh RaoRajesh Rao
    Sep 15, 2009 at 2:22 pm
    Sep 16, 2009 at 9:46 pm
  • Hello, I have a few questions regarding dataguard. We currently have DG running in a 2 node cluster, and a third server (non-rac) The primary, and physical standby run in the cluster. The LSB being ...
    Ed lewisEd lewis
    Sep 16, 2009 at 2:29 pm
    Sep 16, 2009 at 5:39 pm
  • I write some finance interface files using utl_file from 1 10r2 database running on windows server onto another windows server using the UNC name and it works fine. Our internal audit would like us ...
    Kenneth NaimKenneth Naim
    Sep 15, 2009 at 10:35 pm
    Sep 16, 2009 at 12:24 pm
  • From: Paul Barrett To: oracle-l@freelists.org; Subject: Ocr and Voting disk - slow disk Date: Sep 10, 8:32 AM Is it advisable to put the ocr and voting disks on slow disks - 10,000 RPM fiber channel ...
    Paul BarrettPaul Barrett
    Sep 10, 2009 at 4:01 pm
    Sep 11, 2009 at 6:23 am
  • Hello again, I created a MV and create some indexes on the MV. Now the same refresh takes much longer. Is there an easy way to defer the index building until the MV refresh is done? Otherwise, I ...
    Roger XuRoger Xu
    Sep 2, 2009 at 4:50 pm
    Sep 3, 2009 at 5:02 am
Group Navigation
period‹ prev | Sep 2009 | next ›
Group Overview
grouporacle-l @

164 users for September 2009

Jkstill: 24 posts Goulet, Richard: 23 posts Chet justice: 21 posts Niall Litchfield: 18 posts Allen, Brandon: 17 posts Rich Jesse: 16 posts Tanel Poder: 16 posts Greg Rahn: 13 posts Martin Berger: 12 posts Matthew Zito: 12 posts Michael Moore: 12 posts Taylor, Chris David: 12 posts Andrew Kerber: 10 posts D'Hooge Freek: 10 posts Nuno Souto: 10 posts Robert Freeman: 9 posts Balakrishna Y: 8 posts Bill Ferguson: 8 posts Sundar mahadevan: 8 posts : 7 posts
show more