select count (*) as contador,EXTRACT(MONTH FROM CREATION_TIME) as mes,
 EXTRACT(YEAR FROM CREATION_TIME) as anio
FROM TABLA p WHERE CAMPO=1 AND BORRADO=0
GROUP BY EXTRACT(YEAR FROM CREATION_TIME),EXTRACT(MONTH FROM CREATION_TIME) ORDER BY anio,mes ASC;


Devolver el contador de campo a buscar agrupados por año

Grant sobre rol de base datos

GRANT SELECT, insert, update, delete ON ESQUEMA.XXX to R_ROL_LE;

Cambiar valor de la secuencia al mayor ID de la base de datos

declare
  v_sql varchar2(500);
begin
  EXECUTE IMMEDIATE 'drop sequence "ESQUEMA"."HIBERNATE_SEQUENCE"';
  SELECT 'CREATE SEQUENCE "ESQUEMA"."HIBERNATE_SEQUENCE" MINVALUE 1 START WITH '||  
    (SELECT MAX(ID1)+1 FROM (
      SELECT MAX(ID) "ID1" FROM  XXXY
       UNION
      SELECT MAX(ID) FROM  XXX)
  )    
  ||' INCREMENT BY 1 CACHE 20'
  INTO v_sql
  FROM dual;

  EXECUTE IMMEDIATE v_sql;

  dbms_output.put_line(v_sql);
end;

Crear tablespace de datos e indices

CREATE TABLESPACE DATOS_xxx datafile 'xxx_datafile.dbf' size 20M AUTOEXTEND ON;

CREATE TABLESPACE IDEX_xxx datafile 'xxx_index_datafile.dbf' size 20M AUTOEXTEND ON;