Oracle database partition is a division or decomposition of a logical database and/or its constituting elements (indexes or transaction logs) into distinct, smaller, more manageable and independent parts or pieces. Database partitioning provides solution to problems faced by supporting very large tables and indexes, especially in data warehouse applications, which store and analyze large amounts of historical data. With partitioning or table splitting, SQL statements can access and manipulate the partitions rather than entire tables or indexes, and thus increase manageability, performance or availability of the Oracle database.

Continue reading Oracle ORA-14074 Create or Add New Partition Fails Error » » »

Oracle Business Activity Monitoring (Oracle BAM) is a complete and powerful solution for building interactive, real-time dashboards and proactive alerts for monitoring business processes and services based on service-oriented architecture (SOA). Oracle BAM allows users with zero programming skills to build dynamic dashboards of complex enterprise systems, and gives business executives and operation managers the information to make better business decisions and take corrective action if the business environment changes, by providing realtime views of data streams without overburdening solution providers.

Continue reading Oracle Business Activity Monitoring Reviews » » »

XAMPP from Apache Friends is a collection of free open source apps that make it easy to install Apache distribution containing MySQL, PHP and Perl. There are four XAMPP distributions for Windows, Linux, Mac OS X and Solaris. To set up an Apache web server with XAMPP, simply download and extract XAMPP, and the Apache HTTPD web server is ready after one or two more auto-execute scripts. There are no changes to the Windows registry (unless you’re using Widows installer version of XAMPP) and it’s not necessary to edit any configuration files.

Continue reading Enable MySQL InnoDB Storage Engine Support in XAMPP Installation » » »

To ensure security of the Oracle database system and prevent unauthorized access to the Oracle database, it’s important for Oracle users to not only using strong and long Oracle passwords to avoid brute force or dictionary attacks, but also to change the Oracle user password regularly. Oracle users also have to change the password when the password has or going to expire, if database system administrator implements and enforces strict password control with PASSWORD_LIFE_TIME option for user profiles which limits the number of days the password can be used for authentication to login to the system.

Continue reading Change Oracle Database User Password » » »

By using SQL data manipulation statement, a new, temporary, backup or regular table can be created and filled or inserted with data from another table or tables retrieved by SELECT statement. The SQL data manipulation language is CREATE TABLE AS which can be used to create a new table built from contents of result set by a query on a table that already exists within the database. Both the column types, and row data for the new table, come from the SELECT command specified by select.

Continue reading Create New Table by Selecting Data from Other Tables with CREATE TABLE AS » » »

Sometimes when dropping a table in Oracle database by executing DROP TABLE SQL statement, Oracle may return the error ORA-02449 as below:

ORA-02449: unique/primary keys in table referenced by foreign keys

Continue reading ORA-02449 Oracle Drop Table Error » » »

When trying to import an Oracle database export, backup or dump, you may encounter the error IMP-00016 where the import terminate prematurely and not allow you to continue the import to the destination Oracle database. The error has the following message:

Continue reading IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database » » »

Other then the ways specified here to reset and change the root password for mySQL database in the case that the password is forgotten or lost, the following instructions explain in details the alternative way at the last part of the guide, where no additional file needs to be created:

Continue reading Change and Reset MySQL root Password » » »