Oracle ASH report introduced on Oracle 10GR2. It is kind of statistical data collected by Oracle Sampled data. The sampling is done on the current active sessions. Sampled data collected to circular buffer in SGA and the same can be accessed through V$ views. V$ACTIVE_SESSION_HISTORY view provides the sampled session activity for the instance.
Unique key constraint creations failed on table with following error.
SQL> alter table emp add constraint emp_UK unique (emp_id);
alter table emp add constraint emp_UK unique (emp_id)
ERROR at line 1:
ORA-02299: cannot validate (SCOTT.EMP_UK) - duplicate keys found
Suppose by mistake if you drop a table in Oracle 10g Oracle 11g you can retrieve the table using Flashback table feature. Flashback feature works with recycle bin to recover the table. For this the recycle bin must be enabled for the database.
In Oracle 10g and 11g if you do a select * from tab; you can see many tables starts with Bin$ which we cannot drop using drop table command. These are the objects in the recycle bin which can be used for recovery purpose in case needed.
SQL> select * from tab;
DBA is trying to kill oracle sessions and one session is getting failed with following error.
SQL> alter system kill session '786,53315';
alter system kill session '786,53315'
Oracle Create table, Materialized View Command Fails with ORA-01723: zero-length columns are not allowed
Oracle Create As Select Command (CTAS) failed with following error.
SQL> create table emp as select name, null age from candidate;
create table emp as select name, null age from candidate
ERROR at line 1:
Select from database link fails with following error.
12154. 00000 - "TNS:could not resolve the connect identifier specified"
*Cause: A connection to a database or other service was requested using
a connect identifier, and the connect identifier specified could not
be resolved into a connect descriptor using one of the naming methods
configured. For example, if the type of connect identifier used was a
net service name then the net service name could not be found in a
naming method repository, or the repository could not be
located or reached.
For Oracle database, it is mandatory to have 2 or more redo log groups which record the each and every change to the database. The LGWR process writes the changes to the redo log files in a cyclic manner. It starts writing into first redo group and moves to 2nd one and so on. After completion of the last group, the LGWR again starts writing with the first one.
Please find some simple calculations for income tax for the financial year 2012-13. Finance minister increased the tax exemption limit to 2Lakhs from 1.8Lakhs and 20% slab extended up to 10Lakhs margin. 30% slab is applicable for 10lakhs and above.
Google Plus One +1 button started coming in Google Adsense ads since October 2011. This gives additional relevance to the Adsense ads and it is useful to deliver more useful ads to the page users. Moreover the clicks on the +1 buttons are not counted as Adsense clicks and won’t generate any income to you.
IMPDP failed with following error.
impdp job_name=schemaexp schemas=test dumpfile=exp_test%u.dmp logfile=imp_exp_TEST.log directory=exp_dir
Import: Release 22.214.171.124.0 - Production on Tue Mar 6 00:26:25 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Error Description: IMPDP fails or terminate with following errors.
ORA-39065: unexpected master process exception in SEND
ORA-39079: unable to enqueue message RP,KUPC$C_3_20120305232114,MCP,KUPC$A_4_232736061619000,1,N
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86