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 |
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
What is Partitions in Table ?
How to create an oracle database?
State and explain the different types of data models?
What does ROLLBACK do ?
How can we view last record added to a table?
what is primary key and foreign key when and where have to use
What is raw datatype in oracle?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
What is the database name in oracle?
Why required to run root.sh at the time of installation and what exactly it will do
What is a Synonym ?