Viewing 15 posts - 2,476 through 2,490 (of 3,060 total)
:w00t: wow! Thank you for sharing. Very good catch, congrats.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 10, 2009 at 11:36 am
sqlbuddy123 (7/10/2009)
your detailed reply
And the credit goes to... Oracle's oerr utility 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 10, 2009 at 11:33 am
Yes you can.
All you need is Oracle's Transparent Gateway for Microsoft SQL Server and some time to read and test. 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 9, 2009 at 3:38 pm
12154, 00000, "TNS:could not resolve the connect identifier specified"
// *Cause: A connection to a database or other service was requested using
// a connect identifier, and the connect identifier specified...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 9, 2009 at 3:24 pm
May it's better not to use such index
What's the size of the offending table?
What kind of process against the offending table? e.g. scan or lookup?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 9, 2009 at 10:38 am
mahesh.vsp (7/7/2009)In a similar way what i tried was, created a database "testdb" inserted 100 rows and stop my sql server , deleted the .ldf of "testdb" and restarted my...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 7, 2009 at 4:31 pm
Michael Meierruth (7/7/2009)
There is also a charge to sign up to MetaLink via an Oracle support identifier. This is starting to get expensive.
:pinch: If you have a licensed Oracle...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 7, 2009 at 7:30 am
May I ask why are you using surrogate keys instead of natural keys?
Having the opportunity of seeing the original data wouldn't hurt either.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 6, 2009 at 3:41 pm
molson (7/6/2009)
I'm shocked and appalled some people have a total disregard for Referential Integrity.
Sometimes a DBA's gotta do what a DBA's gotta do...
:blink: do you mean... trash referential integrity? 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 6, 2009 at 1:42 pm
Most of the answer depends of the kind of reporting business is asking for.
A broad answer for the posted -broad - question would be: a table with indexes designed to...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 6, 2009 at 9:48 am
suresh0123456789 (7/1/2009)Is there any way to delete records without dropping FKs
Yes, doing it the right way -please refer to Gail's post.
I'm shocked and appalled some people have a total disregard...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 3, 2009 at 6:37 am
s007reddy (7/2/2009)
When you move Dev database to PROD server ....
Lovely 😀
Post pretty much rubber stamps a big approval on this; that's wrong -it might lead inexperienced people to believe this...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 3, 2009 at 6:28 am
Can you afford a down time?
1- Pre create all databases in new location.
2- Take a final full backup and put it on an external disk drive
3- Ship the external disk...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 2, 2009 at 1:13 pm
ramyours2003 (7/2/2009)
what precautions to be taken while restoring the database from development to production?
:w00t: A signed job offer letter from other employer would easy the pain. 😀
Is the plan...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 2, 2009 at 12:17 pm
There are three ways to get started, they are: formal training, self training and on-the-job training.
1) Formal training, you know what I mean.
2) Go to http://www.oracle.com, download Oracle sofware, install...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 25, 2009 at 10:59 am
Viewing 15 posts - 2,476 through 2,490 (of 3,060 total)