I am using 10g lite. I installed it and did a search for tnasnames. I did not find tnsnames.org on the C-Drive. What to I need to do. The reason I...

Rich

10-14-2009 11:28 AM
gazzag

Hi there I'm working on a machine with the following OS configuration: Windows 2008 Server (R) 64bits Standard without Hyper-V, Service Pack 2 I...

Giulio Petrucci

10-13-2009 09:35 AM
Philipp Stiefel

Hi all, I have a table that has about 8 million rows and I'd like to be able to find the space used by the table. Is there a quick and easy way of...

Sashi

10-08-2009 01:11 PM
joel garry

I used IE to open Oracle Enterprise Manager, last week it is fine. But today I try again (https://localhost/em/console/logon/logon) it...

JYan

10-08-2009 03:59 AM
JYan

Hi, after migrating to Ora11 and some new synonym definitions etc. I've a lot of invalid views. I can see them with this select SELECT...

Norbert Winkler

10-07-2009 12:13 PM
Michel Cadot

Hi, Is there any way to tell RMAN to look in 2 places when you 'include archivelogs' in your backup? Say that the archive log destination fills up...

The Magnet

10-06-2009 10:21 AM
gazzag

Dear All I need to know that can we schedule archived log to be deleted automatically for instance i want to delete one month archived log from...

tanveer

10-04-2009 03:39 PM
joel garry

I've looked in Oracle PL/SQL 3rd Edition and searched psoug.org but I was unable to determine: CURSOR foo (vbar varchar2) IS select * from table_t...

kes

10-02-2009 12:20 PM
Shakespeare

Hi all, I am trying to load the data from a csv file to database. my data is: "aaaa","dd\"d" "hhh","jbbb" I want it in databse as

rita

10-01-2009 05:00 AM
Ed Prochak

HI all, I'm trying to use the collect() function (mentioned in my earlier post in this ng) but it, well, collects all values. Is there any way of...

Sashi

09-29-2009 11:35 AM
Michel Cadot

how does oracle do it, if it does that without buying advanced compression? Thanks Suri

RNBJ

09-29-2009 09:29 AM
Mark D Powell

Hi all, I'm running a simple select stmt thus: select A.value, b.value from A, B where ... However, either A.value or B.value is null and I need...

Sashi

09-28-2009 11:03 PM
Sashi

I've been searching around and I'd like to know if anyone can recommend a decent tool to generate a Database Schema Diagram from an Oracle DB. I have...

Spiff McClure

09-26-2009 01:15 PM
Gerard H. Pille

Thanks in advance for any clues! I'm trying to edit an existing stored procedure in Oracle and need to know how to code using SUM in...

Brock

09-25-2009 04:48 AM
Tim X

Hi all, We need to track work items across several existing applications. Items can start as a document on disk, can be renamed or moved, converted...

PJ

09-25-2009 02:56 AM
PJ

For a research project, I search for some statistics for the TPC-C benchmark. Are the following already available somewhere in the...

jbdhl

09-24-2009 05:55 AM
jbdhl

Hi all, I'm looking for an aggregation function that can join collections to a new collection. I found nothing like this. An example: DDL: CREATE...

Björn Wächter

09-23-2009 01:52 PM
Michel Cadot

I am constructing a regular expression to check the validity of an Oracle table name. What characters are valid? TIA, -Ramon

Ramon F Herrera

09-22-2009 09:55 AM
Shakespeare

I am trying to duplicate a database, but before i do it - I want to make sure the init.ora I copied from production is changed to include a new...

Michael

09-22-2009 09:32 AM
Mark D Powell

Hi, Oracle EM indicates I have a lot of duplicate SQL which would be better parameterized. The DB user I connect as has no read access to the tables...

Martin

09-22-2009 09:09 AM
bohica

I have been using Pro*C/C++ for a while, but so far all my programs have been written in C. I just started trying to run some C++ programs, the ones...

Ramon F Herrera

09-21-2009 12:28 PM
Paulie

We have 5 redo logs each of 150M in size and there are 2 members in each group. We have been constantly getting the following...

Michael

09-21-2009 10:23 AM
Mark D Powell

All, I'm relatively new to query optimization so I could use some help or pointers in the right direction. My query is pretty simple: just update a...

Sashi

09-21-2009 10:09 AM
Sashi

Hello, You are welcome to test a new great tool for Oracle spClientMonitor. spClientMonitor provides Oracle database administrators and...

spviewer

09-20-2009 03:09 PM
spviewer

Hi, I am still working on this one. I have a dynamic statement that looks like this: EXECUTE IMMEDIATE 'SELECT count(*) FROM customers_lookup...

The Magnet

09-20-2009 02:47 PM
The Magnet

Hello everyone, I was wondering if someone might have a suggestion on what would be the best approach to derive period balances from YTD...

mpal

09-18-2009 12:25 PM
mpal

This is actually proving harder to find than I originally thought. In PLSDQL, can't I have some CASE statement like this. I want to use an OR in...

The Magnet

09-17-2009 02:22 PM
Michel Cadot

Hi All, I'm looking to concatenate multiple values for a single column and am wondering if this is possible. select concat(a1), a2, a3, a4 from...

Sashi

09-15-2009 06:26 PM
Sashi

I am receiving the following message in my alert log and can find no documentation explaining what this error means or how to correct...

Michael

09-15-2009 09:55 AM
Mark D Powell

Hi all, I have a list of user records that I need to update once to solve a problem with the application that uses the table. The records in this...

JJ

09-10-2009 12:56 PM
joel garry

YLE A-piste 07.05.2008 aika mieliinpainuvaa tykitystä. Tähän asti ministeri Jan Vapaavuori on yybereimmin vaatinut kaiken taloustoiminnan...

Simo Helenius

09-10-2009 12:19 PM
Simo Helenius

Hi, Probably a nutty question, but, is it possible to find out what program contained the DML which fired the trigger? We have a particular...

The Magnet

09-09-2009 09:19 AM
Mark D Powell

Ok, this one represents a dumb setup by the client. The client has a table which holds which email product(s) his customers get. Call this table...

The Magnet

09-09-2009 01:53 AM
Robert Klemme

This is a continuation of my whining against the relational model. Yes, I realize that it is efficient and its theoretical background is elegant,...

Google Poster

09-04-2009 08:37 PM
Google Poster

I am sure there are versions of this out there. It would be great to educate myself on design of schemas. This can be a great textbook example. What...

Google Poster

09-04-2009 08:06 PM
Google Poster

Hi all, I'm using a standard SQL command but Oracle seems to have a different version. update A,B set a.col1 = 'something' where a.col2>=b.col2 and...

Sashi

09-03-2009 03:06 PM
Terry Dykstra

Hi all, I have a table like this .. Name ID -------- ---- A 1 B 2 C 3 D 4

keeri

09-03-2009 12:54 PM
ddf

I have a table like this : Project Date Hours -------- ----- ------ 01 - Holiday 08/29/2009 08 01 - Holiday...

keeri

09-03-2009 07:26 AM
keeri

Hi all , I have a Table like this .. Project code Date Hours ----------- ------- ...

keeri

09-03-2009 07:21 AM
keeri

I have a situation which (simplified) looks like this: Table UNITS has a PK on UNITS.NAME. (unit name, varchar(12)) Table DEPTS has a PK on...

mh@pixar.com

09-02-2009 01:07 PM
joel garry

All, I'm trying to load data using a control file. Here's the sqlldr version: SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 1 11:43:14...

Sashi

09-01-2009 01:16 PM
Sashi

Can a table contain data arranged in two dimensions, and accessible through a pair of integer subscripts? I can live with 1-dimensional arrays,...

Ramon F Herrera

09-01-2009 02:09 AM
Robert Klemme

Hi, I have a cursor which queries some tables over a DBLINK. The remote database is Oracle 8.1.7.4 and package is being compiled on 10.2.0.3 Since...

Ashish

08-27-2009 03:12 PM
Shakespeare

Hi Everyone, I'm trying to call Oracle functions from a VBA-Application using ADO over ODBC. I've done this a couple of times in previous projects...

Philipp Stiefel

08-26-2009 04:55 AM
Philipp Stiefel

Good morning, in the following query I've a problem with B.ABI_CAPOGRU that is not recognized inside the select max this is probably due to the fact...

Etantonio

08-21-2009 02:02 AM
Peter Nilsson

I have a server program that should run in active/standby mode: - a copy of the program is running on two different computers - only one copy should...

mh@pixar.com

08-20-2009 08:52 PM
mh@pixar.com

Hi! I was wondering if I can select somehow parameters of a function, procedure (inside a package or standalone) other than parsing the dba_source...

slafs

08-18-2009 09:52 AM
Mark D Powell

Hi I am joining three tables a,b,c of which b and c are really large ( 20 million+ records). The join is running and in the mean time I am updating...

Saravanan

08-18-2009 06:15 AM
Tim X

I've created this view: CREATE VIEW latest_b AS SELECT a_id, b_id FROM ( SELECT a.a_id, a.b_id, ROW_NUMBER() OVER ( PARTITION BY a.a_id ORDER BY...

Álvaro G. Vicario

08-17-2009 04:04 AM
Álvaro G. Vicario

Hi, Hopefully this isn't a brain dead question. I've been a DBA for almost 10 years, but my experience has been exclusively with MS SQL. Now...

Sam Alexander

08-15-2009 05:14 PM
Mark D Powell