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

Is primary key indexed by default in oracle?

992

Where do you use decode and case statements?

1000

What is recycle bin in Oracle?

1153

Why use resource manager in Oracle?

1109

Explain the use of grant option in exp command.

1067

How many types of synonyms in Oracle?

1127

What is raw datatype in oracle?

1142

What is an oracle cursor variable?

1083

Explain do view contain data?

1016

Explain the difference between replace() and translate() functions in oracle?

1041

what are bitmap indexes? How does they work?

2259

Why do we need oracle client?

958

What is a proxy class?

1059

What is user managed backup in Oracle?

1148

What is a directory object?

1101