Verify Database Creation Wordsize

Has the database been created originally in a 32-bit environment and is now on a 64-bit platform?

select decode(instr(metadata,’B023′),0, ’64bit Database’,’32bit Database’) “DB Creation”
from kopm$;

• KOPM$.METADATA contains ‘B023’ created in 32-bit env
• KOPM$.METADATA contains ‘B047’ created in 64-bit env

Advertisements