Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue after DBMS_REPAIR

smeeOct 1 2013 — edited Oct 2 2013

Hi all,

I have encountered ORA-01578: ORACLE data block corrupted issue with one of tables in my database. Database version is Oracle 10.2.0.4 on Windows Server 2003. After I solved this problem by using document Using DBMS_REPAIR to Repair Data Block Corruption, I found that I'm unable to insert new data into table. Select and update work fine, but insert does not. When I try to insert new record I get ORA-01578 error again.

Do someone have idea how this happened?

Tnx,

Smee

Comments

Timo Hahn

User, tell us your exact JDev version, please!

In the EO or VO you select the attribute, then select the U-Hint tab and set 'Simple Date' as format type, then you can enter your pattern as 'yyyy/MM/dd hh:mm:ss' into the format field:

pastedImage_0.png

In the UI you get

pastedImage_1.png

Timo

Dimitar Dimitrov

Just a small correction - he asked for HH24:MI:SS, so 'hh' in the Java format mask must me either 'HH' (for hour in day 00-23) or 'kk' (for hour in day 01-24). Also he asked for MM/DD/YYYY, so Java format mask must be 'MM/dd/yyyy':

MM/dd/yyyy HH:mm:ss

MM/dd/yyyy kk:mm:ss

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 30 2013
Added on Oct 1 2013
8 comments
774 views