Back to basics...
"I want to drop the partitions however I dont want to rebuild the local indexes. I have enforced referential integrity on tables.. How can I achive this?"
1. Use deferrable FK constraints
2. disable the constraints before dropping partitions
3. Enable constraint with 'NOVALIDATE' clause after dropping partitions.
But what if I have indexes on FK constraints?
You can use 'KEEP INDEX' caluse at the time of disabling the constraints.
skip to main |
skip to sidebar
The intention for this blog is to provide a forum to exchange information, ideas and expertise about relational database and application development products from Oracle. My goal is to provide a professional environment to share this knowledge and experience with individuals from around the world.
About Me
- Jignesh Kariya
- I have worked on different DSS and OLTP systems. The databases have ranged in size from a tiny 50 Mb to more than 3 Tb with transaction rates from 100 per day up to 80 million per day.
Blog Archive
Posts
1 comment:
Path Infotech is in the field of oracle training program from past several years.
For more info : Ocp Certification in Noida
Post a Comment