Oracle Database Discussions

I have exported a schema on one server and copied the exported file and log file into my personal system.Now I am trying to import that file.It's returning an error..Please see the below output.Help in this regard is appreciable.


Hi,

Export the data from other system
=====================================
From Sql Prompt
===============
C:\Documents and Settings\praveenk>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 13 09:54:33 2011

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

Enter user-name: system
Enter password:

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

SQL> drop directory SAMPLE_FILES_DIR;

Directory dropped.

SQL> CREATE OR REPLACE DIRECTORY SAMPLE_FILES_DIR AS
SQL> 'D:\oraclexe\oradata\';

Directory created.

SQL> grant read,write on directory SAMPLE_FILES_DIR to rsint;

Grant succeeded.


From Command prompt
===================

C:\>expdp rsint/rsint@xe schemas=rsint directory=SAMPLE_FILES_DIR dumpfile=RSINT.dmp logfile=expdprsint.log

Export: Release 10.2.0.1.0 - Production on Friday, 13 May, 2011 10:11:13

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

Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Starting "RSINT"."SYS_EXPORT_SCHEMA_01": rsint/********@xe schemas=rsint directory=SAMPLE_FILES_DIR dumpfile=RSINT.dmp logfile=expdprsint.log Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 1.375 MB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "RSINT"."MAIL_TEMPLATE" 8.625 KB 2
rows
. . exported "RSINT"."BOUNCE_MAIL_PARAMS" 8.617 KB 1
rows
. . exported "RSINT"."BOUNCE_MAIL_SERVER" 9.656 KB 4
rows
. . exported "RSINT"."CIRCLE_INFO" 11.08 KB 6
rows
. . exported "RSINT"."GROUPINFO" 7.328 KB 5
rows
. . exported "RSINT"."GROUP_CIRCLES" 5.304 KB 6
rows
. . exported "RSINT"."GROUP_ROLES" 5.710 KB 39
rows
. . exported "RSINT"."LOGININFO" 11.11 KB 10
rows
. . exported "RSINT"."MAINMODULES" 5.835 KB 4
rows
. . exported "RSINT"."PDF_FILE_SEARCH_AUDIT" 9.835 KB 130
rows
. . exported "RSINT"."REPORT_MASTER" 10.36 KB 86
rows
. . exported "RSINT"."ROLESDUMP" 7.546 KB 15
rows
. . exported "RSINT"."SECURITY_PROFILE" 10.18 KB 1
rows
. . exported "RSINT"."USERGROUP" 5.421 KB 14
rows
. . exported "RSINT"."USERMANAGER_AUDIT" 14.42 KB 231
rows
. . exported "RSINT"."USERROLES" 5.289 KB 4
rows
. . exported "RSINT"."USER_CIRCLES" 5.390 KB 12
rows
. . exported "RSINT"."USER_TEMPLATES" 5.351 KB 7
rows
. . exported "RSINT"."GROUP_REPORTS" 0 KB 0
rows
. . exported "RSINT"."REPORT_MANAGER_AUDIT" 0 KB 0
rows
. . exported "RSINT"."TEMPLATE_DS" 0 KB 0
rows
. . exported "RSINT"."USERREPORTS" 0 KB 0
rows
Master table "RSINT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for RSINT.SYS_EXPORT_SCHEMA_01 is:
D:\ORACLEXE\ORADATA\RSINT.DMP
Job "RSINT"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:12:41


/*********next I placed those dump and log files under 'D:\Oracle10G\oradata\' folder of my system

Import the Data to my system
================================

From SQl Prompt
===============
SQL> connect system/oracle;
Connected.
SQL> CREATE OR REPLACE DIRECTORY SAMPLE_FILES_DIR AS
'D:\Oracle10G\oradata\';

Directory created.

SQL> GRANT read, write ON DIRECTORY SAMPLE_FILES_DIR TO rsint;

Grant succeeded.

From Command prompt
===================

C:\>impdp rsint/rsint@orcl38 schemas=rsint directory=SAMPLE_FILES_DIR
dumpfile=RSINT.dmp logfile=impdprsint.log

Import: Release 10.1.0.2.0 - Production on Friday, 13 May, 2011 10:41

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -
Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "D:\Oracle10G\oradata\RSINT.dmp"


Please help me in ths regard