FAQ

Search Discussions

160 discussions - 859 posts

  • Hi, I dont understand something about pricing. This page says ...
    Veres LajosVeres Lajos
    Jan 16, 2010 at 10:40 am
    Jan 22, 2010 at 3:17 pm
  • Greetings, I have convinced management to allow me to grant read-only access to the developers. The problem is that they know the application passwords and have been using those passwords to ...
    Blanchard, WilliamBlanchard, William
    Jan 7, 2010 at 8:21 pm
    Jan 13, 2010 at 10:07 am
  • (Resending-forgot subject line, sorry!) Dear list members, I just came across this when downloading patches for a new system. A new bunch of Patch Set Updates is out: 10.2.0.4.3 for RDBMS 10.2.0.4.2 ...
    Martin BachMartin Bach
    Jan 13, 2010 at 3:25 pm
    Jan 25, 2010 at 8:43 pm
  • Hi, We had an issue with one of our scripts where it did a crosscheck and because our tapes weren't in the cabinet, they got marked and removed. I know how to catalog backups that are on disk, but is ...
    Thomas RoachThomas Roach
    Jan 25, 2010 at 6:34 pm
    Feb 2, 2010 at 2:14 pm
  • List, We have an audit finding related to data integrity. I'm looking for a way to detect all database changes on a small test database. Fortunately the environment is well-contained. Typically when ...
    Dennis WilliamsDennis Williams
    Jan 11, 2010 at 5:24 pm
    Jan 13, 2010 at 9:21 pm
  • We have lots of batch jobs (in an old application) that we would like to rewrite in PL/SQL. These jobs have to be scheduled by end users. The Oracle Scheduler (from 10g) has all the features needed ...
    Louis BROUILLETTELouis BROUILLETTE
    Jan 19, 2010 at 2:27 pm
    Jan 19, 2010 at 8:32 pm
  • Hi, -- http://www.freelists.org/webpage/oracle-l
    Eriovaldo AndriettaEriovaldo Andrietta
    Jan 18, 2010 at 1:26 pm
    Jan 19, 2010 at 3:24 pm
  • I use the term "interesting" in the subject line loosely! I'm cloning an Oracle 9i (9208) production database to a different test server. I decided to use an existing rman backup of the database and ...
    Dunbar, NormanDunbar, Norman
    Jan 27, 2010 at 10:40 am
    Jan 28, 2010 at 8:51 am
  • Dear list members, the subject line says it all... Anyone planning on going live with 11.2 (single instance/RAC in Q1 or Q2)? What's the experience so far? I have noticed Mark Bobak's email about ...
    Martin BachMartin Bach
    Jan 13, 2010 at 3:38 pm
    Jan 14, 2010 at 1:34 am
  • All, I am sharing my yesterday experience with you, below are the details: * ISSUE: * Not able to access the table. ** *DEPLOYMENT:* In a A schema we have 7 tables x1, x2.... x7 which is further join ...
    AMIT VERMAAMIT VERMA
    Jan 23, 2010 at 6:27 am
    Jan 28, 2010 at 1:49 pm
  • Hi. strings oracle.exe | grep radiohead Starting at least at 10.2.0.1, function kfasSelfTest_update() (located in kfas.o) use Radiohead lyrics to test... something related to ASM probably. Schematic ...
    Dennis YurichevDennis Yurichev
    Jan 25, 2010 at 8:16 am
    Jan 27, 2010 at 6:48 am
  • MOS's new flash interface could have been worse. much worse. very, very much worse. http://www.iamthenode.com/ Warning although this is an oracle related site, don't browse it with a headache or if ...
    Niall LitchfieldNiall Litchfield
    Jan 11, 2010 at 1:23 pm
    Jan 11, 2010 at 8:24 pm
  • Hi, Was wondering if anyone could share their experience of having to export import VLDB's in a 9i environment. For certains reason the database that I need to migrate cannot be upgraded - which ...
    Oracle Dba WannabeOracle Dba Wannabe
    Jan 16, 2010 at 8:40 am
    Feb 2, 2010 at 6:30 pm
  • As I am learning Oracle in the Windows environment, I noticed that I do not have to set ORACLE_HOME. Am I missing something? Thanks! H:\ echo %ORACLE_HOME% %ORACLE_HOME% H:\ sqlplus ...
    Roger XuRoger Xu
    Jan 18, 2010 at 9:27 pm
    Jan 20, 2010 at 5:07 pm
  • I am migrating a website from Oracle 8i to 11g, and one of the snags I've run into is the character set. The old database has both NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET set to US7ASCII. This ...
    Janine SiskJanine Sisk
    Jan 7, 2010 at 9:10 pm
    Jan 14, 2010 at 2:12 pm
  • Hi all, I am looking for a way for show the following 'AC_892_z30' 1,2,3 'BK_281_k16' 1,2 'FN_485_a30' 1,2 in one query if possible Here is the data: CREATE TABLE EP_FORM ( COL_1 VARCHAR2(30 BYTE), ...
    Eugene PipkoEugene Pipko
    Jan 26, 2010 at 6:21 pm
    Jan 26, 2010 at 11:49 pm
  • Anyone using the CentOS linux build in a production Oracle database environment? Comments?? This communication is the property of Qwest and may contain confidential or privileged information ...
    Vordos, SuzyVordos, Suzy
    Jan 26, 2010 at 5:08 pm
    Jan 26, 2010 at 9:09 pm
  • We have some MS Sql databases and need to run some queries from Oracle. Our Oracle database is at 9.2.0.8 version running on Solaris. According to Oracle we need to set up a Database Gateway for ODBC ...
    Ana ChotoAna Choto
    Jan 4, 2010 at 4:05 pm
    Jan 6, 2010 at 1:55 pm
  • Can someone please tell me what I'm missing here ... [oracle_at_msdbc11 backup-scripts]$ rman target=/ Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jan 3 14:08:41 2010 Copyright (c) 1982, ...
    Steve BaldwinSteve Baldwin
    Jan 3, 2010 at 9:04 pm
    Aug 12, 2010 at 3:57 pm
  • hi, i would like to test oracle rac 10g & 11g. please advise me what os, vm & hardware should i use.. thanks in advance amit v -- Amit Verma v.amit84_at_skype.com "Winning takes talent but it takes ...
    AMIT VERMAAMIT VERMA
    Jan 23, 2010 at 2:49 pm
    Jan 24, 2010 at 9:12 pm
  • Can anyone suggest some experience with big updates. I had at table with 30 column (non-Lob or LONG) in 10g and has few indexes. I need to update 20 million Records of 100Million, what is the best ...
    Sanjay MishraSanjay Mishra
    Jan 21, 2010 at 9:33 pm
    Jan 23, 2010 at 5:26 am
  • Hi DBA Gurus, Does anyone know why checkpoint scn does not write to datafile header in the following scenario? Parameter log_checkpoint_timeout = 1200 Incremental checkpoints show in alert.log: Wed ...
    Jiang, LuJiang, Lu
    Jan 13, 2010 at 8:54 pm
    Jan 15, 2010 at 3:33 pm
  • Hello, I'm having a real nightmare upgrading a 2 node 10.2.0.4 RAC cluster up to 11.2.0.1. This is running rhel 4 U3, 2.6.9 linux kernel (it's x86-64) Upon starting the Grid infrastructure install, I ...
    Jason arneilJason arneil
    Jan 4, 2010 at 4:03 pm
    Jan 7, 2010 at 1:52 pm
  • I have ORACLE database 10.2.0.4 on Redhat AS 5.4 (X86-64). Recently I found some time there have process call "ora_pXXX_dbname" will pop up and may up to 128 processes. Those "ora_pxxx_dbanme" will ...
    Dba1 mccDba1 mcc
    Jan 4, 2010 at 2:34 pm
    Jan 5, 2010 at 1:00 pm
  • Hi Folks, I've got a remote system running RHAS 4 64-bit and Oracle 10.2.0.4 64-bit. When we put a valid value for a nameserver in resolv.conf, it seems that SQL*Net or something from the Oracle side ...
    MkbMkb
    Jan 22, 2010 at 8:16 pm
    Feb 18, 2010 at 9:35 pm
  • Hi all, I have the following line in the file in the text file being sent to me (just an example): x 16 18 20 22 24 <- tab (hidden) Very last character on that line is TAB character. I am trying to ...
    Eugene PipkoEugene Pipko
    Jan 28, 2010 at 6:36 pm
    Jan 29, 2010 at 6:16 pm
  • I posted here the other day mentioning that I no longer have MOS access and someone suggested that I buy a cheap Oracle license, just for the support. I decided to take a look at the store today and ...
    Janine SiskJanine Sisk
    Jan 13, 2010 at 10:00 pm
    Jan 15, 2010 at 1:28 pm
  • I am attempting to understand and explain ASSM being used for a Tablespace that is dedicated for Indexes. I can understand ASSM and it being an alternative to FreeLists and PCTUSED for *Tables*. But ...
    Hemant K ChitaleHemant K Chitale
    Jan 2, 2010 at 3:18 pm
    Jan 6, 2010 at 5:09 pm
  • Guys, AIX 6.1 Oracle 10.2.0.3 One of our clients is getting an issue when running some scripts. This has worked plenty of times before with no errors, the only difference they think is that they are ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Jan 4, 2010 at 4:19 pm
    Jan 5, 2010 at 9:59 am
  • Dear listers, I'd like to add another "interesting" problem to today's interesting RMAN problem. I have quite a bit of output from diagnostic tools, hopefully this doesn't got too badly mangled.. ...
    Martin BachMartin Bach
    Jan 27, 2010 at 5:13 pm
    Feb 1, 2010 at 3:07 pm
  • Hi all, I have a procedure that loads data from file using external tables. It bulk collects data from external table into a collection, does a little transformations on the data and inserts into a ...
    Domagoj SmoljanovicDomagoj Smoljanovic
    Jan 19, 2010 at 5:06 pm
    Jan 26, 2010 at 4:20 am
  • I am not talking about the change to either the connect or session view (I can't remember which one changed). I don't see anything about this in the oracle upgrade doc or in the release notes for the ...
    Dba DBADba DBA
    Jan 20, 2010 at 8:02 pm
    Jan 22, 2010 at 6:43 am
  • Is anybody else having problems downloading from OTN? I haven't been able to since since Friday or Saturday. Every time I select a file to download, then it takes me to the id and password page, so I ...
    Bill FergusonBill Ferguson
    Jan 19, 2010 at 2:41 pm
    Jan 21, 2010 at 2:42 pm
  • Hey all, I have a small standalone OEL4 box running a 10.2.0.3 Grid Control OMS with a 10.2.0.3 Repository DB. I need to migrate this to Grid Control 10.2.0.5 for some plugin work. Since I have no ...
    Rich JesseRich Jesse
    Jan 18, 2010 at 7:30 pm
    Jan 19, 2010 at 8:04 pm
  • Hi listers, I am stuck with the error that I do not know how to resolve: i am trying to make an import using data pump and it fails. Please, look below. I search google and implemented all ...
    Masha GurenichMasha Gurenich
    Jan 15, 2010 at 3:34 pm
    Jan 15, 2010 at 5:50 pm
  • When looking for patches using Advanced Search I get following after having chosen Product or Product Family: Error 500 - Invalid Form You have improperly entered this application. The only supported ...
    Andre van WinssenAndre van Winssen
    Jan 13, 2010 at 7:28 pm
    Jan 13, 2010 at 8:45 pm
  • 4 node RAC - 10.2.0.4 Linux x86_64 RHEL 5.3 Tablespace ASSM on the Tablespaces (but the table has PCTFREE of 10 and PCTUSED of 0 "which should be ignored because of ASSM." Reporting Table Partitioned ...
    Thomas RoachThomas Roach
    Jan 11, 2010 at 10:55 pm
    Jan 12, 2010 at 3:35 pm
  • I have a simple SQL query which lists all the records that are not in a second table. select first.id from first where first.id not in (select id from second); As the second table is very huge, it ...
    Pani BabuPani Babu
    Jan 7, 2010 at 5:03 pm
    Jan 7, 2010 at 5:33 pm
  • We have ORACLE 10GR2 on UNIX server and some of SQL statements run much longer on first after that it only run few seconds. I know the reason first time SQL statements run need parse and other ...
    Dba1 mccDba1 mcc
    Jan 31, 2010 at 11:17 pm
    Feb 1, 2010 at 6:00 pm
  • Hi List, On the AWR report we see the "Operating System Statistics" section.. since generating multiple AWR reports is daunting and takes a lot of time and I'm only interested on particular columns ...
    Karl AraoKarl Arao
    Jan 28, 2010 at 7:14 pm
    Jan 31, 2010 at 6:34 pm
  • Hi Listers, Can you please share your thoughts about how to go about tuning queries that use "IS NULL" / "IS NOT NULL" conditions in where clause? I have a million row table similar to the one shown ...
    Srinivas ChintamaniSrinivas Chintamani
    Jan 30, 2010 at 1:30 am
    Jan 31, 2010 at 1:07 am
  • Hi, Are you using FireFox 3.6? MOS does not work properly, with FF 3.6 you have to right click and open in another tab or window. See ...
    Peter HitchmanPeter Hitchman
    Jan 27, 2010 at 5:36 pm
    Jan 29, 2010 at 2:57 pm
  • Hi I was doing some cluster destructive tests on RAC 11gR2 a few days ago. One of tests was kill ASM and see how does that affects Clusterware operation since OCR and Voting Disks are located in ASM ...
    LS ChengLS Cheng
    Jan 21, 2010 at 8:51 am
    Jan 23, 2010 at 8:43 am
  • Platform: IBM Series z OS: SUSE 10 Oracle: EE 10gR2 *Current situation*: Concern that the application is not scalable. Some large tables are have heavy loads, a mix of read/write, heavier on the ...
    Sandra BeckerSandra Becker
    Jan 21, 2010 at 5:18 pm
    Jan 22, 2010 at 5:48 pm
  • Kellyn, This is a cool script to detect gaps in the physical standby setup. Does anyone has something like this to detect gaps in the logical standby setup? Thanks, Roger Xu -- ...
    Roger XuRoger Xu
    Jan 20, 2010 at 6:03 pm
    Jan 22, 2010 at 4:01 am
  • Hi, I have a quick question about using sqlplus here. There is a requirement to select 1 column and spool out to a plain text file. The data type if varchar2(1500) but most of rows are only 100 ...
    Lei ZengLei Zeng
    Jan 5, 2010 at 10:30 pm
    Jan 6, 2010 at 4:58 pm
  • All, Does anyone have any good pointers to the meaning of the time column in the explain plan output of DBMS_WORKLOAD_REPOSITORY.AWR_SQL_REPORT_HTML function (called by awrsqrpt.sql. I have a classic ...
    Niall.litchfield_at_gmail.comNiall.litchfield_at_gmail.com
    Jan 5, 2010 at 2:08 pm
    Jan 6, 2010 at 1:25 am
  • Dear fellow oracle-l'ers, recently I stumbled over a high availability (HA) concept for an Oracle DB server that involves DRBD, at least for the OS and storage part. The concept was presented by an ...
    Uwe KüchlerUwe Küchler
    Jan 21, 2010 at 3:57 pm
    Feb 5, 2010 at 5:20 pm
  • For thick clients the tnsnames.ora file includes two or more hosts for a given service_name, I believe clients treat this as an ordered list and try each one until a connection is established. Thin ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jan 14, 2010 at 6:11 pm
    Jan 31, 2010 at 2:51 pm
  • All, I'm going to start a new thread away from the Undo tablespace link because, well this is just dumb & I'm wondering how many others have heard similar things. BTW I've changed names to protect ...
    Goulet, RichardGoulet, Richard
    Jan 18, 2010 at 6:51 pm
    Jan 31, 2010 at 6:56 am
Group Navigation
period‹ prev | Jan 2010 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions160
posts859
users217
websiteoracle.com

217 users for January 2010

Kellyn Pedersen: 35 posts Jared Still: 30 posts Goulet, Richard: 29 posts Niall.litchfield_at_gmail.com: 27 posts Troach_at_gmail.com: 25 posts Allen, Brandon: 22 posts Martin Bach: 18 posts Robert Freeman: 18 posts Rich Jesse: 14 posts Roger Xu: 14 posts Dunbar, Norman: 13 posts Bobak, Mark: 11 posts Karl Arao: 11 posts Matthew Zito: 11 posts Govindan K: 10 posts Michael McMullen: 10 posts Peter Hitchman: 10 posts Andre van Winssen: 9 posts Blanchard, William: 9 posts Dba DBA: 9 posts
show more
Archives