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
- 2105 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to write a left outer join with the where clause in oracle?
How to use values from other tables in update statements using oracle?
How to select all columns of all rows from a table in oracle?
Design database draw er diagram for a certain scenario ?
How to start an oracle instance?
What is oracle latest version?
How to put more than 1000 values into an oracle in clause?
