reorganize tables in system tablespace
Can anybody list out the procedure involved in reorganizing the tables in system tablespace in oracle220.127.116.11.0 for windows advanced server 2000.
[Edited by diwakar on 06-18-2002 at 01:19 AM]
I think export/import is the way to do it. There are some articles on it in Metalink
Could you list out the procedure in detail for defragmentation by export/import..
Also I do not have access to metalink and I shall be happy if you could copy a few of those stuffs and paste it here for reference...
Thanks and Regards,
[Edited by diwakar on 06-18-2002 at 01:28 AM]
when I import the dump file(compressed), I again get the same no. of extents. Hence could someone list out the changes that has to be made before importing the stuffs back.
tables=(.. , .. ,..)
2. disable triggers on those tables
3. disable fk constraints on those tables
4. truncate those tables
Follow if step by step, AND MAKE SURE YOUR EXPORT IS GOOD before truncating.
Good ways of doing that are described Here
Hope that helps,
OCP DBA 8/8i/9i
visit our web site: Here
Click Here to Expand Forum to Full Width