Viewing 15 posts - 2,716 through 2,730 (of 3,060 total)
Sudiendra (2/12/2009)
SELECT O.name AS , O.name AS [Index Name],
I.rowmodctr AS [Rows...
_____________________________________
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.February 13, 2009 at 2:26 am
Assuming you are talking about converting Oracle "SQL*Loader control files" into something SQL Server would understand to help you run ETL processes... as far as I know, No.
You are...
_____________________________________
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.February 12, 2009 at 10:53 am
Is that the old-n-good example taken from BOL -AdventureWorks?
Your answers are: Yes, Yes.
_____________________________________
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.February 12, 2009 at 10:48 am
... and here is when you are going to find out how serious is the IT operation in your Company, go and ask for documentation.
Just tell us which face better...
_____________________________________
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.February 12, 2009 at 4:42 am
GUI and related tools are nice to have features yet I script everything.
All changes applied to production MUST be scripted not done on a GUI therefore and since you have...
_____________________________________
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.February 12, 2009 at 2:10 am
rockingadmin (2/11/2009)
using this query i can able to see the tables of that user.
select *
from dba_tables
where owner = 'ACCOUNT"
;
but i try to get the data using...
_____________________________________
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.February 11, 2009 at 3:52 am
rameshnkl (2/11/2009)
Sorry. Actually i mean, 'Master' is a example database name.No probs. Take my database name is 'Something'.
Got it. You may want to check this http://www.mssqltips.com/tip.asp?tip=1620
_____________________________________
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.February 11, 2009 at 2:45 am
rameshnkl (2/10/2009)
I have a Database with the name of 'Master'.
:w00t: Shall we understand you manage to create a "master" database in your SQL Server environment or happens that you have...
_____________________________________
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.February 11, 2009 at 1:24 am
rockingadmin (2/10/2009)
i have checked the user. i can see the data in that user. but the problem is i cant able to use a query
how can i see that...
_____________________________________
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.February 10, 2009 at 11:29 am
guptaajay1985 (2/10/2009)
How to script the constraints?
Have you scripted your tables?
Look closely, constraints are there.
_____________________________________
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.February 10, 2009 at 5:22 am
guptaajay1985 (2/10/2009)
How the data willl come in tables in other DB,if we only script and create the tables in other DB.Thx
It doesn't. You have to move the data.
_____________________________________
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.February 10, 2009 at 5:16 am
rockingadmin (2/10/2009)
I had sucessfully migrated(tables with data) from sqlserver2005 to oralce10g. now i am getting the error.
in oracle10g,after executing the below query::
>>select count(*) from policy;
ERROR at line...
_____________________________________
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.February 10, 2009 at 5:14 am
rockingadmin (2/10/2009)
I had sucessfully migrated(tables with data) from sqlserver2005 to oralce10g. now i am getting the error.
in oracle10g,after executing the below query::
>>select count(*) from policy;
ERROR at line 1:
ORA-00942: table...
_____________________________________
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.February 10, 2009 at 5:12 am
I would script the constraints then apply the script.
_____________________________________
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.February 10, 2009 at 4:11 am
Bruce W Cassidy (2/9/2009)Try creating an index on a bit field in SQL Server 2005. Yes, it works.
Unfortunatelly that's not the concept of an Oracle bitmap index 😀
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.February 10, 2009 at 4:07 am
Viewing 15 posts - 2,716 through 2,730 (of 3,060 total)