Niall Litchfield wrote,on my timestamp of 5/02/2009 2:04 AM:
I'm pretty much out of (cheap) ideas for dealing with thiscorruption right now, so would welcome some.
What is the output of this: select dbms_metadata.get_ddl('TABLE','<table_name>') from dual; Also, some ideas on what to look for and where things are, here: http://dbasrus.blogspot.com/2007_02_01_archive.html HTH -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l