Google+ Followers

Pages

Thursday, September 27, 2012

Verify Database 32/64 bit creation


to check  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$;



No comments:

Post a Comment