查询数据库版本兼容性:
show parameter COMPATIBLE
或:
col NAME for a20
col VALUE for a15
col DESCRIPTION for a80
select name,value,description from v$parameter where name = 'compatible';
修改数据库版本兼容性:
alter system set compatible = "12.1.0" sope = spfile;
查询数据库版本兼容性:
show parameter COMPATIBLE
或:
col NAME for a20
col VALUE for a15
col DESCRIPTION for a80
select name,value,description from v$parameter where name = 'compatible';
修改数据库版本兼容性:
alter system set compatible = "12.1.0" sope = spfile;