Looking at the new server more closely its a Win2k not Win 2003 machine. If I don't specify a block size when creating a DB why (or how) does Oracle choose 6144 or 8192 as the default block size - given that both machines run Windows 2000?
Both machines run Win 2k, but one uses 220.127.116.11 and the other 18.104.22.168
Can I get round my import problem by using IGNORE=Y and pre-creating the tablespaces? Would setting the export buffer size to 8192 help at all? (Clutching at straws with that one )
Everyone dealing with data files on windows should be using this -- you can open any size file with it if you turn on "Disable Line Numbers" and turn on the "Open File without Temp File" options -- it has a great column editting mode, does sorts on flat files, hex editing, reg exp search replace.