Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reorder columns?
thanks for the replies, think I'll just leave it as it is, doesn't cause a
problem, just would have been neater that's all!
<sybrandb_at_yahoo.com> wrote in message
news:1135003961.834319.140660_at_g14g2000cwa.googlegroups.com...
> There is not.
> Usually RDBMSes are being *designed* instead of hacked together, and
> adding a column occurs seldomly.
> You could of course also
> -create a view on this table with the correct column order
> -dump this (and possibly other ) table and start all over again, and
> now do things *properly*
>
> The last option is probably the best in your case.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
Received on Mon Dec 19 2005 - 08:56:58 CST
![]() |
![]() |