| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | 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  | 2 | 37 |
| | | 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 | 2 | 30 |
| | | 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 | 14 | 50 |
| | | 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 | 14 | 53 |
| | | Or, never name your next chip after an infamous...
joel garry
|
03-26-2011 10:25 PM
Noons | 3 | 35 |
| | | 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 | 9 | 33 |
 | | 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 | 19 | 43 |
| | | 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 | 4 | 30 |
| | | 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 | 14 | 57 |
| | | 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 | 5 | 34 |
| | | 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 | 8 | 29 |
| | | 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 | 15 | 50 |
| | | 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 | 7 | 25 |
| | | 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 | 6 | 33 |
| | | 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 | 8 | 26 |
| | | 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 | 2 | 28 |
| | | VTD-XML 2.10 is now released in Java, C#, C and C++. It can be
downloaded...
dontcare
|
03-04-2011 10:41 PM
dontcare | 0 | 33 |
| | | 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 | 1 | 27 |
| | | 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 | 8 | 28 |
| | | 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 | 7 | 23 |
| | | 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 | 15 | 45 |
| | | 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 | 5 | 28 |
| | | 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 | 2 | 23 |
| | | 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 | 3 | 26 |
| | | International Business Intelligence (BI) software vendor, Yellowfin,
has confirmed its place as a leader in Mobile BI, blitzing Howard
Dresner’s...
JTP PR
|
02-27-2011 05:30 AM
JTP PR | 0 | 26 |
| | | 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 | 3 | 23 |
| | | 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 | 6 | 24 |
| | | 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 | 2 | 23 |
| | | Hi,
i have a strange effect, since we added a select ... from ... start
with ... connect by ... SQL stmt.
Oracle doesn't tune anymore for parallel...
Frank Bergemann
|
02-24-2011 01:14 AM
Frank Bergemann | 0 | 25 |
| | | 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 | 6 | 25 |
| | | 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 | 3 | 22 |
| | | 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 | 1 | 24 |
| | | 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 | 5 | 22 |
| | | 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 | 6 | 22 |
| | | 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 | 11 | 33 |
| | | 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 | 2 | 30 |
| | | The paper discuses the ability of an Agile BI rollout to respond to
changing data analysis and reporting needs, and provide vital insights
into an...
JTP PR
|
02-16-2011 08:51 PM
JTP PR | 0 | 25 |
| | | 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 | 5 | 25 |
| | | 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 | 3 | 26 |
| | | 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 | 65 | 95 |
| | | Hi all, I have recently installed Oracle on OSX Snow leapard. (10.6.6)
and can not get netmgr running for the life of me. I know that there
was...
Aaron Spiteri
|
02-15-2011 06:17 AM
Aaron Spiteri | 0 | 28 |
| | | 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 | 6 | 21 |
| | | 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 | 16 | 43 |
| | | 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 | 2 | 23 |
| | | 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 | 3 | 21 |
| | | 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 | 7 | 24 |
| | | ( 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 | 4 | 27 |
| | | 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 | 5 | 28 |
| | | This paper has defined Social and Collaborative BI as the merging of
BI with social networking and Web 2.0 technologies.
Direct Link (No Email...
JTP PR
|
02-06-2011 05:16 PM
JTP PR | 0 | 27 |
| | | 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 | 1 | 29 |
