1 - In DB2, the following pseudocode doesn't work:
define cursor
open cursor
while (not end of cursor)
make table update
commit;
end-while
close cursor
The reason? The "commit;" statement closes your cursor! you'll have to commit after exiting your loop.
2 - In SQL Server, you can end up with a database that has no owner. (!)
To correct this, us the sp_changedbowner system stored procedure.
example: sp_changedbowner 'sa'
A more thorough treatment of this topic can be found here.
Crazy ...
Subscribe to:
Post Comments (Atom)
DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)
I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
I spent a lot of time on this one, and it wasn't clear from examples precisely how the various items should be used together. The form...
-
I was not able to find what I considered a good, clear reference for this when I recently encountered it at a customer installation. I fou...
No comments:
Post a Comment