|
-
Import error - ORA-25157 Block size 6144 is not valid
I need to move a database from a server running Win2k and Oracle 9.2.0.3 onto a temporary machine running Win 2003 and Oracle 9.2.0.1
Question 1 - is the error I'm getting because the target database is a lower release of 9i? (I wildly assumed because the version numbers are of the same release (9.2) that it would not matter.)
The import fails creating the first tablespace:
IMP-00017:following statement failed with Oracle error 25157:
"CREATE TABLESPACE" AC_IMP " BLOCK SIZE 6144 DATAFILE "E:\ORACLE ..."etc
IMP-00003: ORACLE error 25157 encountered
ORA-25157:specified block size 6144 is not valid.
My export was a standard:
FULL=y
GRANTS=y
CONSISTENT=y
(no othere params specified)
The import was:
FULL=y
CONSISTENT=y
GRANTS=y
Question 2 = where does the CREATE TABLESPACE get the BLOCK size from?
I've never seen or heard of this type of error before.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|