Re: integer / number CTAS problem

Hi Jared,

RE Is the INTEGER data type something unique to your platform? :

Don't know to be honest, but don't think so.

I'd never explicitly used INTEGER before because as far as I was aware
INTEGER and NUMBER were synonymous,...  but Oracle when doing a partition
swap, doesn't agree.

I could change the "destination" table definition, replacing all occurrences
of INTEGER to NUMBER.  But its bugging me that I may have to do this.  The
table is created by the application with INTEGER columns (Portal Development
Centre). I plan to drop it and recreate it partitioned anyway (the Dev
Centre creates a host of internal definitions as a necessary side-effect),
but I didn't want to have to change any column definintions.

Cheers
Tony

On Tue, Oct 14, 2008 at 1:10 PM, Jared Still <jkstill@xxxxxxxxx> wrote:

>
> On Mon, Oct 13, 2008 at 2:25 PM, Tony Adolph <tony.adolph.dba@xxxxxxxxx>wrote:
>
>> create table SOURCE_T
>> (
>>   I INTEGER
>> );
>>
>> desc source_t
>> Name Type    Nullable Default Comments
>> ---- ------- -------- ------- --------
>> I    INTEGER Y
>>
>>
> Hi Tony,
>
> Is the INTEGER data type something unique to your platform?
>
> AFAIK Oracle always reverts to number(38) when INTEGER is specified as a
> data
> type in a table:
>
> SQL> create table SOURCE_T
> (
>   I INTEGER
> );
>
> Table created.
>
> S
> SQL> desc source_t
>  Name                                                  Null?    Type
>  ----------------------------------------------------- --------
> ------------------------------------
>  I                                                              NUMBER(38)
>
> I tried it on Linux an Windows, 32 and 64 bit, which is all I have
> available.
>
> Jared
>
>
>
>

Other related posts: