importing from 9i (windows) to 10g (h-ux 11.3) [message #355716] |
Mon, 27 October 2008 04:02 |
seema.taunk
Messages: 96 Registered: October 2006
|
Member |
|
|
Dear all,
I have takedn export dump of owner in windows machine.While trying to import it in hp-ux 11.3, we get following error.
gbss_svr :/tmp >imp file=data.dmp analyze=n log=imp1.log fromuser=channelg
Import: Release 10.2.0.4.0 - Production on Mon Oct 27 14:05:54 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Username: channelg
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing CHANNELG's objects into CHANNELGMemory fault(coredump)
On seraching in Hp site, they asked to check value of maxdsiz & maxdsiz_64 as 256M, but values are already more.maxdsiz 1073741824 Default Immed
maxdsiz_64bit 4294967296 Default Immed
Machine memory : 8 gb.
SGA-> 800 MB
Please advise.
|
|
|
|
|
|