SQL脚本/表分区

以下查询将告诉您是否启用分区:

select value from v$option where parameter = 'Partitioning';

如果分区不可用,则应出现以下错误:

ORA-00439: feature not enabled: Partitioning

所以您可以在脚本中编写pl/sql来创建这样的表:

declare
  no_partioning exception;
  pragma exception_init (no_partioning, -439);
begin
  execute immediate 'CREATE TABLE mytable ...'; -- with partioning clauses
exception
  when no_partioning then
    execute immediate 'CREATE TABLE mytable ...'; -- without partioning clauses
end;
/