|
-
I have a table that has been designed wrongly.
The initial extent is 5m and next extent is 10m,etc of which both the initial and the next
extents have been used so far. I want to make the initial and next to
be 10m each.
(NOTE: I know that you can not alter a table to change the initial extent).
But my question is if I export the table, truncate it, then import it
with the idea of making all the extents one. Can I at this point change the initial
extent after I have truncated the table since there will be no data in it
before importing it back.
These are the steps I'm thinking of using:
1.Export the table
2.Truncate the table
3.Alter the table to change the initial and next extents
4.Import the table
P.S. I have always done it like this to change the next extent and it
worked great but I have not done it to change the initial extent before.
Any ideas "guys"?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|