Interested to Buy Any Domain ? << Click Here >> for more details...
what happened to the global index when I truncate the data
in one of the partition?
- 1 Answers
- 2104 Views
- I also Faced
- E-Mail Answers
Answer / Neelambuj Kumar Shrivastava
Truncating a table with a global index will remove all rows from the table and partition, but it will not affect the global index. The global index still points to the empty table or partition, and if you try to use it, Oracle will return an error. To work around this issue, you can rebuild or recreate the global index after truncating the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
How to use an explicit cursor without open statements?
Explain an integrity constrains?
In what script is snap$ created? In what script is the scott/tiger schema created?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is SAVE POINT ?
How to define an external table with a text file?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How can you Enforce Referential Integrity in snapshots ?
Explain the difference between sql and oracle?
What is an oracle data file?
WHT ARE THE AGGREATE FUNCTIONS?
Oracle General 
