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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I reset a sequence in oracle?

706


What is parameterized cursor in oracle?

679


What are the different types of trigger and explain its various uses and functions?

642


How to use subqueries with the in operator using oracle?

689


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1961






What happens to the data files if a tablespace is dropped?

686


Why packages are used in oracle?

632


IS it possible to built the oracle database without setting the kernal parameters?

1849


How to delete a column in an existing table in oracle?

672


What are the restrictions in a oracle read only transaction?

640


Explain mutating triggers.

671


How to write an inner join with the where clause in oracle?

674


Difference between pre-select and pre-query

647


candidate key is subset of super key but not vice-verse explain

1658


Name the various constraints used in oracle?

662