dbTalk Databases Forums  

Sponsored Links


comp.databases.oracle.server comp.databases.oracle.server


Discuss in the comp.databases.oracle.server forum.



Post New Thread
Threads in Forum : comp.databases.oracle.server Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I need to create a composite primary/unique constraint on a table based on a year. It is a competency rating table where each user should only have...
jimmyb
04-23-2011 10:09 AM
Gerard H. Pille Go to last post
10 89
Hello out there, last weekend I migrated a database from 10.2.0.5 to 11.2.0.2 vie dbexport/dbimport. Everything runs fine but I found out that...
Lothar Armbrüster
04-22-2011 11:18 AM
Mark D Powell Go to last post
3 39
The documentation (http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/packages.htm) says that "items" declared in the package declaration...
Walt
04-22-2011 10:22 AM
Walt Go to last post
4 117
I have 3 tables which are always queried together and joined on the same key. The common wisdom tells me that an index cluster is adequate for such...
Mladen Gogala
04-21-2011 06:26 PM
John Hurley Go to last post
7 48
Hi, I'm in charge of a datawarehouse which we update every weekend. That means loading lots of tables with TRUNCATE INSERT /*+ APPEND PARALLEL */...
Jaap W. van Dijk
04-21-2011 05:54 AM
Donatello Settembrino Go to last post
17 77
I am doing some investigation into stale statistics in our database. We are running Oracle 10.2.0.3.0 Using the sql below it returns several...
Mick
04-20-2011 01:30 PM
Randolf Geist Go to last post
3 50
Oracle 10.2.0.4 enterprise windows 2003 I am interested in finding out how much of a table is made up of deleted rows / just to see if there is a...
dba cjb
04-20-2011 11:53 AM
joel garry Go to last post
10 86
Hi this relates to all versions of OHS - though we are currently using the version that comes with 10gR2 on the companion CD. Say we have a pl/sql...
Jeremy
04-20-2011 11:52 AM
Jeremy Go to last post
2 76
Hi, I have this query / subquery that is acting strange. I am trying to get the latest status of a customers Trial subscription and...
The Magnet
04-19-2011 07:15 AM
Donatello Settembrino Go to last post
4 64
Just a question about RMAN. We have the 'include archive logs' clause in our configuration. Problem is sometimes out archive destination location...
The Magnet
04-19-2011 04:45 AM
Hemant K Chitale Go to last post
6 56
Hello, I have a table such as below. Is there a way to limit the range of number so it does not exceed a predefined maximum limit? For instance the...
Wilfrid
04-18-2011 03:28 AM
Marc Blum Go to last post
3 53
here's test code and results from same. SELECT distinct (SELECT count(*) FROM TABLE1)*100/(SELECT count(*) FROM TABLE2) percent FROM TABLE1,...
mj
04-15-2011 03:30 PM
Luuk Go to last post
2 51
A table is filled with a lot of data (about 100.000 entries). Data is processed and rows are deleted until table is empty. Problem: table statistics...
Ceeper
04-12-2011 11:36 AM
Jonathan Lewis Go to last post
5 53
I just rolled back to SQL*Developer 2.11 on my Ubuntu. Version 3 craps out saying that there is no ocijdbc11 in jar path. I don't have that library...
Mladen Gogala
04-11-2011 09:46 PM
John Hurley Go to last post
2 56
Ok, I've read a lot about ASM recently :-) In one of the technical papers from Oracle, they recommend to have only 2 disk groups: one for the data...
mhoys
04-11-2011 09:39 PM
John Hurley Go to last post
8 52
On Apr 6, 11:41*pm, Tuomas <ho... (AT) lut (DOT) fi> wrote: Indeed. With us the net loonies, the Wingtel mob, the *n*x bozzos and the...
mhoys
04-07-2011 09:39 AM
Noons Go to last post
42 175
I have a "top query" that is exhibiting a strange problem. The query looks like this: Select Article# From ( Select a.article# From Articles A,...
Mladen Gogala
04-05-2011 07:58 PM
Mladen Gogala Go to last post
5 54
hi , after refreshing testdb from proddb I'm having an issue We have 100 records in a table in testdb. Sequence=100. 200 records have been copied...
sankarKK
04-02-2011 01:36 PM
Mark D Powell Go to last post
3 49
Ok, there has to be some special incantation here. I have tried both forms of this command and have not bee successful. How does one configure the...
BillPedersen
03-31-2011 09:18 PM
onedbguru Go to last post
15 87
Our situation is like this, we want a system where we can let end user to use it as a report server, browse the source code, etc. And occasionally...
charles
03-30-2011 07:16 PM
onedbguru Go to last post
2 52
Hi, I need help in altering sequence dynamically. the pl/sql program should be able to do 1. select sequence name owned by an user 2. get the...
sankarKK
03-30-2011 10:11 AM
Mark D Powell Go to last post
2 52
Hi gang. I haven't seen this one discussed anywhere and can't really find any references to it that are worth repeating. Does anyone have any...
Noons
03-29-2011 04:47 AM
Noons Go to last post
2 49
On 25 mrt, 10:09, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote: Except the period just before April Fool's, Mladens abuse of the English...
Shahabeddin Hosseinkhah
03-29-2011 04:39 AM
Noons Go to last post
14 82
Hello, Is there a way to rollback schema changes, other than restoring from backup until a specific time or SCN? The database in question is 10g. I...
prunoki
03-28-2011 11:31 AM
mhoys Go to last post
14 81
Or, never name your next chip after an infamous...
joel garry
03-26-2011 11:25 PM
Noons Go to last post
3 49
And I can connect to the database and start the build and a ORASRV_NETV2 process dies with the following: %SYSTEM-F-ACCVIO, access violation, reason...
BillPedersen
03-25-2011 12:22 PM
BillPedersen Go to last post
9 54
Hello I have a particular set of PDF files that cannot be loaded successfully into an Oracle BLOB column. I don't know why that is, and Oracle...
Syltrem
03-25-2011 08:37 AM
Syltrem Go to last post
19 73
I am on Oracle 10.2.0.4 on HP UNIX 11.2. I am running a program which has an infinite loop. Each loop iteration sleeps for 15 seconds, does some...
zigzagdna
03-21-2011 10:40 PM
zigzagdna Go to last post
4 40
Dear all, I came across a question I was not able to answer. I create a VIEW in Oracle 10g like this: -- --------------------------- CREATE OR...
NewUser2008
03-17-2011 07:45 PM
onedbguru Go to last post
14 83
I tried to get the way to get comma seprated values, except listagg or wm_concat. You may have a look on what I tried to get dept wise comma...
Nimish Garg
03-16-2011 11:16 PM
Nimish Garg Go to last post
5 53
Hi, I need to take the elapsed time / response time / query execution time alone of a particular query. For example, if i try to take the response...
raja
03-16-2011 07:56 PM
onedbguru Go to last post
8 54
I know that Oracle 10g can utilize Oracle 11g ASM. Can it also use 11g CRS? I am getting ready to convert my last 9.2.0.8 DB to 11G. Here...
Mladen Gogala
03-14-2011 07:33 PM
onedbguru Go to last post
15 104
Hello, I have XE 10. 2 on linux, 3-4 times a day data gets written into this database, which actually overwrites what was there before.. What I want...
syd_p
03-10-2011 02:50 PM
joel garry Go to last post
7 47
Hi All, Three node cluster on Enterprise 10.2.0.4 SLES 10 64 bit Can anyone tell me why the following may full scan the partition...
Steve Howard
03-09-2011 03:53 PM
Steve Howard Go to last post
6 48
On Mar 8, 2:30*pm, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote: Preston, I am not spamming on this group, as many other r doing with...
Nimish
03-08-2011 12:36 PM
joel garry Go to last post
8 39
Is it more frequent than that? Of course when I actually need to log an SR ( happens rarely usually I am self service ) the system is not exactly...
John Hurley
03-05-2011 04:15 PM
John Hurley Go to last post
2 44
How can I use the departments table ? Should I use the HR,oracle login or with scott,tiger login ? Thanks
happy
03-04-2011 01:13 PM
Mark D Powell Go to last post
1 45
I have a data table like this (Oracle 10.2.0.3.0): SQL> set null '---' SQL> select day, value_a, value_b from x where day>=date'2007-01-01' order by...
yossarian
03-04-2011 03:26 AM
yossarian Go to last post
8 78
Surely using any size sample, even auto, means that the actual rows sampled (ignoring sample size aspect) are different each time so in theory the...
Noons
03-02-2011 03:37 PM
Noons Go to last post
7 36
patch (Multi-page thread 1 2 )
On Mar 2, 1:01*am, "Preston" <dontwant... (AT) nowhere (DOT) invalid> wrote: Of course I disagree (except as to the full text quoting), and...
harry
03-02-2011 12:26 PM
joel garry Go to last post
15 83
Hi Just wanted to know if this was (coneceptually) feasible and supported to get from 10gR2 to 11gR2: - build new 11g database - export from 10g...
Jeremy
03-01-2011 04:28 PM
Jeremy Go to last post
5 42
We have 2 job openings for Oracle DBA's in downtown Chicago. The job description is below. Thank you for your help. Please call me as soon as you can...
Christi L
03-01-2011 12:33 PM
Mark D Powell Go to last post
2 38
Hi, Is there a good way to convert a date to the Unixtimestamp? We need to do this. I used the function below, but our developers are tells us it...
The Magnet
02-28-2011 04:51 AM
Robert Klemme Go to last post
3 42
Hi, We have a query which has a surprising plan. I assume Oracle considered the right plan, but rejected it. Is there any way to tell it that...
Tom Anderson
02-26-2011 05:19 AM
Jonathan Lewis Go to last post
3 39
On 16.02.2011 20:24, Tom Anderson wrote: Well, OR-Mappers are typically not very fast since they tend to handle every single instance individually...
Robert Klemme
02-25-2011 11:57 AM
Tom Anderson Go to last post
6 38
I converted a single instance to RAC manually. I re-created the control file, I added & enabled an additional logfile thread, additional undo space...
Mladen Gogala
02-25-2011 11:48 AM
Mladen Gogala Go to last post
2 38
Hi, Oracle 9.2.0.8 Enterprise (Linux) MySQL (Windows) Could anyone provide me with a solution(s) to export/migrate schemas from Oracle to...
trub3101
02-23-2011 10:29 PM
Steve Howard Go to last post
6 35
All, I hope this is not too vague of a question, but let me know if better clarification is needed. I am going to be replacing a...
seanD
02-23-2011 09:26 AM
Mark D Powell Go to last post
3 33
Dear All, Let me know if you have anyone available for the below position, please send resumes with rate, location and contact details: Job Title:...
Isaac
02-21-2011 01:02 PM
Mladen Gogala Go to last post
1 33
Oracle 11.1.? on Linux We are using partitioned tables, partitioning by interval, so partitions are automatically created as we need them. Part of...
Adrian
02-20-2011 05:06 PM
John Hurley Go to last post
5 35
Post New Thread

Display Options
Showing threads 601 to 650 of 17912
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.