Home » RDBMS Server » Server Utilities » IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables (ORA 11.2.0.3 on ORA enterprise linux)
IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables [message #572756] Mon, 17 December 2012 07:20 Go to next message
geomac
Messages: 8
Registered: November 2012
Location: Germany
Junior Member
hi

i got expd dump from 10.2.0.1.0 ORA XE database on win7 64 bit by
"expdp system/xxxx directory=DATA_PUMP_DIR dumpfile=xxx.dmp schemas=xxx EXCLUDE=STATISTICS VERSION=11.2.0.3"

the tables were exported ... no i try to import these dump into ORA enterprise 11.2.0.3 (on ora enterprise linux 64 bit) with
"impdp system/xxxx directory=DATA_PUMP_DIR dumpfile=xxx.dmp schemas=xxx TABLE_EXISTS_ACTION=APPEND"

i used that documentation: //docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm#i262317
finally schema is created.. indizies, triggers and tables are created but the tables stay / are empty....
please give me a hint.. thanks in advance

import log
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/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT





[Updated on: Mon, 17 December 2012 08:04]

Report message to a moderator

Re: IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables [message #572758 is a reply to message #572756] Mon, 17 December 2012 08:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
VERSION=11.2.0.3


I doubt a lower version can export into an upper version that, obviously, didn't exist at the time the lower version was released. I think Oracle ignored your parameter.

Post the export log as well.

Regards
Michel
Re: IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables [message #572759 is a reply to message #572758] Mon, 17 December 2012 08:14 Go to previous messageGo to next message
geomac
Messages: 8
Registered: November 2012
Location: Germany
Junior Member
here you are

;;;
Export: Release 10.2.0.1.0 - Production on Montag, 17 Dezember, 2012 15:09:42

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Angemeldet bei: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
"SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=DATA_PUMP_DIR dumpfile=xxx.dmp schemas=xxx EXCLUDE=STATISTICS VERSION=11.2.0.3 wird gestartet
Schätzung erfolgt mit Methode BLOCKS...
Objekttyp SCHEMA_EXPORT/TABLE/TABLE_DATA wird verarbeitet
Gesamte Schätzung mit BLOCKS Methode: 461.4 MB
Objekttyp SCHEMA_EXPORT/USER wird verarbeitet
Objekttyp SCHEMA_EXPORT/SYSTEM_GRANT wird verarbeitet
Objekttyp SCHEMA_EXPORT/ROLE_GRANT wird verarbeitet
Objekttyp SCHEMA_EXPORT/DEFAULT_ROLE wird verarbeitet
Objekttyp SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA wird verarbeitet
Objekttyp SCHEMA_EXPORT/SYNONYM/SYNONYM wird verarbeitet
Objekttyp SCHEMA_EXPORT/SEQUENCE/SEQUENCE wird verarbeitet
Objekttyp SCHEMA_EXPORT/TABLE/TABLE wird verarbeitet
Objekttyp SCHEMA_EXPORT/TABLE/INDEX/INDEX wird verarbeitet
Objekttyp SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT wird verarbeitet
Objekttyp SCHEMA_EXPORT/FUNCTION/FUNCTION wird verarbeitet
Objekttyp SCHEMA_EXPORT/PROCEDURE/PROCEDURE wird verarbeitet
Objekttyp SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION wird verarbeitet
Objekttyp SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE wird verarbeitet
Objekttyp SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT wird verarbeitet
. . "CI_LND_NBB_B"."GIS_LCN_AJ" 8.320 KB 103 Zeilen exportiert
snip other tables
. . "CI_LND_NBB_B"."WLRO_USAGE_MAPPING" 0 KB 0 Zeilen exportiert
Master-Tabelle "SYSTEM"."SYS_EXPORT_SCHEMA_01" erfolgreich geladen/entladen
******************************************************************************
Für SYSTEM.SYS_EXPORT_SCHEMA_01 festgelegte Dump-Datei ist:
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\DPDUMP\CI_LND_NBB_B.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" erfolgreich um 15:10:15 abgeschlossen
Re: IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables [message #572824 is a reply to message #572759] Tue, 18 December 2012 00:44 Go to previous messageGo to next message
geomac
Messages: 8
Registered: November 2012
Location: Germany
Junior Member
Hi Michel, are there other alternatives to "convert" schema from 10.2 to 11.2 e.g. by SQL Developer (DB Export or DB Copy). I ´d like to avoid try & error. Thanks carsten

[Updated on: Tue, 18 December 2012 00:45]

Report message to a moderator

Re: IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables [message #572834 is a reply to message #572824] Tue, 18 December 2012 01:14 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing to do to "convert" from 10.2 to 11.2.
All what exist in 10.2 is known in 11.2 without any modification.

Regards
Michel
Previous Topic: ORA-01400: cannot insert NULL into ROW_ID
Next Topic: How to compare column name of a schema with other schema's column name
Goto Forum:
  


Current Time: Thu Mar 28 18:14:33 CDT 2024