| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re-assigning Tablespaces
One of my Databases has several tablespaces assigned but all tables and indices are using the same tablespace. I have imported data from two Database Tables into the new database. The import was successful.
When I delete from a particular table the data gets copied to an "archive table". Thus the amount of data in the DB is fairly consistent. However, the delete does not recover the tablespace. So, although the Data in the Database is fairly constant, I am running out of tablespace.
Is it possible to change the default tablespace for a table without
dropping the table.
If this is not possible, what is the best strategy for getting out
of this mess? I need to retain the Database Schema, Triggers, Constraints
and Data as is, but I could allow the database to go offline for a couple
of hours
I Received on Wed Feb 17 1999 - 04:59:53 CST
 |
 |