sorry I just fell out of my chair.
Now, you say "we take OS backup".
But it's not production and that's the way it should be.
You could be fired for one bad key stroke as a DBA, and that won't happen to a developer. "There are so many things in life that carry a health risk; drinking too much or eating the wrong food.
Model is wrong if you have to update primary key. Followup:it is typically impossible to enforce cross - object integrity in a trigger without using the LOCK TABLE command.
the global temporary table would never be embedded in the sql, no.
It's always wise to hide the primary key from the end user. it will use the TNSNAMES. For Venky's first question, I think you can try to find some information about "Virtual Private Database". 25 million premature deaths could be prevented, say the organisers of No Smoking Day, as one in two smokers die early.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
0 comments:
Post a Comment