Ok Mike,

I did and it didn't work out. It is still complaining about the datatype
with error
ORA-00932: inconsistent datatypes: expected number got long

I want to share this with you all. When you recreate a table using create table
xxxx as select * from zzzz, the default value for the columns will be gone. We
have around 1000 tables that i will recreate using this method, so i am trying
to get a script to recreate the default value on each column in every table.
However Mike, it didn't work out. Still complaining. I need this to work out folks.

Thanks,

Al
Quoting Mike Donnelly <mike.donnelly.[Email address protected]

> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
> normal
> **Anything below this line is the original email text
>
>
> The answer is that LONG columns cannot appear in WHERE clauses. Take
> out
> 'and data_default is not null;' from the query and it will work. Not
> what
> you wanted to hear I guess, but that's the answer.
>
> Best regards,
>
> Mike.
>
>
>


Oracle LazyDBA home page