I get the following error when trying to unload a database from Sybase
9 to 11 using the "-an" flag:

***** SQL error: Item 'sa_recompile_views' already exists

I can avoid the error by dumping the unload SQL to a file, commenting
out the following create statement:
"create procedure dbo.sa_recompile_views(in ignore_errors integer
default 0) ....", and loading the SQL file into a new database. The
new database appears to work properly afterward.

Is it safe to ignore this error and comment out this step of the
unload process?

Thanks,

Mike

Yes, removing the "create procedure" statement for sa_recompile_views from the
reload.sql file is a valid fix. Another fix would be to insert a row for
sa_recompile_views with type='P' in the dbo.EXCLUDEOBJECT table of the version 9
database. Somehow that row has been deleted.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Jonesy wrote: