|
-
If you are using Oracle 8i, you can move tables of each application in to its own tablespace by
ALTER TABLE name MOVE TABLESPACE new_tablespace;
You have to then rebuild indexes
ALTER INDEX idxname REBUILD TABLESPACE indxtablespace;
If you don't have 8i (or above), you have to use export and import to reorganize your database.
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
|