What's wrong with the analysis?
Wrong
syntax in the 'CREATE TABLE'
PCTFREE and PCTUSED are not part of the storage
clause.
SQL> create table t1 (c1 number)
tablespace lmt1 pctfree 20 pctused 30;
Table created.
Lot's
of potential to go down the wrong path on this one.
Assumptions!
Nelson
-----Original Message-----
From: Richard Foote [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Little competition
From: Richard Foote [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Little competition
Little competition for you all :)It's a two part question:
- What's wrong with the following piece of expert analysis ?
- Which well know "Oracle Guru" published this (and continues to display it on his web-page) ?
"Sadly, Oracle9i doesn't allow you to specify the value for PCTFREE if you're using automatic space management. This is a serious limitation because Oracle9i can't know in advance about the amount of VARCHAR expansion in a table row, leading to excessive row chaining and poor access performance."SQL> create table
2 test_table
3 (c1 number)
4 tablespace
5 asm_test
6 storage
7 ( pctfree 20 pctused 30 )
8 ;
( pctfree 20 pctused 30 )
*
ERROR at line 7:
ORA-02143: invalid STORAGE option
However, here's an important point. While Oracle9i rejects the PCTFREE and PCTUSED parameters with locally managed tablespaces with automatic space management, it does allow you to enter invalid settings for NEXT and FREELISTS settings"You've gotta love it !!Sorry no clues ....Cheers ;)Richard
