Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSDATE in partition range boundary?
Hi,
You can generate and spool the ddl you need and execute that.
eg. sqlplus...
spool ddl.sql
select '....values less than (' || trunc(sysdate,'d') || ') ....' from dual;
spool off
@ddl.sql
Jos
<chrisoc_at_ans.net> schreef in berichtnieuws 88hfdg$gh7$1_at_nnrp1.deja.com...
>
>
> How can I get SYSDATE incorporated into the definition
> of a partition boundary for a table? Using hardcoded
> dates works fine, e.g.
>
> values less than (to_date('10-FEB-2000', 'DD-MON-YYYY'))
>
> but I need to automatically add a partition every day
> with a cutoff of 00:00:00 -- to get yesterday's dated
> material loaded.
>
> SQL*Plus wants a string literal, or a number, or a MAXVALUE.
>
> Tried a bunch of to_char/to_date combinations without success.
>
> Chris O'Connor
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Feb 21 2000 - 06:18:01 CST