how to transfer data from the old confluence h2 to anoter new confluence use oracle database?

Question

My problem is that when i backup the zip form the old confluence ,it is 6G size.

when I whant to import it to the new confluence,it has throw an error below.

Import failed. Check your server logs for more information. com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Confluence Space IA Plugin(com.atlassian.confluence.plugins.confluence-space-ia) #11.0.10 (table AO_187CCC_SIDEBAR_LINK):Error executing update for SQL statement 'CREATE SEQUENCE "AO_187CCC_SIDEBAR_LINK_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1'

I do not know why it throw this question? what should I do ?

I just want to transfer the data from h2 embedded  to oracle database.

please tell me.Thank you.

Sergey Kiselev_lv7gzr · Answer

Faced the same issue. Recreated tablespace as "jiratbs". Recreated user without the option  TEMPORARY TABLESPACE. Seems the problem has gone.

Edwin Kyalangalilwa · Answer

Hi @liudaxia ,

Please confirm that you're following the steps found here:

https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

Most importantly, the versions of Confluence must be the same.

Also, confirm that the Oracle database is configured correctly.

https://confluence.atlassian.com/doc/database-setup-for-oracle-173821.html