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

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

Please explain oracle left join with an example?

What is a view and how is it different from a table?

How many types of tables supported by oracle?

Why does Oracle not permit the use of PCTUSED with indexes?

Can objects of the same Schema reside in different tablespaces.?

i want department wise maxmum salary and empolyee name

In what script is snap$ created? In what script is the scott/tiger schema created?

what are bitmap indexes? How does they work?

What are the different types of failures that occur in Oracle database?

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

if i am using dml statement in function. then i am writing select statement what was the output

For more Oracle General Interview Questions Click Here