load error

[unknown]

we are trying to load some dump in Devlopment server from
Production Server
we are getting this error
Can anyone explain, how to solve this..??

[] ****: dump taken on 2K page size can't be recovered on 8K
page size
[] *** This program has been terminated.
[] *** This program did NOT complete successfully.

[Michael Heaney]

Post by unknown
we are trying to load some dump in Devlopment server from
Production Server
we are getting this error
Can anyone explain, how to solve this..??
[] ****: dump taken on 2K page size can't be recovered on 8K
page size
[] *** This program has been terminated.
[] *** This program did NOT complete successfully.

Your Production server was built using 2K page size,
and your Development server was built using 8K pages.
Dumps from one cannot be loaded to the other. You'll
need to rebuild your Development box to match the
Production box - or else find another way to move
the data (eg with bcp).


Michael Heaney
JCVI