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
- 5799 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 |
What is currency type in database ?
Can you tell me how to add new column in existing views?how?How is possible?
How to set up autotrace for a user account?
where we have to use ON clause and where we have to use USING clause in JOINS
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is Hash Cluster ?
what are views?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What are the ways tablespaces can be managed and how do they differ?
Oracle General 
