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

How to create id with auto_increment on oracle?

932

What is merge in oracle?

994

What is a nvl function? How can it be used?

958

What would you do with an in-doubt distributed transaction?

1913

How index is implemented in oracle database?

942

Point out the difference between user tables and data dictionary?

930

What is oracle database client?

973

How to store only time; not date and time?

957

How to create a new user account in oracle?

952

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2431

How different is ms access and oracle?

986

Explain an exception?

919

What is clustered table in Oracle?

1105

What is SQL access advisor in Oracle?

1135

How to delete a user account in oracle?

911