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     
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...
04-12-2011 10:36 AM
Jonathan Lewis Go to last post
5 49
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 08: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...
04-11-2011 08: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...
04-07-2011 08:39 AM
Noons Go to last post
42 174
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 06:58 PM
Mladen Gogala Go to last post
5 49
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...
04-02-2011 12:36 PM
Mark D Powell Go to last post
3 48
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...
03-31-2011 08:18 PM
onedbguru Go to last post
15 86
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...
03-30-2011 06: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...
03-30-2011 09: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...
03-29-2011 03:47 AM
Noons Go to last post
2 47
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 03:39 AM
Noons Go to last post
14 80
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...
03-28-2011 10:31 AM
mhoys Go to last post
14 81
Or, never name your next chip after an infamous...
joel garry
03-26-2011 10:25 PM
Noons Go to last post
3 48
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...
03-25-2011 11:22 AM
BillPedersen Go to last post
9 53
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...
03-25-2011 07:37 AM
Syltrem Go to last post
19 71
I am on Oracle on HP UNIX 11.2. I am running a program which has an infinite loop. Each loop iteration sleeps for 15 seconds, does some...
03-21-2011 09: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...
03-17-2011 06: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 10:16 PM
Nimish Garg Go to last post
5 51
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...
03-16-2011 06:56 PM
onedbguru Go to last post
8 52
I know that Oracle 10g can utilize Oracle 11g ASM. Can it also use 11g CRS? I am getting ready to convert my last DB to 11G. Here...
Mladen Gogala
03-14-2011 06:33 PM
onedbguru Go to last post
15 101
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...
03-10-2011 01:50 PM
joel garry Go to last post
7 47
Hi All, Three node cluster on Enterprise SLES 10 64 bit Can anyone tell me why the following may full scan the partition...
Steve Howard
03-09-2011 02: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...
03-08-2011 11:36 AM
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 03:15 PM
John Hurley Go to last post
2 43
How can I use the departments table ? Should I use the HR,oracle login or with scott,tiger login ? Thanks
03-04-2011 12:13 PM
Mark D Powell Go to last post
1 45
I have a data table like this (Oracle SQL> set null '---' SQL> select day, value_a, value_b from x where day>=date'2007-01-01' order by...
03-04-2011 02:26 AM
yossarian Go to last post
8 63
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...
03-02-2011 02: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...
03-02-2011 11:26 AM
joel garry Go to last post
15 80
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...
03-01-2011 03: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 11:33 AM
Mark D Powell Go to last post
2 34
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 03: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 04:19 AM
Jonathan Lewis Go to last post
3 38
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 10: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 10:48 AM
Mladen Gogala Go to last post
2 38
Hi, Oracle Enterprise (Linux) MySQL (Windows) Could anyone provide me with a solution(s) to export/migrate schemas from Oracle to...
02-23-2011 09:29 PM
Steve Howard Go to last post
6 34
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...
02-23-2011 08:26 AM
Mark D Powell Go to last post
3 32
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:...
02-21-2011 12: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...
02-20-2011 04:06 PM
John Hurley Go to last post
5 35
I was comparing 2 SQL statements which produce the same result. Here are the statements: with e(empno,mgr,lev) as ( select empno,mgr,1 from emp...
Mladen Gogala
02-19-2011 12:52 PM
Randolf Geist Go to last post
6 29
Just got a call from some Oracle customer rep with a difficult Indian accent, telling me support prices will increase 10% for those who don't upgrade...
joel garry
02-18-2011 05:33 PM
John Hurley Go to last post
11 49
Has anyone upgraded to (rac and non-rac) yet and would you say it is better or worse that
02-17-2011 11:29 AM
John Hurley Go to last post
2 36
i have a problem for "before insert or update" trigger. Currently this trigger records old table X record in dedicated X_HIST table (same structure...
Frank Bergemann
02-16-2011 11:19 AM
joel garry Go to last post
5 33
Looks like OEL 5.6 just became available last month ... http://oss.oracle.com/el5/docs/RELEASE-NOTES-U6-en.html
John Hurley
02-16-2011 08:25 AM
John Hurley Go to last post
3 34
I invested quite some time in learning the thing, as it seemed very similar to Oracle. Unfortunately, when it came down to the pilot project, the...
Mladen Gogala
02-15-2011 02:21 PM
Mladen Gogala Go to last post
65 184
Hello out there, I tried to configure alerts for full tablespaces using dbms_server_alert.set_threshold. Since we do not have licensed diagnostics...
Lothar Armbrüster
02-12-2011 01:10 PM
onedbguru Go to last post
6 25
I've only just come across this possible SQL bug and was wondering why this SQL returns a result? I got it through an email and had to change it to...
DG problem
02-11-2011 06:46 PM
Noons Go to last post
16 57
oracle enterprise windows 2003 service pack 2 1) Code we use is driven by concept of list of stale objects at table level eg...
dba cjb
02-10-2011 07:22 PM
onedbguru Go to last post
2 26
Hi I figured that you need people like me to ask questions in cdos to keep it going ;) I am trying to help a colleague work out why something...
02-10-2011 09:21 AM
Jeremy Go to last post
3 26
On Wed, 09 Feb 2011 09:54:09 -0800, ddf wrote: David, V$SORT_USAGE and V_$SORT_USAGE are synonyms. QL> select table_owner,table_name from...
dba cjb
02-09-2011 12:49 PM
Mladen Gogala Go to last post
7 30
( Sorry a repeat of blog posting ... ) I get grumpy when I see negative serial#'s in v $session_connect_info ... this is almost enough to make a...
John Hurley
02-08-2011 01:41 PM
John Hurley Go to last post
4 33
Post New Thread

Display Options
Showing threads 601 to 650 of 17900
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.