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

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

Question Posted / vignesh

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

Answer / 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

More Oracle General Interview Questions

Explain the use of Merge statement in oracle 11g

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

how will I find the first 5 highest salaried employees in each dept in oracle.

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

What is the usage of analyze command in oracle?

What is proxy method?

is database gud carrier option??

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

How to do a full database export?

State and explain about oracle instance?

How would you extract DDL of a table without using a GUI tool?

For more Oracle General Interview Questions Click Here