rajabaskar's blog
import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)
Submitted by rajabaskar on Wed, 2009-09-30 19:25
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
Submitted by rajabaskar on Sat, 2009-09-05 10:57
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

