Explain the statement?? ALTER TABLE TABLE_NAME MOVE;
What it the use of above statement??
- 1 Answers
- 5271 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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
How do I reset a sequence in oracle?
What is parameterized cursor in oracle?
What are the different types of trigger and explain its various uses and functions?
How to use subqueries with the in operator using oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What happens to the data files if a tablespace is dropped?
Why packages are used in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
How to delete a column in an existing table in oracle?
What are the restrictions in a oracle read only transaction?
Explain mutating triggers.
How to write an inner join with the where clause in oracle?
Difference between pre-select and pre-query
candidate key is subset of super key but not vice-verse explain
Name the various constraints used in oracle?
