Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the statement?? ALTER TABLE TABLE_NAME MOVE;
What it the use of above statement??
- 1 Answers
- 5960 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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 |
How to display row numbers with the records?
What is data block in Oracle?
What is a materialised view?
how many columns can a plsql table have
What are Clusters ?
Without giving condition how to retrieve the unmatched records from table.
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What are the different approaches used by Optimizer in choosing an execution plan ?
what is the difference between simple view and complex view?
Can anyone give me information about oracle certification
What are the numeric comparison operations?
How to delete all rows a table in oracle?
Oracle General 
