Viewing 15 posts - 916 through 930 (of 3,060 total)
stewartc-708166 (7/12/2011)
Regrettably one cannot do a split in the middle.You can only MERGE from the left and SPLIT on the right (i.e. latest).
mmmhh... are you totallly 100% sure about this?
I...
_____________________________________
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 12, 2011 at 6:14 am
oussama.dinia (7/12/2011)
Our orders table has grown to 12+ million records, growing at 5000...
_____________________________________
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 12, 2011 at 6:05 am
narain337 (7/11/2011)
Kindly give an example of a real business situation where neither a star nor a snowflake schema can be used to represent that data.
Firstly, a snowflake "schema" is nothing...
_____________________________________
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 11, 2011 at 5:45 am
Bruce W Cassidy (7/8/2011)
PaulB-TheOneAndOnly (7/8/2011)
Correct but, a REF CURSOR is not a parameter - it's a reference to a specific memory location.
... the point being that it's how you pass...
_____________________________________
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, 2011 at 3:29 pm
MR-216760 (4/23/2011)
_____________________________________
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 8, 2011 at 1:18 pm
am-244616 (7/8/2011)
_____________________________________
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 8, 2011 at 12:38 pm
stefan.mueller 34873 (7/8/2011)
Now i want to delete in some tables all the data which is older than 3 Years.
If i set the Database...
_____________________________________
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 8, 2011 at 11:54 am
ravi01031986 (7/8/2011)
_____________________________________
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 8, 2011 at 11:43 am
michael.french 172 (6/30/2011)
My plan is to load the data one partition at a time by loading a staging table and then merging...
_____________________________________
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 8, 2011 at 6:47 am
Bruce W Cassidy (7/6/2011)
Also I'm not sure the degree symbol fits into the 7-bit ASCII character set:NLS_CHARACTERSET= US7ASCII
That's why configuration also includes alternative "National" Character Set set to AL16UTF16...
NLS_NCHAR_CHARACTERSET= AL16UTF16
_____________________________________
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 8, 2011 at 6:41 am
Bruce W Cassidy (7/6/2011)
ssc_san (6/24/2011)
Thanks for the reply Paul.Any specific reason, is it because of the difference in their architecture?
Thanks.
SQL Server stored procedures can return result sets directly. 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 8, 2011 at 6:38 am
keymoo (7/4/2011)
Out of curiosity, may I ask why BondInstrument table was detached from Intrument table? blame it to my ocd but I have problems digesting 1:1 relationships 🙂
Because...
_____________________________________
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 5, 2011 at 5:38 am
Oliiii (7/4/2011)
In this case i depend on the size of the company.
If you have a small company with few devs, then they can own...
_____________________________________
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 5, 2011 at 5:28 am
Jeff Moden (7/3/2011)
PaulB-TheOneAndOnly (7/3/2011)
Onwership of the data does not equates with ability to manipulate the...
_____________________________________
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 4, 2011 at 7:12 am
I assume that if a single dependency is missing you want the dependency-check to fail, is that correct?
If that's the case I would join the ten tables by that "FK"...
_____________________________________
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 4, 2011 at 7:01 am
Viewing 15 posts - 916 through 930 (of 3,060 total)