Build a new 8k shell and export/import is the only way I ever been able to
do it.
Richard Robrock
Pennant Alliance Database Services
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------
"Jesse Santana "
<oracledba-ezmlmshield-x84518227. To: "LazyDBA Discussion" <[Email address protected]
x1115247382 cc:
@lazydba.com> Subject: Cloning to Db with different block size
05/04/2005 04:07 PM
I'm hoping someone can give me a little advice here. We have a Sun
Solaris 9 system that is running Oracle 9.2.0.6. The database was built
with a 4k block size. We have since purchased a Sun V480 and have
installed Oracle 9.2.0.6 on it and have used an 8k block size. I now need
to move the data over from the 4k Db to the 8k Db. I know I can do an
export/import but that takes three days due to the amount of data on the
original box. Does anyone know of a quick way to clone the database to
the new machine while preserving the new block size?
Jesse Santana
System Administrator
Information Technology Services
California State University, Long Beach
1250 Bellflower Blvd.
Long Beach, CA 90840
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page