Text box

Please note that the problems that i face may not be the same that exist on your environment so please test before applying the same steps i followed to solve the problem .

Sunday 13 April 2014

Truncate table CASCADE is now avilable in 12c


Starting from 12c you can now truncate the table and all the tables referring to that table with referential integrity.
This new feature is only available in 12c. This new enhancement gets ride of the limitation existed in earlier releases.Starting from 12c you dont need to delete child tables before you delete the master table as you can now do it in one command as per below:


SQL> TRUNCATE TABLE mytable CASCADE;