Tag Info

New answers tagged

3

The syntax you are using is for a column-level constraint, so it can only apply to the column it is attached to... try naming your constraints at the table level instead (this also allows encourages you to give your constraints meaningful names instead of the terrible system defaults): CREATE TABLE dbo.Medicaments -- always use schema* ( MedicamentID INT ...


1

There are at least two tools which attempt to mitigate the pain on online shema modifications - both by big hitters in the MySQL world. One is pt-online-schema-change from Percona and the other is oak-online-alter-table from Shlomi Noach. Could depend on whether you're more at ease with perl (percona) or python (Noach). Needless to say, I urge you to test ...


1

After running some tests in an isolated environment it seems that Raj is right: the refresh background job that I saw while waiting for the DROP wasn't triggered by the DROP. As far as I can tell this was caused by the refresh settings provided during the creation of the mview. It seems that refresh start with trunc(sysdate) + 1/8 next sysdate + ...


1

No, it is not possible to modify only a part of a package. You have to replace the whole package or package body. If you don't have the current version of your code you can extract it from the database if you have the appropriate permissions. 1) You can read it from the ALL_SOURCE view. Many graphical client tools. sqldeveloper or similar client tools can ...


1

Don't. Keep all your package sources in a source control system. That way you can go back to a previous version if you need to.



Top 50 recent answers are included