Can anybody tell me how I can add a column to table at a specific position using the
DBMS_REDEFINITION package from Oracle?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com May 20 '13 at 12:26
This question came from our site for professional and enthusiast programmers.
The short answer: you cannot add column to a table at a specific position.
When you add new columns they always go after the existing columns. You have to re-create your table with new definition to place a column to a position you need.
You can however create views with columns positioned arbitrarily based on your existing table, and then query or update the table directly or through your newly created views (see the section "About Views" in Database Administrator's Guide). Though some restrictions may apply to the updatable views, join views in particular (see the section "Updating a Join View" in Database Administrator's Guide).