Re: Moving data from 2 KB datablock DB to 8 KB datablock DB

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 15 Oct 1999 17:48:57 +0800
Message-ID: <3806F889.7CEF@yahoo.com>

ragu sekar wrote:
>
> We are moving oracle 8.05 database on NT SP 3 from one database ( db bloock size 2kb) to another oracle 8.05 ( db block size 8 kb). Everything else remina the same. The db size is 15 GB
>
> IS there a faster way to do this???
> TAHNKS
You need to unload and reload the data - no way around it...

Which probably means export/import

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Oct 15 1999 - 04:48:57 CDT