| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi All,
I use smartmontools to check disk, and below are some information from
smartmontools. The command "smartctl -a" display all information...
lsllcm
|
05-02-2011 09:56 AM
John Hurley  | 1 | 2 |
| | | 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...
Tiago
|
04-30-2011 01:14 PM
Mladen Gogala | 12 | 13 |
| | | 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/
Francogrex
|
04-26-2011 11:35 AM
joel garry | 11 | 12 |
| | | 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...
Dean
|
04-25-2011 05:57 PM
Dean | 11 | 12 |
| | | 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...
indytoatl
|
04-23-2011 01:20 PM
BicycleRepairman | 2 | 3 |
| | | 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 | 10 | 11 |
| | | 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 | 3 | 4 |
| | | 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 | 4 | 5 |
| | | 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 | 7 | 8 |
 | | 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 | 17 | 18 |
| | | 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 | 3 | 4 |
| | | 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 | 10 | 11 |
| | | 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 | 2 | 3 |
| | | 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 | 4 | 5 |
| | | 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 | 6 | 7 |
| | | 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 | 3 | 4 |
| | | 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 | 2 | 3 |
| | | This is a command line tool, if you want GUI tool, it's not good for
you.
D:\>ora2mysql user1=scott/tiger...
AnySQL
|
04-12-2011 09:19 PM
AnySQL | 0 | 1 |
| | | 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 | 5 | 6 |
| | | 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 | 2 | 3 |
| | | 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 | 8 | 9 |
| | | 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 | 42 | 43 |
| | | 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 | 5 | 6 |
| | | 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 | 3 | 4 |
| | | Matthias Hoys schreef:
Is it? Maybe they've fixed some bugs first.
Gerard H. Pille
|
04-02-2011 03:43 AM
Gerard H. Pille | 0 | 1 |
| | | 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 | 15 | 16 |
| | | 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 | 2 | 3 |
| | | 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 | 2 | 3 |
| | | 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 | 2 | 3 |
| | | 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 | 14 | 15 |
| | | 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 | 14 | 15 |
| | | Or, never name your next chip after an infamous...
joel garry
|
03-26-2011 11:25 PM
Noons | 3 | 4 |
| | | 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 | 9 | 10 |
| | | 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 | 19 | 20 |
| | | 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 | 4 | 5 |
| | | 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 | 14 | 15 |
| | | 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 | 5 | 6 |
| | | 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 | 8 | 9 |
| | | 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 | 15 | 16 |
| | | 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 | 7 | 8 |
| | | 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 | 6 | 7 |
| | | 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 | 8 | 9 |
| | | 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 | 2 | 3 |
| | | VTD-XML 2.10 is now released in Java, C#, C and C++. It can be
downloaded...
dontcare
|
03-04-2011 11:41 PM
dontcare | 0 | 1 |
| | | 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 | 1 | 2 |
| | | 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 | 8 | 9 |
| | | 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 | 7 | 8 |
| | | 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 | 15 | 16 |
| | | 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 | 5 | 6 |
| | | 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 | 2 | 3 |
