a small island in the net
I just had a task to validate rman backup of a production database without actually having to restore it somewhere. Although i prefer to do something like clone the database from backup and see for myself if the instance will actually open and work, there is a way to do simple validation from rman. RMAN allows … Read more
This wait event is connected to heterogeneous services. Whenever we do something on a HS system from our Oracle session, we need to wait for remote system to do it’s work and produce a response. For Oracle it is an idle event as it’s not Oracle who does the work. However it should be remembered … Read more
Here is how to do update of a table that needs to be joined with another table in MySQL, Oracle and SqlServer. Let’s say we want to give a 20% raise to sales department. Microsoft SQL Server: ORACLE: Be careful here to have a primary key set on Department.DepID. Otherwise you get an error ORA-01779 … Read more
Mysql has it pretty simple when it comes to database backup. Using mysqldump tool you can create an sql dump of one, more or all databases on your server. What it does, is writes SQL scripts for every object inside a database (DML, grants, data inserts etc.). Database restore (or cloning) is then done by … Read more