Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by roedelfroe

  1. roedelfroe

    Over Partition by

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

    over partition by

    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'...
  3. roedelfroe

    Over Partition by

    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...
  4. roedelfroe

    Option 'enable row movement' not included in Dump

    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...
  5. roedelfroe

    to_number conversion error

    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...
  6. roedelfroe

    Finding duplicate and illogical entries

    Thank you! That's it. Roland
  7. roedelfroe

    Finding duplicate and illogical entries

    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...
  8. roedelfroe

    Making Runtime ( EXE ) file of a Devloper Application

    Which version of forms you are using? Regards Roland
  9. roedelfroe

    Poor Performance of DB after migranting to 10g

    Hi vidmin, filesystemio_options = async Regards Roland
  10. roedelfroe

    Poor Performance of DB after migranting to 10g

    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...
  11. roedelfroe

    SQL update Problem

    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
  12. roedelfroe

    SQL update problem

    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...
  13. roedelfroe

    calculate sum

    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...
  14. roedelfroe

    How can I know what patch I have installed?

    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...
  15. roedelfroe

    Poor Performance of DB after migranting to 10g

    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...
See more

Part and Inventory Search

Back
Top