Anuroop Challa

ORA-01436: CONNECT BY loop in user data ====================================== this error will produce mostly from CONNECT BY looping from staement, this looping from sql cause never ending so it generates error.  check with your trace file and check with  application team to know what they runing and rectify it 

ORA-01000: maximum open cursors exceeded   cause : this issue produce reason OPEN_CURSORS parameter size, in your database please check present size and increase it more value to avoid error repetition in future.  To check present value:- sho parameter OPEN_CURSORS  NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ open_cursors                         integer     300 increase value by using below command alter system set open_cursors = 1000 scope=both;

IMPDP 10g,11g and 12c parameters  :- =============================== IMPDP 10g $ impdp help=y Import: Release 10.2.0.5.0 - 64bit Production on Monday, 12 February, 2018 12:00:08 Copyright (c) 2003, 2007, Oracle.  All rights reserved. The Data Pump Import utility provides a mechanism for transferring data objects between Oracle databases. The utility is invoked with the following command:      Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp You can control how Import runs by entering the 'impdp' command followed by various parameters. To specify parameters, you use keywords:      Format:  impdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)      Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp USERID must be the first parameter on the command line. Keyword               Description (Default) ------------------------------------------------------------------------------ ATTACH                Attach to existing job, e.g

EXPDP 10g,11g and 12c parameters:- EXPDP 10g:-  expdp help=y Export: Release 10.2.0.5.0 - 64bit Production on Monday, 12 February, 2018 11:55:11 Copyright (c) 2003, 2007, Oracle.  All rights reserved. The Data Pump export utility provides a mechanism for transferring data objects between Oracle databases. The utility is invoked with the following command:    Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp You can control how Export runs by entering the 'expdp' command followed by various parameters. To specify parameters, you use keywords:    Format:  expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)    Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott                or TABLES=(T1:P1,T1:P2), if T1 is partitioned table USERID must be the first parameter on the command line. Keyword               Description (Default) ------------------------------------------------------------------------------ ATTACH

TYPE difference between source and target after import :-  in our source database we have objects(TYPE) in schame_1 some x after import in target db the number show TYPE count Y.  REASON:- subtype , from 11g sub-type show multiple number, when we import schema by using datapump as per below picture, But type count show diff  we can ignore in this case count if it is related to subtype. select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,TIMESTAMP from dba_objects where OWNER='<SCHEMA_NAME>' and OBJECT_TYPE='TYPE';