-
reorganize tables in system tablespace
Dear Sir,
Can anybody list out the procedure involved in reorganizing the tables in system tablespace in oracle8.1.7.0.0 for windows advanced server 2000.
Thanks,
K.Diwakar
[Edited by diwakar on 06-18-2002 at 01:19 AM]
-
Hi,
I think export/import is the way to do it. There are some articles on it in Metalink
Cheers
-
sir,
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,
K.Diwakar
[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.
-
1. export
userid=
file=
log=
compress=y
tables=(.. , .. ,..)
buffer=
2. disable triggers on those tables
3. disable fk constraints on those tables
4. truncate those tables
import
--------
userid=
file=
log=
fromuser=
touser=
commit=
feedback
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,
clio_usa
OCP DBA 8/8i/9i
visit our web site: Here
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
|