why not use export/import instead of CTAS?

On 10/02/2008, [Email address protected] <[Email address protected] wrote:
>
> 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