hi am having error when am importing data to my schema.am in window 7 and database is in 11g,has anyone see this error b4
C:\>impdp ECADASTRE/ECADASTRE
Import: Release 11.2.0.1.0 - Production on Sat Apr 6 20:20:44 2013
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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "ECADASTRE"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "ECADASTRE"."SYS_IMPORT_FULL_01": ECADASTRE/********
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"ECADASTRE" already exists
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/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
ORA-39083: Object type DB_LINK failed to create with error:
ORA-02153: invalid VALUES password string
Failing sql is:
CREATE DATABASE LINK "ECADASTRE" CONNECT TO "ECADASTRE" IDENTIFIED BY VALUES '06198721BC205DD677C23E5
7C39DFC083FFD137B936F4FAE6F9F68A615B03D906CC250444A94F2694EFC5A5BFE65E9357C6DE93E0ADF15A27216D6875AA34
C022438F0FEA5D9A5B175EF4647C8BA' USING 'DEVOLTPDB'
ORA-39083: Object type DB_LINK failed to create with error:
ORA-02153: invalid VALUES password string
Failing sql is:
CREATE DATABASE LINK "ESPATIAL" CONNECT TO "ESPATIAL" IDENTIFIED BY VALUES '06D63C3E96EE4E5B9F6A2DD43
EA4610A5624641EAF3232A9C30D6B4A5284AC63C1B5C38D3BCA53F135145429E83C92B80F88745C1F4AB521DA805ADEFE38E9C
ECDA69BC2F5DEA5D585782647ADC7' USING 'DEVGEODB'
ORA-39083: Object type DB_LINK failed to create with error:
ORA-02153: invalid VALUES password string
Failing sql is:
CREATE DATABASE LINK "PRETORIASG" CONNECT TO "SGUSER" IDENTIFIED BY VALUES '06BE4B2065A2829536B78672A
74C87AD3FD18B65ACF15CC36CE7F4A45132D25E15B3944C867D56A024C83EBBF88E1DCA25D5408455DAC91B891D4EDEA9C1039
8E4E91BE4B006BE7A619002897AF7' USING 'PTA'
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ECADASTRE"."TEMP_ESP_LANDENTITY" 3.107 GB 18960859 rows
. . imported "ECADASTRE"."ESP_LANDENTITY_4148" 2.988 GB 18960859 rows
. . imported "ECADASTRE"."ESP_LANDENTITY":"P254" 351.8 MB 11186691 rows
. . imported "ECADASTRE"."ESP_LANDENTITY":"P129" 215.6 MB 868138 rows
. . imported "ECADASTRE"."ESP_ADMINBOUND" 223.6 MB 14148 rows
. . imported "ECADASTRE"."ESP_LANDENTITY":"P108" 156.9 MB 498244 rows
. . imported "ECADASTRE"."ESP_LANDENTITY":"P21" 151.4 MB 575750 rows
. . imported "ECADASTRE"."ESP_LANDENTITY":"P128" 144.6 MB 587401 rows
. . imported "ECADASTRE"."ESP_LANDENTITY":"P135" 136.2 MB 537158 rows
. . imported "ECADASTRE"."ESP_SERVITUDE_POLY" 73.79 MB 262293 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 1049100 bytes (pga heap,kllcqgf:kllsltba)
ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 1712
ORA-06512: at line 2
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 4108 bytes (kksfr: qkesSet,frame segment)
ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 1712
ORA-06512: at line 2
Job "ECADASTRE"."SYS_IMPORT_FULL_01" stopped due to fatal error at 20:46:12
Edited by: adf009 on 2013/04/06 10:09 PM
Edited by: adf009 on 2013/04/06 10:42 PM