Re: Full Ex/Im-port to New Instance, NT

From: Yassir Khogaly <yassir_at_khogaly.freeserve.co.uk>
Date: Fri, 9 Oct 1998 07:24:41 +0100
Message-ID: <6vkai7$bkl$1@newsreader2.core.theplanet.net>

Hi,

Yes.. I Said that and it is correct.
Read the original emai you will find that the question was about Full import into an new Instance...! Talking about new instances..., Please try out this yourself :

1)-FULLY EXPORT YOUR CURRENT DATABASE.
2)-DROP YOUR DATABASE COMPLETELY & REMOVE THE DATAFILES physically and also remove Oracleservice & OracleStart services 3)-RECREATE YOUR DATABASE WITH ALL EXACT PARAMETERS, Tablespaces, Datafiles Names & locations, BUT CHANGED DB_BLOCK_SIZE TO 8K from 2K which is the default for NT4.0.
4)-TRY TO IMPORT YOUR PREVIOUS EXPORT now...?.

Please Let me know if you still NOT happy...!

Good Luck Received on Fri Oct 09 1998 - 01:24:41 CDT