Subject Re: Change owner or pump data to new DB
Author ainpoissee
--- In, "Alan McDonald" <alan@...> wrote:
> if yo backup as SYSDBA, you can restore as the original OWNER. Have you
> created more objects as SYSDBA since the restore?

Yes, I tried that and got error too. I now did it again to copy the excact error messge and noticed that error says "Cannot restore over current database,..." so problem solved - just had to delete the existing DB before restore. Should pay more attention to the error messages :)

> Clever Components has a datapump

Thats what I wanted to use - it's name is InterBase Datapump. Wery good tool to pump data but it seems not to work with 2.1?