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 Search this Forum
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Good morning. I have a table with a date column. I want to find the next latest date in the data in that table. I have got this far: SELECT...
Chaihana Joe
01-04-2008 03:59 AM
vitalisman@gmail.com Go to last post
1 643
Good day, Whenever a transaction reads a block, it compares its SCN with the transaction's SCN, and based on whether the block's SCN is...
markpapadakis
01-04-2008 03:55 AM
markpapadakis Go to last post
0 119
Using Oracle 9i - Using PL/SQL Is there a command like SQL's show table command that will show all the information for a specific table, like the...
Rosie
01-04-2008 01:02 AM
Mladen Gogala Go to last post
9 112
Is there a way to run a SQL in a RAC instance #1 from instance # 2 ? thanks, i.d.
ibodogan
01-04-2008 12:30 AM
DA Morgan Go to last post
17 168
Poll: How fast is YOUR database in rows per second, on a full bore table scan??? This is for those who like Tom Kyte's work, and empirically get...
dba_222@yahoo.com
01-04-2008 12:27 AM
DA Morgan Go to last post
4 5
Hello all, I am trying to set up Oracle for Dataguard in 10g for a Physical standby and its working correctly. Now I have the following doubt...
maadhuuranjan.m@gmail.com
01-04-2008 12:18 AM
DA Morgan Go to last post
7 99
Hi! SQL> select systimestamp from dual; SYSTIMESTAMP ---------------------------------------------------------- 04-Jan-08 05.40.38.275785 AM...
leo@tech-trans.com
01-03-2008 11:42 PM
leo@tech-trans.com Go to last post
0 96
hi all, i ve been struggeling with this function and i can not see what is the problem. i am using it for getting the following...
Totti
01-03-2008 10:31 PM
Ed Prochak Go to last post
3 97
On Jan 3, 1:04*pm, Walt <walt_ask... (AT) SHOESyahoo (DOT) com> wrote: Thanks!!! I agree with you 100%. I would love to ditch this CMDB vendor,...
DP
01-03-2008 10:22 PM
Ed Prochak Go to last post
7 94
Hi DB Gurus, I have an application which tries to access data from more than one identically structured databases. Each of the databases has the...
saurangshu
01-03-2008 09:05 PM
saurangshu Go to last post
4 94
I have a database, I did level 0 backup using RAMN, let us say it took t1 minutes. Now I deleted lot of data in database using delete staements (as...
zigzagdna@yahoo.com
01-03-2008 07:55 PM
Bob Jones Go to last post
9 103
Hello, Oracle 9i 9.2.0.1.0 on Windows 2003 Server. Client = Omnis Studio on windows xp pro sp2. Being an Omnis developer used to SQL Server 2005,...
Bram Mariën
01-03-2008 03:01 PM
fitzjarrell@cox.net Go to last post
9 95
How can I 'select' all items from a table variable? Actually, I want this syntax to use to create a subquery that I can use to join against. I have...
michael.young@paetec.com
01-03-2008 01:11 PM
sybrandb@hccnet.nl Go to last post
1 109
Dear all, I have an Oracle 8.0.5 in Windows 2000 Server. Please, give me a light, when i execute PROGRAMS-- oracle for windows nt -- Oracle Database...
chijar
01-03-2008 01:01 PM
Maxim Demenko Go to last post
3 90
Upgrading a database from Oracle 9i to 10g. I have encountered a problem with the ODBC 10.1.0.2.0 driver, it transforms the 21 numeric digits from a...
valigula
01-03-2008 12:18 PM
richard.drouillard@gmail.com Go to last post
4 96
Hello, I installed OC4J on RHEL to use as a reporting server together with Apex 3.0. The installation went fine, but I have 1 important problem....
Matthias Hoys
01-03-2008 08:52 AM
Frank van Bortel Go to last post
7 106
Hello, I have tried to autostart an oracle instance by following the instructions...
ton de w
01-03-2008 06:53 AM
Maxim Demenko Go to last post
1 92
Hello! I am traying to upgrade database source : 9.2.0.8.0 destination : 10.2.0.3 with 10.2 Database Upgrade Assittant. At the end when program...
anotnio12
01-03-2008 06:26 AM
Maxim Demenko Go to last post
1 93
Hi All, I need help on database design which can manage many to many relationship between "N" number of tables. for last 2 days i'm thinking over...
steven.p24@googlemail.com
01-02-2008 10:42 PM
DA Morgan Go to last post
2 88
dcruncher4 (AT) aim (DOT) com wrote: No one has said that Bora is a liar. What has been said is that there is more to the story and that is...
Bora Yuret
01-02-2008 10:41 PM
DA Morgan Go to last post
21 200
Hi I want to perform a cartesian outer join with the old plus-sign syntax. So far I've come up with (and it works) SELECT ... FROM A,B WHERE case...
Jaap W. van Dijk
01-02-2008 03:55 PM
Arun Mathur Go to last post
9 91
http://coderbuzz-programming.blogspot.com
raae
01-02-2008 02:35 PM
Ed Prochak Go to last post
14 155
There are two type to write select qurey left or right outer join 1. from table1 left outer join table2 on...
nova1427@gmail.com
01-02-2008 11:55 AM
Robert Klemme Go to last post
11 158
Hi, Does anyone have oracle 10g training slides. Please forward me if there any slides are available. Thank you RA
RA
01-02-2008 10:32 AM
DA Morgan Go to last post
3 103
Hi All, I have been reading about the datapump and came to know about "compression" parameter. As per doc it will compress all the metadata before...
lyxx09@gmail.com
01-02-2008 08:21 AM
robertgfreeman@yahoo.com Go to last post
3 86
Consider the table myTable: first_name varchar2(25), last_name varchar2(25), regNum number, status varchar(20) -> nullable ...
amitabh.mehra@gmail.com
01-02-2008 02:32 AM
Frank van Bortel Go to last post
3 124
Let's face it: the code quality of Oracle 10 is worse then dirt. There are many bugs, for various platforms, some of them extremely critical (wrong...
Mladen Gogala
01-01-2008 06:14 PM
hpuxrac Go to last post
3 96
Hmm, let's see. What is this NG about? Oracle? (Civil war?) I really don't have much to say about Oracle. But let's talk about Larry Page and Sergey...
Ramon F Herrera
01-01-2008 05:48 AM
Ramon F Herrera Go to last post
1 90
Hi, We have a query in one of our stored procedures, which I think may have a logic bug in it given the dta it selects. However, I do not...
amerar@iwc.net
12-31-2007 10:11 PM
Charles Hooper Go to last post
3 88
I have an oracle 10g database in archivelog mode. It runs for a few days generating archive log files and I do a hot backup, a few more days go by...
zipRoberts@gmail.com
12-31-2007 01:17 PM
joel garry Go to last post
5 88
dear all, i connect through svrmgr30 but it shows me an error: ORA-12203: TNS:no se ha podido conectar con el destino SVRMGR> SVRMGR> connect...
chijar
12-31-2007 08:44 AM
fitzjarrell@cox.net Go to last post
13 164
We have an oracle 8.1.0.5 instance over sun solaris, during a hard user deletetion instance crashed, and during startup this is what always...
KCS
12-31-2007 01:24 AM
KCS Go to last post
5 108
Hi, We are using replication concept in our project. It contains different schemas which is location wise created. Data flows vertically in both...
ajaysm85@gmail.com
12-30-2007 11:26 PM
ajaysm85@gmail.com Go to last post
0 98
Dear All, I have problem, Please help. There is table called t: with t as ( select 1 Col1, 1 Col2, 1 Col3 from dual union all select 1, 1, 2 from...
nova1427@gmail.com
12-30-2007 09:31 PM
Charles Hooper Go to last post
3 90
Source: Informix Target: Oracle 10gR2 std Edition / LINUX RHEL AS v.4 Dear all, i have to migrate data from several plain text files...
chijar
12-30-2007 07:26 PM
Fernando Nunes Go to last post
8 99
Hi, We are looking into the possibility of virtualizing a number of our servers with VMWare ESX. This includes some Oracle 10g servers. We know...
Matthias Hoys
12-30-2007 05:00 AM
KCS Go to last post
12 187
Hi all, I have been asked to move an SAP system using an Oracle database from Solaris to AIX (on an IBM P590). Most of the move is straightforward,...
chris.kernaghan@gmail.com
12-29-2007 11:48 PM
maxodyne Go to last post
5 83
Hi, Currently im using 17gb for temp tablespace. Im received a error stating, "cannot allocate temp segment for temp tablespace". I increased the...
calms
12-29-2007 05:51 PM
hpuxrac Go to last post
4 94
Hi, In one of our production database response time of transactions suddenly went down. When we have investigated in awr report it reports high JS...
AshishTheGreat
12-29-2007 05:38 AM
AshishTheGreat Go to last post
0 90
On Dec 26, 5:10 pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote: Hello Dereck, You would have to either rebuild or recreate. ...
Arun Mathur
12-27-2007 08:38 PM
DA Morgan Go to last post
6 102
Does anyone have any experience with EM Agent configuration with Vertias Active/Active clusters? I found Metalink note 406014.1 and it seems to...
tecveg@gmail.com
12-27-2007 06:06 PM
NetComrade Go to last post
1 106
When I enter the credentials in SQL Plus, it hangs. This happens both in the server machine (Oracle 10.2.0) and the clients. But I am able to login...
raghu
12-27-2007 01:02 PM
Frank van Bortel Go to last post
4 127
http://coderbuzz-programming.blogspot.com
lawryy
12-27-2007 12:17 PM
lawryy Go to last post
0 98
http://coderbuzz-programming.blogspot.com
lawryy
12-27-2007 12:16 PM
lawryy Go to last post
0 104
Hi i need to zip a csv inside an oracle procedure. I create this file (120 MB) inside a procedure and i leave it in a shared folder but i need to...
mpacilio2005@gmail.com
12-27-2007 06:00 AM
mpacilio2005@gmail.com Go to last post
2 88
Hi Consider a test table - mytable: id number pk name varchar2(20) not null, addr varchar2(100) not null default 'local' I populated...
amitabh.mehra@gmail.com
12-27-2007 12:34 AM
amitabh.mehra@gmail.com Go to last post
4 101
Merry Christmas Oracle OS specs process 9.2.0.5 aix 5.2 rman archived redo log files backup From time to time there is RMAN-20242:specification...
Massa Batheli
12-26-2007 10:36 AM
fitzjarrell@cox.net Go to last post
1 105
Does anyone have a script that can list all database users and thier privileges Do not want to try to reinvent the wheel if some one out there...
Massa Batheli
12-26-2007 10:20 AM
Massa Batheli Go to last post
3 113
Hi, I want to grant right to a Oracle user by using "grant insert,select,delete,update, on table1 to ABC" generally. However, the owner has more...
leo@tech-trans.com
12-26-2007 10:09 AM
EdStevens Go to last post
2 89
Junction Intl Traders Inc. 3772 Fleet Ave South plainfeild NJ 07080 Ph: 516 707 5000 www.junctiontrader .com PLEASE KEEP US IN YOUR MAILING...
TRADERJUNCTION@gmail.com
12-25-2007 11:54 PM
TRADERJUNCTION@gmail.com Go to last post
0 97
Post New Thread

Display Options
Showing threads 1 to 50 of 17031
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 - 2008, Jelsoft Enterprises Ltd.