Is there another way to move pages from space to space if the 'Move' command fails with a database error?

[Deleted user]

We have a bunch of pages (about 100) in a space and want to move them in 'one step' to another spaceAttempt to move starts and copies a lot of pages, but ends up in a database error and afterwards the pages still exist in the old space.

Is the a sql query in that allows to change the space key in the database for the pages that does the move?

[Nic Brough -Adaptavist-]

No.  

You need to investigate and fix the error that occurs during the attempt to move the pages.  SQL is a last resort to fixing data, and ignoring the underlying error is asking for trouble as it could be breaking all sorts of other things as well as move.