Re: Howto do undo a default clause?

"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message news:3f2a7562$0$10354$afc38c87_at_news.optusnet.com.au...
> "Tanel Poder" <tanel@@peldik.com> wrote in message
news:3f2a7256_1_at_news.estpak.ee...
>
> > Btw, you could make a separate user for generating the script and create
> > your own view all_tab_columns there which uses decode (and custom
functions
> > to handle LONG datatype) to eliminate "null" strings. Then you'r local
view
> > will "override" the public synonym on DD view..
>
> So much for use of LONG being deprecated, eh? ;)

Yeah, for example from 9.2 App developers guide I read: a.. A table with LONG columns cannot be stored in a tablespace with automatic segment-space management.

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.

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...

Tanel. Received on Fri Aug 01 2003 - 09:38:57 CDT