Jacob Martin, Author at Oracle Database File Repair Tool
Published by Jacob Martin on September 11, 2015
While creating linked server to Oracle database you might get ORA-12154 error. It is a common error and you may encounter it quite often. And you would get the following the error message on the screen.
Published by Jacob Martin on July 31, 2015
You might have acme across “ORA-01843: not a valid month” error but do you know you can easily fix them. This error is very common for Oracle SQL developers and if you have find this error then this article is right for you it will help you to solve it.
Published by Jacob Martin on June 18, 2015
To solve oracle issue, one must keep in mind that each and every technique must be tested, as it improves the performance in one area, while it may degrade the performance of another area. For Example: Adding an index improves the performance of Query, but the performance of delete and inserts becomes slower, as the […]
Published by Jacob Martin on April 25, 2015
Oracle is a Relational Database Management System from the Oracle Corporation. It is one of the best trusted and is widely used base relational database systems.
Published by Jacob Martin on April 2, 2015
Oracle is a Relational Database Management System from the oracle corporation. This is one of the trusted and widely used base relational database systems. This system is built in a way that data objects can be directly accessed by users through structured query language. Oracle is fully scalable relational database architecture which is used by […]
Published by Jacob Martin on March 7, 2015
If you are an Oracle database user then you very well familiar with the ORA-00904: invalid identifier error. It doesn’t matter which version you are using10g, 11g or 12g, this is one of the most common error comes while doing CRUD (Create, Read, Update, and Delete) operations in Oracle. SELECT, INSERT, UPDATE and DELETE are […]
Published by Jacob Martin on January 12, 2015
As a DBA you may receive requests by the users and even the developers of some deleted data of small table from the large database. Thus they want you to recover those data as soon as possible which would be a critical production of database. Moreover the Flashback and the recycle bin would likely be […]
Published by Jacob Martin on November 17, 2014
There are times where we have noticed that operating system does not respond or work due to something miss happening or miss handled with the system and system have crucial data which you do not want to lose at any cost and you do not have backup for it. So, in this blog you will […]
Published by Jacob Martin on October 20, 2014
Almost every database stores important and sensitive data of enterprises. Therefore it is important to protect and secure database from any disaster or attackers. Likewise, if you are storing sensitive, personal or confidential data in your Oracle database, then you must know how to keep your data secure that is stored in Oracle database. So, […]
Published by Jacob Martin on October 11, 2014
Oracle database store the data in different levels, including blocks, table space, segments, etc. Before the database allows you to access data, the entire database objects required to be mounted properly. However, if the database gets corrupted or damaged, then it fails to mount properly and the entire data stored in database becomes inaccessible. The […]
