Skip navigation.

rajabaskar's blog

import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)

rajabaskar's picture

Last week I migrated some schemas from 11g database (11.1.0.6) to 9i database (9.2.0.8).

I used to export the 11g schemas using oracle 9i binary & exported successfully.
While importing 11g schema’s into 9i database I faced below issues.

Error: import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)

Operating system: Sun Solaris 10 / 64 bit processor

Note:

I exported the 11g schema’s using 10g binary and imported into 10g database
successfully.

Oracle 11g Data pump: compression feature

rajabaskar's picture

Last week, I worked on schema refresh in 11g database from one box to another box using data pump.

Schema size: around 90 GB.
Version: 11.1.0.7

Method 1:

Normally we follow below steps: (I have sufficient space in file system, so I am using below steps)
1.Export the schema using expdp/exp utility.
2.Compress the dump file.
3.Transfer the data through ftp to another box.
4.Just import it.

Step 2, depend upon dump size.

Note:
I have sufficient space in file system, so I am using method 1.

Method 2:

1.Export the schema using expdp/exp utility (during export they used