Hi to all,
We have a development environment where the tablespaces are created with 8k blocks, but in the production environment tablespaces were created with 32k. When I try to do the import with impdp I get a message that the block sizes are different and the operation is terminated. Is there any way to change the block size from the impdp or expdp? Is there any way to make this change without recreating the schema?
Thanks in advance
You have picked a strange forum to ask this query - this is for AQ issues not datapump / generic DB admin.
However, can you provide details of exactly what you are running (both export and then import) and also the error you get? there are a number of options here but I'd like to be clear on what you are trying to do.