a small island in the net
Querying tables over database link is very common today. But what happens when we have a table that depends on one or more user defined types? Oracle needs to know the structure of our table and it’s columns when it receives it over the DB link. However, it cannot retrieve that information from remote server … Read more
If you are for some reason moving your database from 32-bit to 64-bit server, a simple copy-paste is not enough. PL/SQL packages are compiled with one word size on 32-bit server and need to be recompiled on 64-bit or the following error might appear: ORA-06553: PLS-801: INTERNAL ERROR [56319]. Metalink note 62290.1 describes in detail … 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