Explain the statement?? ALTER TABLE TABLE_NAME MOVE;
What it the use of above statement??
- 1 Answers
- 5468 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
what is IDE,DMV in sql server?
What is bind variable in oracle 11g?
What is an oracle user account?
How to convert raw data type into text in oracle? Explain
What are the restrictions on external table columns?
What is dual table oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to return top 5 rows in oracle?
What is oracle rowcount?
What are the attributes that are found in a cursor?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What are the limitations of check constraint?
Is truncate autocommit in oracle?
How can I see all tables in oracle?
