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

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2079

When do you get a .pll extension in oracle?

1084

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

983

Give syntax for SQL and ORACLE joins.

1048

What is an external table?

963

Explain oracle’s system global area (sga).

1085

Point out the difference between user tables and data dictionary?

939

What is the usage of control file in oracle?

1032

What is the purpose of save points in oracle database?

1014

What are the differences between primary key and unique key?

953

Why use resource manager in Oracle?

1059

How to execute a stored program unit?

1014

What are the attributes of the cursor?

944

What do you understand by database schema and what does it hold?

1185

How can you merge two tables in oracle?

943