create table t (dt, OWNER,
OBJECT_NAME, SUBOBJECT_NAME,OBJECT_ID,
DATA_OBJECT_ID, OBJECT_TYPE, CREATED,
LAST_DDL_TIME, TIMESTAMP, STATUS,
TEMPORARY, GENERATED, SECONDARY)
partition by range(dt) (
partition part2000 values less than
(to_date('01-01-2001','dd-mm-yyyy')),
partition part2001 values less than
(to_date('01-01-2002','dd-mm-yyyy')),
partition part2002 values less than
(to_date('01-01-2003','dd-mm-yyyy'))
) as
select sysdate dt, all_objects.*
from all_objects where 1=0;