Moving a table from one tablespace to another tablespace

Moving a table from one tablespace to another tablespace

Post by Peter Jenn » Tue, 16 Dec 2003 22:33:52



Hi NG

what is the easiest way to move a table from one tablespace to another ?

Thanks
Peter

 
 
 

Moving a table from one tablespace to another tablespace

Post by Daniel R » Wed, 17 Dec 2003 05:16:03


The answer is highly dependant on your version. If you have 8i at
least, just do "alter table yourtablename move (online) tablespace
newtablespace". Look in the SQL reference manual for all the options
you can use while doing this move.

Daniel

Quote:> Hi NG

> what is the easiest way to move a table from one tablespace to another ?

> Thanks
> Peter

> --


 
 
 

1. Moving tables from one tablespace to another?

I am trying to reorganize a Oracle 6 database to prepare this database
for migration to Oracle 7. For this reason, I want to move some tables
to a new tablespace. When I export this tables to a 'dmp' file I get the
message that the table constraints are not exported. How can I export
the tables to the 'dmp' file together with the contraints? Are there
other possibilities do this kind of reorganization?

Thanks in advance

Stefan

2. Restricting installing of ome apps

3. Help: Moving tables and indexes from one tablespace to another

4. Return values for the "format" command?

5. Moving tables from one tablespace to another

6. Looking for clip art images..

7. FS: Sharp Zaurus

8. moving from tablespace a to tablespace b

9. Move objects from one tablespace to another

10. Moving data from one tablespace/user to another in 8.1.7

11. How can i copy data from one table in one tablespace to table in a difft tablespace?

12. Moving TABLES to another TABLESPACE