Query user defined types over database link

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 moreQuery user defined types over database link

Moving between 32-bit and 64-bit server

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 moreMoving between 32-bit and 64-bit server