Re: Database reorg in Oracle 8?

Heiko <ht_at_bigfoot.de> schreef in berichtnieuws c7307$3ee3802a$d4cac0e3$771_at_nf1.news-service.com...
| > | Is there a tool to reorg a Oracle 8 database? Size is 10 GB with > 100
| > | tables.
| > |
| > | Thanks!
| > | Heiko
| >
| > Oracle export/import?
| > But it all depends on WHAT you want to reorganise. What is your purpose?
| > Why? What is it you need to change?
| > (please specify exact version and platform too).
|
| First I want to rebuild the index-files, in a second step - I hope I can
| reorganize
| the data-tables.
| We work on Windows 2000 Server with Oracle 8.0.5.0.0
|
| Thanks!
| Heiko
|

In that case: reorg the tables first (alter table <tablename> move ....;) Moving a table makes all its indexes invalid and they must be rebuild. I'am still curious why you think reorganizing is good. Do you see many chained rows? Do tables have too many extents (many is > 500 or > 1000 or so, then change the storage clause too in the alter table move). You probably know it but you should consider an upgrade to 8.1.7.3 (or 8.1.7.4) because 8.0.5 is no longer supported. Received on Sun Jun 08 2003 - 14:01:15 CDT