Re: HELP HELP HELP

Yass

Many thanks for your reply. I have tried running the SQL below but I think that it will be running for a long time.

If this turns out to be the problem, Is it possible for me to re-create these tables or correct the problem another way?

Yass Khogaly <ykhogaly_at_us.oracle.com> wrote in article <80v2kn$8s5$1_at_inet16.us.oracle.com>...
> REM overlap.sql
> REM
> REM Originally From bug #310481
> REM Please run the following queries to see if segments are overlapping:
> REM
> prompt Overlap on FET$
> select f1.file#, f1.block#, f1.length, f2.block# from fet$ f1, fet$ f2
> where f1.file# = f2.file# and f1.rowid != f2.rowid and
> f1.block# <= f2.block# and f2.block# < f1.block#+f1.length
> ;
>
> prompt Overlap on UET$
> select u1.file#, u1.block#, u1.length, u2.block# from uet$ u1, uet$ u2
> where u1.file# = u2.file# and u1.rowid != u2.rowid and
> u1.block# <= u2.block# and u2.block# < u1.block#+u1.length
> ;
>
> prompt Duplicates
> select u1.file#, u1.block#, u1.length, f2.block# from uet$ u1, fet$ f2
> where u1.file# = f2.file# and
> u1.block# <= f2.block# and f2.block# < u1.block#+u1.length
> ;
>
>
Received on Wed Nov 17 1999 - 17:50:19 CST