Sunday, December 30, 2012
Oracle Database 12c: Are you ready?
Thursday, December 20, 2012
ORA 1775 looping chain of synonyms
There can be multiple reasons for this error.
1- Through a series of CREATE synonym statements, a synonym was defined that referred
to itself.
1- Through a series of CREATE synonym statements, a synonym was defined that referred
to itself.
Recompiling Invalid Objects
Operations such as upgrades, patches and DDL changes can invalidate schema objects.
These objects are re-validated by on-demand automatic recompilation if they don't have compilation errors. But it may take a significant time, so it is always better to make them compiled before they are called.
These objects are re-validated by on-demand automatic recompilation if they don't have compilation errors. But it may take a significant time, so it is always better to make them compiled before they are called.
Monday, December 17, 2012
Import fails with IMP0098: Checking integrity of dump file
After the export is finished one should always check if the export dump file is corrupted on thesource machine using imp with "show=y". If getting the errors then the file is corrupted on the source machine.
Monday, December 03, 2012
RMAN: Incomplete Recovery from TAPE to Single Instance
Environment: Windows 2008R2 64bit, backup located at Netbackup (Tape media), DB is RAC one with two nodes on ASM.
Saturday, December 01, 2012
Installing TimesTen 11gR2 - Windows
On UNIX, you can install multiple instances of TimesTen. On Windows, you can
install only one instance of any major TimesTen release where a major release is indicated by the first three parts of the release number, such as 11.2.2. For example, you can install both 11.2.1.9.0 and 11.2.2.3.0 on the same Windows computer, but you cannot install both 11.2.2.0.0 and 11.2.2.3.0.
install only one instance of any major TimesTen release where a major release is indicated by the first three parts of the release number, such as 11.2.2. For example, you can install both 11.2.1.9.0 and 11.2.2.3.0 on the same Windows computer, but you cannot install both 11.2.2.0.0 and 11.2.2.3.0.
Oracle TimesTen - Intro
TimesTen - What is it?
TimesTen is a memory-optimized, relational database management system with persistence and recover ability. Unlike traditional disk-optimized relational databases, all data within a TimesTen database is located in physical memory (RAM), which means no disk I/O is required for any data operation.
TimesTen is a memory-optimized, relational database management system with persistence and recover ability. Unlike traditional disk-optimized relational databases, all data within a TimesTen database is located in physical memory (RAM), which means no disk I/O is required for any data operation.
Subscribe to:
Posts (Atom)