IMPORTING OBJECTS OF A TABLE FROM ONE SCHEMA TO OTHER SCHEMA USING DATA PUMP

Here Below i have explained to import the object of specific table from one schema to other schema

impdp userid=\"/ as sysdba\" tables=T1 directory=DP dumpfile=table1.dmp logfile=tableimp1.log TABLE_EXISTS_ACTION=SKIP REMAP_SCHEMA=source schema:target schema

Above command will only include objects related to that table.

Query throwing ORA-00979 not a group by expression in oracle 11g 11.2.0 but it works fine in 10g

CAUSE- Its i a bug in oracle 11g  bug number 9411496

Action to be performed to resolve this issues is 

SOLUTION 1

*Firsrt of all create the pfile from spfile 

*Then in pfile set the hidden parameter  “_FIX_CONTROL”=’5520732:OFF’ in the pfile

* This parameter disable a given bug number

*_FIX_CONTROL is a undocumented parameter  that can be used to turn off/on a particular bug fix identifier.

*Now, We run the query and it successfully gives a result

SOLUTION 2

 set the parameter optimizer_features_enable to a previous version of Oracle, ’11.1.0.7′ for example

ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE='11.1.0.7';

Thank you very much,