Oracle

Excel question (was: Re: SQLPLUS Question)
On Jan 16, 12:37 pm, Jeremy <jeremy0...(a)gmail.com> wrote: In article <hit7pa$ph...(a)solani.org>, gogala.mla...(a)gmail.com says...> On Sat, 16 Jan 2010 20:28:55 +0100, Gerard H. Pille wrote: I start sqlplus from a ksh script as a job, send queries to it and read the answers.  ksh, which i... 16 Jan 2010 21:36

SQLPLUS Question
Hi, real simple question and one I suspect the answer to which is "no". Can you create sqlplus scripts with "conditions" such that if for example a SQL statement returns a particular value or error condition then path A or path B is followed? -- jeremy ... 22 Jan 2010 21:56

Generate a CRUD matrix
Is it possible to extract a CRUD matrix for a procedure or package in Oracle. I'm using 10.2.0.4 SE. Getting a list off tables etc is easy enough to do using ALL_DEPENDENCIES, but I would like to know for each table whether the proc is updating, inserting etc. -- Terry Dykstra ... 18 Jan 2010 14:15

deleting many rows from a table
All, Oracle 9.2.0.8 OS - HP Ux 11.23 We have table T count(*) = 31414748 table definition create table T ( OBJID NUMBER, DEV NUMBER, NAME VARCHAR2(20 BYTE), VALUE CLOB, CONTEXT_INST2GROUP_INST NUMBER, CONTEXT... 19 Jan 2010 14:37

Specify inventory pointer location
I am Oracle 11g 11.1 on HP UNIX 11i. I see Oracle provides invPtrLoc in some command such as runIntaller and Opatch. -invPtrLoc $ORACLE_BASE/oraInventory/oraInst.loc However when I go to run emca to configure db control it does not recognize this parameter. I know using symbolic links one can get around it, but ... 19 Jan 2010 14:37

Certification matrix for Windows 7
I could not find the certification matrix for Windows 7 on super new Metalink pages. The search for certified/planned gives 0 result. I would like to know which version of Windows 7 is/will be certified. Best regards, -- Lucyna Witkowska ... 21 Jan 2010 03:27

Discrepancy between Top 5 wait events and object statistics
Hi, Since we started running Statspack at level 7 I noticed that often "Top 5 Wait Events" section does not match object statistics section. For example: Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time ------------------------... 13 Jan 2010 02:11

Materialized Views
I'm getting an error when I try an do a fast refresh on a materialized view. The base table is very simple, 3 columns. But, it exists over a database link. Like everyone else I am receiving a ORA-12054. I've had no luck with tryong everything out with all the example definitions. This is one table with a prima... 12 Jan 2010 17:25

Connections which go bad
Hello, I'm having trouble with JDBC transactions to an Oracle which are dropped after a while of inactivity. The situation can be reproduced using sqlplus: E.g. at time t1, I connect with sqlplus and run a simple query like =================================================== SQL> SELECT banner FROM v$versi... 18 Jan 2010 19:54

Problem renaming a Tablespace Datafile in 10.2.0.4
Hi I have a tablespace called EXT_DATA which has 4 datafiles. When I created the 4th datafile I accidentally prefixed it with a period and want to remove this as it is causing issues with my backup scripts. I brought the tablespace offline and issued the following command. alter tablespace ext_data rename data... 11 Jan 2010 10:50