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...

The Magnet

01-19-2010 08:28 AM
Hemant K Chitale

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...

Troels Arvin

01-18-2010 06:05 PM
Gunter Herrmann

Hi I have a big table with 2 clob columns I have to truncate this table I did: how can I get the released space ? Thanks in advance

bob123

01-18-2010 04:40 PM
Mladen Gogala

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...

Terry Dykstra

01-18-2010 12:22 PM
Terry Dykstra

Hi, I am involved in designing the architecture for a green field web application. Oracle 11g on the back end, tomcat at the front. No fully fledged...

Ralph.in.NZ@googlemail.com

01-13-2010 08:35 AM
Ralph.in.NZ@googlemail.com

Hi List, I use Oracle 10 XE. I'm a student. When I wrote my lab then I had found that Oracle alerts about an error for the line: call...

Daneel Yaitskov

01-13-2010 03:11 AM
Frank van Bortel

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...

vsevolod afanassiev

01-13-2010 12:28 AM
Jonathan Lewis

Hi ------------------------- Oracle 10g R2 10.2.0.4.0 Windows Server 2003 ------------------------- I realise it is not possible to reference the...

Jeremy

01-12-2010 03:28 AM
Jeremy

Hey all, I was looking for some guidance. I need to do some stat analysis on a production audit table. One problem is that there are no indexes...

Cliff

01-11-2010 08:54 PM
Hemant K Chitale

working in 10.2.0.4 enterpise on windows nt / have truncated many objects from a tablespace...rman backups reduced by 400g but can't shrink any...

dba cjb

01-11-2010 01:20 PM
Robert Klemme

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...

Johne_uk

01-11-2010 09:01 AM
Johne_uk

Is there a way for me to figure out how many days in 3 months? For example, say I have this: x := ADD_MONTHS(v_date,3); Depending on the value of...

The Magnet

01-11-2010 12:09 AM
Nevin Hahn

I'm trying to find the records in Table A, that are not in Table B. So I thought the Minus set operator would be a good tool to use. select count(*)...

jimmyb

01-10-2010 11:59 PM
Nevin Hahn

Driving and Car Maintenance: Transportation accounts for 66% of U.S. oil use -mainly in the form of gasoline. Luckily, there are plenty of ways to...

.

01-10-2010 01:19 PM
.

Hi, I have to move a big tablespace with a minimum of offline time. So is it possible to do: - alter tablespace begin backup - cp datafiles - alter...

bob123

01-09-2010 05:18 PM
joel garry

Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.

..

01-08-2010 02:39 PM
..

I am analyzing a trace file and the developer asked me when has this event taken place: ===================== PARSING IN CURSOR #3 len=159 dep=0...

Mladen Gogala

01-06-2010 05:22 PM
joel garry

PLEASE SEND YOUR RESUME AT anant.mehra (AT) ustechsolutionsinc (DOT) com or you can reach me at 201 484 7939 Extn:383 Manages and maintains all...

nanto

01-06-2010 10:37 AM
nanto

Hi, I have a lot of queries like below: How can I speed up this query ? Thanks in advance (Oracle 9.2.0.6)

bob123

01-06-2010 05:14 AM
Frank van Bortel

I am searching for the best ebooks for : 1-database systems 2-oracle 11 sql/pl 3-oracle 11 developer Please recommend them for me . Also I need to...

happy

01-06-2010 05:12 AM
Frank van Bortel

Hi, Is Oracle 10g RAC certified on IBM DS 3400 storage with RH Linux and ASM for database files? I thought it was DS 4700 and onwards that was...

Bruce

01-05-2010 12:50 PM
hpuxrac

Hallo en een gelukkig nieuwjaar / happy new year! Our Oracle instances on AIX use DS6800 for storage, but the DS6800 will have to be replaced. One...

Gerard H. Pille

01-05-2010 10:39 AM
skyste-

Hello, today an old oracle rac 9.2 database crashed to due power problem. Both nodes were restarted. Manually I've restard oracm as root and the...

skyste-

01-05-2010 09:09 AM
skyste-

I am on Oracle 11g Release 1 (11.1.0.7.1). Oracle 11g provides adapting threshold for SYSTEM_MOVING_WINDOW AWR Baseline. However, I want to set...

zigzagdna

01-05-2010 06:53 AM
ddf

Happy New Year Happy New Year to you. Isaiah 46:18-19 18 Remember ye not the former things, neither consider the things of old. 19 Behold, I will...

Hiscoming

01-05-2010 04:33 AM
Gerard H. Pille

hpuxrac wrote,on my timestamp of 2/01/2010 12:29 AM: no, for claiming that I wrote it. When clearly - even to you I think - I did not. The ones...

zigzagdna

01-02-2010 12:04 AM
Noons

Hi, I have a situation where I have a materialized view/log to refresh on commit on a fact table that is subject to archive considerations. The fact...

