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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: