-
perform a reorganization of the data
Hi,
I have to perform perform a reorganization of the data on few tables and indexes. Is export /import of those tables and indexes a good option?
Awaiting inputs
-
Re: perform a reorganization of the data
Originally posted by aj_usa
Hi,
I have to perform perform a reorganization of the data on few tables and indexes. Is export /import of those tables and indexes a good option?
Awaiting inputs
might be quicker to do ctas then drop and rename the old table
why are you re-orging anyway?
-
To verify performance gain. Btw, what is ctas ?
-
oops, i am sorry, i got it, create table as select
-
First - are you sure this is ncessary?
Look at ALTER TABLE . . MOVE followed by ALTER INDEX . . . REBUILD as an option. The trouble, as I see it, with CTAS drop & rename, is that you have to recreate manually all the indexes & constraints - more chance of getting it wrong.
Last edited by DaPi; 12-04-2004 at 03:14 PM.
-
To avoid complications, dont you think, export/import grants,constraints,rows,indexes is somewhat better ?
export table, drop the table, then import it.
pls advice.
-
=======
To avoid complications, dont you think, export/import grants,constraints,rows,indexes is somewhat better ?
export table, drop the table, then import it.
========
There are many things go wrong if you do exp-drop-imp.
For example the export dump file may be corrupted.
If indexes are crated by other user (not owner ), they will not be imported/recrated.
Why do you want to re-org?
What do you find out with the existing tables/indexes?
Do you see too many extents for an object?
Was there any large delete happened on a table?
What is the oracle release do you use?
Tamil
-
Hi Tamil,
yes, We have archived and deleted 50% + of the data in some of these tables and would like to shrink their size to verify any performance gain.
So, advice ...
-
There are numerous topics are there in manuals how to reorganize your data.
Regarding shrinking ur tables delete is not option but use the truncate.Still u didn't satisfy then use the command mentioned Mr.Dapi and create the tables and indexes with new storage parameters.
-
Moving the tables and rebuilding indexes is a much more robust option. I would never risk an export/import on this.
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
|