Oracle export/import done from Higher to lower version

Export :

[oracle@HN300949l ~]$ expdp test/test DUMPFILE=test10092011.dmp DIRECTORY=EXPDP SCHEMAS=test version=10.2.0.1

Export: Release 11.2.0.1.0 - Production on Mon Oct 10 12:52:15 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "TEST"."SYS_EXPORT_SCHEMA_01":  test/******** DUMPFILE=test10092011.dmp DIRECTORY=EXPDP SCHEMAS=test version=10.2.0.1

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 55.68 MB

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported "TEST"."DEDUPLICATE_TAB"                    9.552 MB    1000 rows

. . exported "TEST"."NOCOMPRESS_TAB"                     9.552 MB    1000 rows

. . exported "TEST"."KEEP_DUPLICATES_TAB"                9.552 MB    1000 rows

. . exported "TEST"."COMPRESS_TAB"                       9.552 MB    1000 rows

. . exported "TEST"."SF_TAB"                             5.335 KB       1 rows

. . exported "TEST"."BF_TAB"                             5.335 KB       1 rows

. . exported "TEST"."MY_CUSTOMERS"                       6.335 KB       1 rows

. . exported "TEST"."TEST"                               6.382 KB       1 rows

. . exported "TEST"."OUTER_NTAB"                             0 KB       0 rows

. . exported "TEST"."INNER_NTAB"                             0 KB       0 rows

. . exported "TEST"."STU_TAB"                                0 KB       0 rows

. . exported "TEST"."PER_TAB"                                0 KB       0 rows

. . exported "TEST"."TIME_TABLE"                             0 KB       0 rows

Master table "TEST"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for TEST.SYS_EXPORT_SCHEMA_01 is:

  /u01/app/oracle/test10092011.dmp

Job "TEST"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:57:30

****************************************** -----------------------------------------------------------*********************************************************

Import :

D:\oracle\product\10.2.0\db_1\BIN>

D:\oracle\product\10.2.0\db_1\BIN>impdp 'sys/database as sysdba' directory=DATA_PUMP_DIR dumpfile=test10092011.dmp

Import: Release 10.2.0.1.0 - Production on Monday, 10 October, 2011 13:50:20

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYS"."SYS_IMPORT_FULL_01":  'sys/******** AS SYSDBA' directory=DATA_PUMP_DIR dumpfile=test10092011.dmp

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "TEST"."DEDUPLICATE_TAB"                    9.552 MB    1000 rows

. . imported "TEST"."NOCOMPRESS_TAB"                     9.552 MB    1000 rows

. . imported "TEST"."KEEP_DUPLICATES_TAB"                9.552 MB    1000 rows

. . imported "TEST"."COMPRESS_TAB"                       9.552 MB    1000 rows

. . imported "TEST"."SF_TAB"                             5.335 KB       1 rows

. . imported "TEST"."BF_TAB"                             5.335 KB       1 rows

. . imported "TEST"."MY_CUSTOMERS"                       6.335 KB       1 rows

. . imported "TEST"."TEST"                               6.382 KB       1 rows

. . imported "TEST"."OUTER_NTAB"                             0 KB       0 rows

. . imported "TEST"."INNER_NTAB"                             0 KB       0 rows

. . imported "TEST"."STU_TAB"                                0 KB       0 rows

. . imported "TEST"."PER_TAB"                                0 KB       0 rows

. . imported "TEST"."TIME_TABLE"                             0 KB       0 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 13:51:04

Regards,

Navaneeth