ORA-01027: bind variables not allowed for data definition operations

[dellantewmekonen]

I have the following using bind variable :Max_date -

create table aaa as
select
week_end_date,
rfdwday ,
autorfdwday ,
othrsaspen ,
vsravlhrsperwkday ,
rvsravlhrsperwkday ,
xvsravlhrsperwkday ,
dampfactor
from TG_PROD_PREDICT03WK_C
WHERE week_end_date > :max_date;

Why is that I am not allowed to filter data using bind variable?

[JohnDorlon]

Because Oracle doesn't allow it, apparently.

You probably know this, but those ORA-##### errors come from Oracle, not Toad.

You could use a subquery instead though:

create table blah as
select columns
from table
where week_end_date >= (select week_end_date from some_other_table);