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

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

What is Partitions in Table ?

How to create an oracle database?

State and explain the different types of data models?

What does ROLLBACK do ?

How can we view last record added to a table?

what is primary key and foreign key when and where have to use

What is raw datatype in oracle?

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

What is the database name in oracle?

Why required to run root.sh at the time of installation and what exactly it will do

What is a Synonym ?

For more Oracle General Interview Questions Click Here