<< As I stated before, I have not received this error before. >>
I don't know whether your problem is due to a view-using-view issue, but here's how this problem can suddenly appear: 1. Create view VIEW1. 2. Create view VIEW2 which uses VIEW1. 3.At some point, drop and create VIEW1 with a slight change. Now, if you unload your views, VIEW2's definition will come before VIEW1. If you try to rebuild views from the UNLOAD file, you will experience the error you described and VIEW2 will not be created in the new database (but if you run the UNLOAD file a second time against the same database, it will be). This is because R:Base does not analyze view dependencies when unloading view definitions. Ideally, it would perform a "transitive closure" to ensure that dependent views get unloaded first. -- Larry
