Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: From 10g, "SQL Statement Length" description disappeared....

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

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 5 Sep 2004 20:02:49 +0100
Message-ID: <413b62ba$0$20250$cc9e4d1f@news-text.dial.pipex.com>


"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
Received on Sun Sep 05 2004 - 14:02:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US