|
|
|
|
|
|
|
|
Re: trying to create a new column a specific position in already existing table [message #429373 is a reply to message #429370] |
Tue, 03 November 2009 07:35   |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
Quote:
Always the same answers (could it be differently?).
One is missing:
Why do you need the column to be in a specific place?
The other answer would be (as already provided)
1. Alter the old table
2. Create new table putting the column in the order the OP want
3. Disable constraints if any
4. Drop the old table
5. Rename the new to to the old one
But again, the question arises..
Quote:
Why you need the column to be in a specific place?
There is no genuine requirement that necessacitate this type of operation to be supported.
If you think you have one, let us know and we can suggest alternatives, if needed. But its really a bad bad idea
You can have a look at DBMS_REDEFINITION package
http://www.orafaq.com/node/4
[Updated on: Tue, 03 November 2009 07:43] Report message to a moderator
|
|
|
|
|
|