Not able to generate dump
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