This error happend when it tries to modify a column definition. To solve this problem just drop and recreate the extended stats. To solve this problem just drop and recreate the extended stats Info obtained from Chris Saxon – Developer Advocate on the following link ORA-54033 and the Hidden Virtual Column Mystery
database
MariaDB using time zones
We are going to explain how to install and use Time zones with MariaDB on Ubuntu. Install on Ubuntu Convert to sql and import to MariaDB Time zone data are in /usr/share/zoneinfo and is found as binaries. To use Time zones with MariaDB we need to convert to sql. Now we have the zoneinfo.sql file […]
How to reset your root password in MariaDB?
1. The first thing to do is to stop MariaDB server 2. Start MariaDB without asking for a password 3. Connect from localhost to your server as root 4. Reload the grant tables 5. Change the root password for a new one So the password has been changed. 6. Stop the manual instance of the […]