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     
On Thu, 28 Apr 2011 09:03:54 -0700, joel garry wrote: In the context of this group, I take that the meaning of the word "Allah" is "Larry Ellison"....
Mladen Gogala
05-03-2011 02:22 AM
CarlosAL Go to last post
7 61
Hi All, I meet one corrupt block issue in ASM disk. Below is replicate steps: 1. create tablespace create tablespace...
05-02-2011 09:35 PM
onedbguru Go to last post
5 147
Hi All, I use smartmontools to check disk, and below are some information from smartmontools. The command "smartctl -a" display all information...
05-02-2011 08:56 AM
John Hurley Go to last post
1 97
Hi, I have an application written in .net, I have only the .exe, not the source. It keeps processing data from an external source and inserting on a...
04-30-2011 12:14 PM
Mladen Gogala Go to last post
12 95
On Apr 26, 8:13*am, Carter34Jaime <u... (AT) compgroups (DOT) net/> wrote: And major spam asshole. jg -- @home.com is bogus. http://www.orafarm.com/
04-26-2011 10:35 AM
joel garry Go to last post
11 85
Hi, I am a newbie administrator. Is it safe to alter datafile size while database is open? I need to free up disk space of our database. I found...
04-25-2011 04:57 PM
Dean Go to last post
11 83
I am trying to audit select statements on a column for everyone except JohnDoe who works in the HR dept. How do I create the...
04-23-2011 12:20 PM
BicycleRepairman Go to last post
2 74
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...
04-23-2011 09:09 AM
Gerard H. Pille Go to last post
10 109
Hello out there, last weekend I migrated a database from to vie dbexport/dbimport. Everything runs fine but I found out that...
Lothar Armbrüster
04-22-2011 10:18 AM
Mark D Powell Go to last post
3 57
The documentation (http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/packages.htm) says that "items" declared in the package declaration...
04-22-2011 09:22 AM
Walt Go to last post
4 138
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 05:26 PM
John Hurley Go to last post
7 80
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 04:54 AM
Donatello Settembrino Go to last post
17 102
I am doing some investigation into stale statistics in our database. We are running Oracle Using the sql below it returns several...
04-20-2011 12:30 PM
Randolf Geist Go to last post
3 78
Oracle 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 10:53 AM
joel garry Go to last post
10 115
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...
04-20-2011 10:52 AM
Jeremy Go to last post
2 110
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 06:15 AM
Donatello Settembrino Go to last post
4 92
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 03:45 AM
Hemant K Chitale Go to last post
6 60
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...
04-18-2011 02:28 AM
Marc Blum Go to last post
3 61
here's test code and results from same. SELECT distinct (SELECT count(*) FROM TABLE1)*100/(SELECT count(*) FROM TABLE2) percent FROM TABLE1,...
04-15-2011 02:30 PM
Luuk Go to last post
2 58
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 76
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 58
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 61
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 215
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 92
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 57
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 97
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 54
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 62
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 60
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 98
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 93
Or, never name your next chip after an infamous...
joel garry
03-26-2011 10:25 PM
Noons Go to last post
3 64
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 67
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 97
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 48
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 100
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 68
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 67
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 145
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 53
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 74
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 55
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 48
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 51
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 101
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 47
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 106
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 45
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 42
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 45
Post New Thread

Display Options
Showing threads 601 to 650 of 17918
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 - 2015, Jelsoft Enterprises Ltd.