| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AP Data Tablespace reorganize
Hello
I would like to know how you would go about in
rebuilding/reorganizing a data tablespace lets say AP
data tablespace. I have lot of small empty spaces
within the tablespace which cannot be used and hence
want to rebuild the tables with proper sizing. However
the trouble I have is if I export the table and drop
it then all object depending on that object will get
dropped like indexes, triggers etc.
However when I import the table it will not import the trigger since the trigger is owned by APPS user. I do not want to import the entire database. Would appreciate if someone would share his experience in this.
Thanks
Abhimanyu
 |
 |