| change of INITIAL for table [message #49710] |
Tue, 05 February 2002 18:24  |
rajkumar
Messages: 9
Registered: February 2002
|
Junior Member |
|
|
as per oracle concepts , it is not possible to modify the storage parameter INITIAL, MINEXTENTS
but through ALTER TABLE MOVE
STORAGE (INITIAL <NEW> );
modification of INITIAL is effected, how?
|
|
|
|
| Re: change of INITIAL for table [message #49712 is a reply to message #49710] |
Tue, 05 February 2002 20:33  |
freedba
Messages: 9
Registered: September 2000
|
Junior Member |
|
|
|
To modify INITIAL of table. you need to drop table and recreate table with you information. but you need to back your data first before insert back into your new configuration table . Hope this will help you.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
