Oracle database restrictions and workarounds at daily DBA work

Oracle introduces hundreds of new database features in every database release. At the same time some tiny small restrictions in the code exist for a long time that bother database developers and DBAs at their daily work. Below I explore some of the common Oracle restrictions I often encounter during database administration. I give the workarounds for most of them and compare some with Microsoft SQL Server implementations. Read more »

How to make exp utility work on Oracle 11gR2

The fact that Oracle Data Pump does not work from a client installation only still forces many developers and DBAs to work with old Export (exp) and Import (imp) utilities. In spite of Original Export being unsupported  for general use as of Oracle database 11g, in reality it’s still available and can be used. However, there are a few issues with exp utility on Oracle database 11gR2 that have to be fixed before using it. Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email