we had corrupted one datafile and now the DB could not be open, but
can be
mount. Unfortunately, we are running our DB in NOARCHIVE mode and we
don't have a backup

On Oracle 10G, lets say I have a table that looks like this:
create table t1 (key varchar2(10), start_dtm date, end_dtm date);
and I have data some of which over laps:
insert into t1 values ('1234', to_date('01/01/2001', 'DD/MM/YYYY'),

Hello DBAs,
I'm running Oracle 9.2.0.8 on CentOS Linux 4.6 (which is same as RHEL
4.6).
Since yesterday I'm unable to startup a "BOCHUM" database:

I have the following query against the table
create table employees (
 id number,
 manager_id number,