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     
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 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...
BillPedersen
03-31-2011 08:18 PM
onedbguru Go to last post
15 84
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 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...
sankarKK
03-30-2011 09:11 AM
Mark D Powell Go to last post
2 51
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 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 76
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 10:31 AM
mhoys Go to last post
14 80
Or, never name your next chip after an infamous...
joel garry
03-26-2011 10:25 PM
Noons Go to last post
3 47
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 11:22 AM
BillPedersen Go to last post
9 52
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 07:37 AM
Syltrem Go to last post
19 71
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 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...
NewUser2008
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...
raja
03-16-2011 06:56 PM
onedbguru Go to last post
8 51
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 06:33 PM
onedbguru Go to last post
15 96
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 01:50 PM
joel garry Go to last post
7 42
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 02:53 PM
Steve Howard Go to last post
6 47
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 11:36 AM
joel garry Go to last post
8 37
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
happy
03-04-2011 12:13 PM
Mark D Powell Go to last post
1 44
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 02:26 AM
yossarian Go to last post
8 49
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 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...
harry
03-02-2011 11:26 AM
joel garry Go to last post
15 76
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 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 41
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 37
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 37
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 37
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 09:29 PM
Steve Howard Go to last post
6 33
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 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:...
Isaac
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...
Adrian
02-20-2011 04:06 PM
John Hurley Go to last post
5 34
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 11.2.0.2 (rac and non-rac) yet and would you say it is better or worse that 11.2.0.1+NovPSU??
onedbguru
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 32
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 183
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 10.2.0.4 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...
Jeremy
02-10-2011 09:21 AM
Jeremy Go to last post
3 25
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
Hi This is on 10gR2 / 11gR2 We have a simple "hello world" type java proc in the database which we can access via a pl/sql wrapper - works...
Jeremy
02-07-2011 04:30 PM
Thomas Olszewicki Go to last post
5 33
Have a load of this: http://it.toolbox.com/blogs/database-soup/why-postgresql-doesnt-have- query-hints-44121?rss=1 This is just phenomenal! The...
Mladen Gogala
02-05-2011 06:15 AM
Noons Go to last post
1 34
Dear group, We are moving our Oracle database on redhat 4 10.2.0.4 to redhat 5 and upgrade it to 10.2.0.5 so, on server A(redhat 4), i took a hot...
charles
02-04-2011 10:12 PM
bdbafh Go to last post
6 37
Hi, The following code will stop working if I remove the (xmlns=""). As I don't control the web-service that generates the XML (and omits the null...
Richard Maher
02-04-2011 04:27 PM
Richard Maher Go to last post
5 46
http://www.oracleobserver.com/?q=node/28 seems to have an unnecessary use of dual, or am I missing something? It seems to work fine for me without...
joel garry
01-31-2011 07:35 PM
John Hurley Go to last post
15 50
Post New Thread

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