Home

The SYSTEM tablespace is created with manual segment allocation and as such it is not possible to run the SHRINK command for the objects that are located within. However, if the AUD$ table is moved to another tablespace (locally managed with automatic segment space management) then it can be shrunk. It is recommended to use…

Example –  Deleting a Database In this example, you want to delete a test database called test1 that is registered in the recovery catalog. You start the RMAN client, connect to database test1 as TARGET, and connect to the recovery catalog. You then run the following commands to delete the target database files, as well as…

ORA-29516: Aurora assertion failure: Assertion failure From Oracle 11g release 1 (11.1), Oracle introduces just-in-time(JIT) compiler for Oracle JVM environment, which results in faster execution because invalidation, recompilation, and storage of code is done dynamically. JIT is controlled by parameter java_jit_enabled, and if it is set to TRUE then the Java methods are automatically compiled…

A profile is a named set of the following password and resource limits: a.. Password aging and expirationb.. Password historyc.. Password complexity verificationd.. Account lockinge.. CPU timef.. Input/output (I/O) operationsg.. Idle timeh.. Connect timei.. Memory space (private SQL area for Shared Server only)j.. Concurrent sessions After a profile has been created, the database administrator can…

 exporting schema excluding some tables: To exclude table from EXPDP Backup. Let’s take a case, you have 100 tables in your schema and you want to export only 99 of them except two which are huge in size and already available at destination. Here, expdp exclude=table:”in\(‘EMP’\,’DEPT’\)” parameter is best for DBA . Make sure you provide table…