In addition to the below e-mail
There is no quicker way.you have to use export and import . The quicker
way would try transportable tablespace feature.But that would require same
block size . So transport the tablespaces and you can move objects between
the tablespaces (from 4k to 8K).
SQL>alter table <table_name> move tablespace x;
Regards,
Ganti
"Duh Jang " <oracledba-ezmlmshield-x55793656.[Email address protected]
05/05/2005 03:25 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Cloning to Db with different block size
Hi Jesse,
My response is the following.
Hi Jesse,
There is a quick way for your operation.
Box1 4k
Box2 8k
So what you have to do is to allocate some space for db_4k_cache_size in =
box2 and that it is.
You might want to ask what is the size for db_4k_cache_size will be.
This depends on your sga_max_size ( >= 128M the granule will be =
16777216 othewises will be
4194304). So alter system set db_4k_cache_size=3D16777216 if =
sga_max_size is above 128M.
With this sub-cache set-up, you will have two block sizes in the box 2 =
and that is the new 9i feature.
Hope this helps.
Duh
-----Original Message-----
From: Jesse Santana
[mailto:oracledba-ezmlmshield-x84518227.[Email address protected]
Sent: Wednesday, May 04, 2005 4:07 PM
To: LazyDBA Discussion
Subject: Cloning to Db with different block size
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
--------
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