Re: Howto do undo a default clause?

"Tanel Poder" <tanel@@peldik.com> wrote in message news:3f2a7b82$1_1_at_news.estpak.ee...

> But the reality is:
>
> SQL> select extent_management, segment_space_management from dba_tablespaces
> where tablespace_name = 'USERS';
>
> EXTENT_MAN SEGMEN
> ---------- ------
> LOCAL AUTO
>
> SQL> create table g (a long) tablespace users;
>
> Table created.

Nice!

> I bet there are still many developers & designers who are keen to use LONGs
> in their design.. since they don't have a clue about LOBs with their ancient
> skills and unwillingess to learn...

Hehehe! How true. Probably we should include the developers and designers of Oracle's own dictionary in that definition...

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam