Re: From 10g, "SQL Statement Length" description disappeared....

Niall Litchfield wrote:
>
> "Serge Rielau" <srielau_at_ca.eye-bee-em.com> wrote in message
> news:RBs_c.4678$8Ke1.2861_at_news04.bloor.is.net.cable.rogers.com...
> > Actually various tools, especially in the DSS world build quite big
> > statements. I wouldn't be surprised if they hit a 64k limit.
> > Also if this limit included DDL statements such as create table a
> > generated range-partitioned table definition could quickly reach 64k....
>
> Though given the somewhat revised syntax for partitioning in 10g....
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com

Are you referring to subpartition templates ? These came about in 9.2

cheers
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------