Re: Errors with Information_Schema in Create Target Results
Posted by: Vaughan Wickham
Date: October 29, 2021 04:57PM

Hello Peter,

I have backed up all the databases separately

And I have attempted to restore one of the smaller databases

I get these errors towards the end of the restore
Warning (Code 3135): 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
Warning (Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.

How do I figure out which query is responsible in the source sql file

I tried doing a search on ZERO

I found this entry
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

But I'm not sure if this is relevant or not

Options: ReplyQuote


Subject
Written By
Posted
Re: Errors with Information_Schema in Create Target Results
October 29, 2021 04:57PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.