This discussion is archived
4 Replies Latest reply: Dec 26, 2012 9:14 PM by leen RSS

Unable to take import from schema from my local server.

leen Newbie
Currently Being Moderated
Dear friends,

i am facing the below problem in export only,but their is no problem in import.

FILE-NAME                                                                      TABLESPACE_NAME  BYTES          BLOCKS
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\AXPERT.DBF  AXPERT                  8589934592  1048576

WE ARE USING  version
Oracle Database 10g Release 10.1.0.2.0 - Production
PL/SQL Release 10.1.0.2.0 - Production
CORE     10.1.0.2.0     Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

D:\>EXP CENTRAL/LOG@ORCL FILE=20121217CENTRAL0857AMFROMSERVER237.DMP
Export: Release 10.1.0.2.0 - Production on Mon Dec 17 08:57:47 2012
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CENTRAL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CENTRAL
About to export CENTRAL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points