Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Pradeep kumar.

Asked: July 20, 2020 - 6:07 am UTC

Last updated: January 16, 2025 - 7:18 am UTC

Version: 12.2.0.2

Viewed 1000+ times

You Asked

Dear Sir,

Hope doing well..


Need some clarification on below points.

1) What is fastest way to change DB_BLOCK_SIZE from 8k to 16k, my DB size is 2TB.
2)Can we duplicate database as active database from standby database and snapshot database.

Please comment on this query.

Thanks
Pradeep

and Connor said...

1) You have to unload and reload the data. There is no way around that because every block must be reformatted.

The real question here is - why do you need to ?

2) Yes

My friend Ludovico has a nice post on it

http://www.ludovicocaldara.net/dba/script-that-duplicate-a-database-using-a-physical-standby-rac-as-source/

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Noami Khan, January 15, 2025 - 4:52 pm UTC

Hi Connor

We are looking into changing the block size from 8K to 16K as well because 32TB tablespace size is not enough. We have 50TB of data. How can we achieve this?
Connor McDonald
January 16, 2025 - 7:18 am UTC

32TB means a single segment will be limited to 32TB.

If you have a single table (non-partitioned) that is 32TB in size, then I think you have other challenges to worry about :-)

But if not, then spread your tables/indexes over multiple tablespaces

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database