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…

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.…

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…

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…

 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…

When ever you try to insert an ambersand ‘&’ into database, database tries to intract and get the values values from screen. in that case we can follow below steps create table test (name varchar2(35)); insert into test values (‘hello&world’);…

Find accounts unused for days                                                 Summary Here’s a script that shows accounts and number of days since last use. It assumes session auditing is enabled. SELECT RPAD(da.username, 12) “Username”, TRUNC(SYSDATE – MAX(da.TIMESTAMP)) “Days Inactive”, LPAD(du.account_status, 16) “Status”, LPAD(TO_CHAR(MAX(da.TIMESTAMP), ‘DD-MON-YYYY’), 16)…

I found this interesting article online & would like to share: The role of the DBA is an anomaly in the IT environment. DBAs are often extremely critical yet hidden from view; highly paid yet individual contributors; and very knowledgeable…

 ORA-24247: network access denied by access control list (ACL)Yesterday I was trying to send mail from my Oracle Database and I got below mentioned error :- ERROR at line 1:ORA-24247: network access denied by access control list (ACL)ORA-06512: at “CINP01314”,…