z1hou1

12-29-2009 10:46 AM
joel garry

Hi, There are two identical oracle 9.2 db's running identical software and basically amount of transactions is same - still there's a huge difference...

eh

12-28-2009 01:39 PM
JAW

Hi All, In 10g Oracle introduced view DBA_TAB_STATISTICS. Many columns are identical to those available in DBA_TABLE (NUM_ROWS, LAST_ANALYZED), but...

vsevolod afanassiev

12-27-2009 08:44 PM
Mladen Gogala

How can you make min() throw no_data_found? select min(datex) from tablex where x = 1; With min(), I never get a no_data_found exception.

cate

12-27-2009 04:50 PM
Malcolm Dew-Jones

A new entry: http://multi-platformdba.blogspot.com/2009/12/database-parameters-changes-and-logging.html

JAW

12-27-2009 03:01 PM
JAW

I need your help in a SQL tuning exercise: SQL: ======= select /*+ gather_plan_statistics index(ag,PK_AD_Y) */ count (t.EDIT_STATUS) ,...

Ind-dba

12-25-2009 12:59 PM
Ind-dba

Hi, I am currently auditing "GRANT ANY OBJECT PRIVILEGE" and "GRANT ANY PRIVILEGE". That works well if I grant privileges of other schema objects to...

songyu

12-23-2009 07:26 PM
hpuxrac

Windows release still dragging behind ... that is a change in behavior from last couple of releases. ( Not that we run any oracle databases on...

hpuxrac

12-22-2009 05:53 PM
hpuxrac

how to overcome with this error??? SQL*Plus: Release 8.0.3.0.0 - Production on Tue Dec 22 20:26:57 2009 (c) Copyright 1997 Oracle Corporation. ...

rucha

12-22-2009 12:30 PM
Mladen Gogala

Hi, I have a few doubts on creating Materialized Views (MV). Please clarify them : 1. Can we create MV with rownum as one of the column ? for...

raja

12-22-2009 01:16 AM
raja

I am using Oracle 11g 11.1.0.7 on HP UNIX 11.23. My database has been running in archived log mode. Yet when I go and look in v$archived_log, I see...

zigzagdna

12-21-2009 02:35 PM
ddf

Hi, We need to recover some data from backup. Unfortunately, the application has a job that purges old data. Is there a way to restore from backup...

pradeep

12-21-2009 01:16 PM
pradeep

Hi Friends, I have one insteresting performance issue about 11.2.0.1. Any comments are appreciated. When I use A JOIN B and A JOIN C, the optimizer...

lsllcm

12-21-2009 05:33 AM
Randolf Geist

I've been trying to install Oracle on Solaris 10 (sparc) for the past week without progress. Below is what I get. What baffles me is that, I did not...

Uzoma

12-21-2009 04:26 AM
Alexander Vladimirsky

No hpux no windows so far ... Linux 32 bit and 64 bit ... solaris 64 bit both sparc and x86-64 ... Maybe they even got the 10.2.0.4 patchset out...

hpuxrac

12-20-2009 05:46 PM
John D Groenveld

I want to monitor if system accounts such as system, sys or other DBA accounts did any DML in my application schema. What are the minimal...

zigzagdna

12-20-2009 01:21 AM
Mladen Gogala

On Dec 17, 1:49*pm, Rohit <rohit.misri0... (AT) gmail (DOT) com> wrote: Please don't top post in this group (that means, put your response below...

Rohit

12-19-2009 07:22 PM
Mladen Gogala

I got "operating system" error while I was trying to install Oracle 11g on Windows 7. Please shed a light. Thanks in advance.

keekee

12-18-2009 04:52 PM
hpuxrac

Hi, I have a query about the parameter ADMIN_RESTRICTIONS, what is the value of the parameter if not set explicitly. And apart from listener.ora...

Vijay Soni

12-18-2009 01:49 AM
Vijay Soni

What the heck is: "Service Error: patch:getPatches: Patch Query: <error> in ARU XML"? Fortunately, I went to the HTML version and everything...

Mladen Gogala

12-16-2009 09:30 PM
Noons

Hi all, i have a database with many users like 4_0, 4_1, 4_2, 4_21, 4_22 and so on. I think - if you update the Front-End software from version...

jan

12-16-2009 11:38 AM
joel garry

Hi, i installed a oracle database 10 instance with...

jan

12-16-2009 11:29 AM
joel garry

Hello , I am looking out for some one with Valid UK Visa and exp. with RBAC with Financial skills set. Interested , Pl. do send your resume ASAP.

Hary

12-16-2009 11:00 AM
joel garry

http://www.marketwire.com/press-release/Oracle-Corporation-NASDAQ-ORCL-1090000.html Already made it to slashdot, too. jg -- @home.com is...

joel garry

12-15-2009 09:35 PM
Mladen Gogala