Recent content by roedelfroe

Sorry, wrong forum! Please ignore, I've asked my question in the correct forum again. roedelfroe

Hi, I've written a statement, which works fine but it is rather slow. Does anybody got a better idea? select * from ( select a.*, row_number() over (partition by row1, row2 order by row3 desc) as xxx from TABLE a where DATE <= to_date('01.01.2009'...

Hi, I've written a statement, which works fine but it is rather slow. Does anybody got a better idea? select * from ( select a.*, row_number() over(partition by row1, row2 order by row3 desc) as xxx from TABLE a where DATE <= to_date('01.01.2009', 'DD.MM.YYYY') and...

Quite possible I miss an obvious thing. I have taken a dump from a database with followoing options: compress=n direct=y rows=y indexes=y constraints=y grants=y triggers=y owner=xxx Enable row movement is enabled on every table. Importing the dump works fine, but Enable row movement is gone...

Hello everybody, since our database upgrade from 9i to 10g we have problems with a function. It works fine in 9i, but in 10g we got ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "AB.P_V_NUMBER". Following select is used: SELECT SUBSTR(DS,1,4) AS...

Thank you! That's it. Roland

Hello to everybody. Following problem: Due to a error I got in a table duplicate and illogical entries. It's a table with staff members witch normally should show something like this: Storage_ID valid_from valid_to personnel_number .... 1 2006/07/07 2007/05/31 1234567...

Which version of forms you are using? Regards Roland

Hi vidmin, filesystemio_options = async Regards Roland

Hi Dima, thanks for your tips. I have changed the parameters you mentioned (Parameters were set on default, good guess from you :-)) but the database is still performing like... (words are missing). Tomorrow, a DBA-Guru from an other departement will try to help me. Maybe he is able to help...

Hi jadexy, it would be nice, if you post your questions in ONE Forum only. Don't be impatient, a lot of Members are living and working in the US and they are several hours behind your time (guess you are located in Germany or Austria, aren't you?). Regards Roland

Hi, your first update was working fine, because your subselect returns exactly one result for each row. Your other update tries don't work, because your subselect is returning more the one result with Oracle just saying "Hey, and which of this result is the one you want???". So, it would be...

Table test1 ID Value 1 100 2 150 3 175 4 200 Table test2 ID Value 1 400 2 300 3 700 4 800 select t1.id, t1.value value1,t2.value value2,t1.value + t2.value valueadd from test1 t1, test2 t2 where t1.id=t2.id; ID value1 value2 valueadd 1...

Hi Prosuc, the latest available Patch ist Patch Set 17, which is reliable and stable. You will need at least Patch Set 6, if you want to compile Forms against a Database 10g Database and at least Patch Set 13, if you want Oracle Forms running on Windows XP. As mentioned by lewsip, your...

Hi, some weeks ago we upgraded our Oracle Database from Version 8i to 10g (10.1.0.3.0). To do so, we used the migration tools from Oracle Since then we are experiencing a poor performance of our database. e.g. we've got one big table with 128 Billion entries. A "normal" query under Oracle 8i...