Change tablespace from a table

[schnu]

Hello everyone

I have the following doubt, I have a test table that is pointing to the 'System' tablespace. But I wish she was pointing at the 'test_dados' tablespace. Is it possible for me to change this without dropping the test table ??? If it's possible, how do I do it ??


Thank you

Back Oracle

[gilbertoca]

This link http://asktom.oracle.com/pls/ask/f?p=49 ... 6718680907 can help.
Basically it is as follows:

Select all

 
ALTER TABLE<table_name> MOVE TABLESPACE < target_tablespace> 

Gilberto

[Junior]

Remembering that you need to recreate the indicates later !!