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

State any two functions of oracle?

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

sql command 2 know current database

How to connect ms access to oracle servers?

which sql command we can use to get a print out from oracle?

What is sequence?

What is merge statement used for?

What are main difference between Stored Procedure and Functions.

How to manage transaction isolation level?

1) Does oracle have any table which contain all the exceptions and it's code internally?

What is transaction control statement and how many types of transaction control statement in Oracle?

What are the arithmetic operations?

For more Oracle General Interview Questions Click Here