4 Replies Latest reply: Dec 27, 2012 1:21 AM by Manjusha Muraleedas RSS

    Not able to generate dump

    Manjusha Muraleedas
      Hi,

      I was trying to export a schema from server to my local database ( Oracle express edition.).

      In my machine, there is both 11g and 10g clients for my remote server. TNSNAMES.ORA is configured, I am able to connect to the schemas using toad .

      Now I am trying to export schema.



      C:\Users\manjusha.ng>expdp

      Export: Release 10.2.0.1.0 - Production on Thursday, 27 December, 2012 12:20:58

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

      Username: TFO_DEMO@WATSON
      Password:

      UDE-00008: operation generated ORACLE error 12154
      ORA-12154: TNS:could not resolve the connect identifier specified

      But when I am trying to export HR schema from XE, its done correctly.


      C:\Users\manjusha.ng>expdp

      Export: Release 10.2.0.1.0 - Production on Thursday, 27 December, 2012 12:22:00

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

      Username: hr
      Password:

      Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio
      n
      Starting "HR"."SYS_EXPORT_SCHEMA_01": hr/********
      Estimate in progress using BLOCKS method...
      Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
      Total estimation using BLOCKS method: 448 KB
      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/TABLESPACE_QUOTA
      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/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/ALTER_PROCEDURE
      Processing object type SCHEMA_EXPORT/VIEW/VIEW
      Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
      Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
      Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
      . . exported "HR"."COUNTRIES" 6.085 KB 25 rows
      . . exported "HR"."DEPARTMENTS" 6.632 KB 27 rows
      . . exported "HR"."EMPLOYEES" 15.76 KB 107 rows
      . . exported "HR"."JOBS" 6.609 KB 19 rows
      . . exported "HR"."JOB_HISTORY" 6.585 KB 10 rows
      . . exported "HR"."LOCATIONS" 7.710 KB 23 rows
      . . exported "HR"."REGIONS" 5.289 KB 4 rows
      Master table "HR"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
      ******************************************************************************
      Dump file set for HR.SYS_EXPORT_SCHEMA_01 is:
      C:\ORACLEXE\APP\ORACLE\ADMIN\XE\DPDUMP\EXPDAT.DMP
      Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:22:37


      C:\Users\manjusha.ng>

      what will be the reason.. Please help