Hello,
I am trying to Import a schema with datapump from an oracle 12c instance into an oracle 11.2 instance. I got an error cause of the different timezone files. 11.2 is on version 14 and 12c is on version 18. So I tried to import only one table, made a new export with that one table (table got no column data type timestamp with time zone) and exported it. That worked well. So i modified my schema export to exlude those tables which have columns with data type timestatmp with time zone. When trying to import that new dump, it still fails for the same reason.
So to import one table worked, but to import a schema failed. Does have anyone a suggestion for me, how I can import that dump ? And no, I cannot install a patch with new time zone files.
sql_coder