Explain the statement?? ALTER TABLE TABLE_NAME MOVE;
What it the use of above statement??
- 1 Answers
- 5455 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 the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Explain a data segment?
What is the database name in oracle?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
How to specify default values in insert statement using oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
What are the set operators union, union all, minus & intersect meant to do?
How to call a stored function with parameters?
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
Explain about integrity constraint?
What are group functions in oracle?
Oracle General 
