Enable MySQL InnoDB Storage Engine Support in XAMPP Installation
The XAMPP from Apache Friends is a collection of free open source apps that make it easy to [...]
Change Oracle Database User Password
To ensure security of the Oracle database system and prevent unauthorized access to the Oracle database, it's important [...]
Create New Table by Selecting Data from Other Tables with CREATE TABLE AS
By using SQL data manipulation statement, a new, temporary, backup or regular table can be created and filled [...]
ORA-02449 Oracle Drop Table Error
Sometimes when dropping a table in Oracle database by executing DROP TABLE SQL statement, Oracle may return the [...]
IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database
When trying to import an Oracle database export, backup or dump, you may encounter the error IMP-00016 where [...]
Change and Reset MySQL root Password
There are many ways to reset and change the root password for mySQL database, in the event that [...]
Reset the Root Password of MySQL Server
By default, MySQL Server will be installed with root superuser without any password. You can connect to MySQL [...]
Oracle EXP-00091 Error When Export Database
When trying to do a Oracle database dump or export, be it full entire database export or a [...]
View and Retrieve Oracle Database Link Details
In Oracle, database links are named objects that are created in one database which contains detail and instruction [...]
IMP-00013 Oracle Import Error
When trying to import an export dump file that has been exported by a DBA, the following error [...]