I need to extract DDL from oracle 8i database for materialize view(snapshot). I don't have any tool now. dba_source don't have materialized view. Any other dictionary view/packages I can use to get DDL?
By the way, I used exp/imp I got errors. exp/imp is 10g to 10g
IMP-00003: ORACLE error 1722 encountered
ORA-01722: invalid number
Thanks.