move table to other tablespace; necessary to rebuild index if needed; com

Explain the statement?? ALTER TABLE TABLE_NAME MOVE;
What it the use of above statement??

Question Posted / ranveeer singh

Answer Posted / ranveeer singh

move table to other tablespace;
necessary to rebuild index if needed; command
alter index indx_name rebuild tablespace tbs_name;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

can u plz provide me oca sql dumps please i need them

1995

What are the data types in oracle?

1095

What is literal?

1062

How to use subqueries with the in operator using oracle?

1137

What is coalesce function?

1142

How to bring a tablespace offline?

1112

How can I combine multiple rows into a comma-delimited list in oracle?

1114

What happens if you lost a data file?

1080

what is insert all statement in sql

6618

What is bind variable in oracle 11g?

1094

What is hot backup and logical backup?

1111

What is the difference between "as" and "is" in an oracle stored procedure?

1046

Explain implicit cursor.

1074

Explain oracle’s system global area (sga).

1185

What are data pump export and import modes?

1110