From 7d9c92a846bd7ac9a3e147a239775787604ff90f Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Thu, 24 Sep 2009 21:52:23 +0000
Subject: [PATCH] MDL-17491 oracle native driver: disable sequence cache before
 renaming, enable later

---
 lib/ddl/oracle_sql_generator.php | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/lib/ddl/oracle_sql_generator.php b/lib/ddl/oracle_sql_generator.php
index 8ec38c7dff..7b099f8e52 100644
--- a/lib/ddl/oracle_sql_generator.php
+++ b/lib/ddl/oracle_sql_generator.php
@@ -253,8 +253,11 @@ class oracle_sql_generator extends sql_generator {
         $oldseqname = $this->getSequenceFromDB($xmldb_table);
         $newseqname = $this->getNameForObject($newname, $xmldb_field->getName(), 'seq');
 
-    /// Rename de sequence
+    /// Rename de sequence, disablig CACHE before and enablig it later
+    /// to avoid consuming on rename
+        $results[] = 'ALTER SEQUENCE ' . $oldseqname . ' NOCACHE';
         $results[] = 'RENAME ' . $oldseqname . ' TO ' . $newseqname;
+        $results[] = 'ALTER SEQUENCE ' . $newseqname . ' CACHE';
 
         $oldtriggername = $this->getTriggerFromDB($xmldb_table);
         $newtriggername = $this->getNameForObject($newname, $xmldb_field->getName(), 'trg');
-- 
2.39.5