Oracle table partitioning is important for optimum performance of the database, as it allows Oracle to process the specific and independat partition or part that is smaller in size, instead of entire full table or database. However, when you want to create a new partition to a table by adding or splitting partition, administrator may encounter errors such as ORA-14074. Other than that, Oracle error […]
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 […]
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 […]
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 […]
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 […]
On most websites, publishers may prefer to open the links to other web pages, especially external links that open web pages out of their own sites, in a new web browser window or tab, as most of the time, clicking on a link will load the new document from the link in the same window with where the link was. In HTML web programming language, […]
Microsoft Expression Web which previously known as Microsoft Expression Web Designer (still been identified as Expression Web Designer in the beta) and coded-name “Quartz” is a professional web design tool that is in direct competition with Macromedia (Adobe) Dreamweaver and other web development HTML editors. Microsoft Expression Web will also replace Microsoft FrontPage, which is part of Microsoft Office System and has largely been reincarnated […]
XNA Game Studio Express is a game development software that allows students, independent game developers and hobbyists to easily create and develop video games using new and optimized cross-platform gaming libraries for Windows PC and Xbox 360 console. XNA Game Studio Express consists of XNA Framework which is a set of managed code development libraries that make it more productive for developers to create games […]
Java Platform, Standard Edition (Java SE 6) which code-named “Mustang” is the new name and future version for what previously known as J2SE. The new release will be identified as product version 6, and developer version 1.6.0. Java SE 6 has two products delivered under the name of the platform, that’s Java SE Development Kit 6 (JDK 6) and Java SE Runtime Environment 6 (JRE […]
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 […]
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
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:
Tip and Trick