Viewing 15 posts - 1,096 through 1,110 (of 3,060 total)
green8814 (3/4/2011)
2) Make sure the tnsnames.ora file is configured properly on the server that needs to connect to Oracle.
Actually, if you are tnspinging from a client you have to make...
_____________________________________
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.April 29, 2011 at 1:46 pm
sherwincurt (4/18/2011)
We have Oracle installed on Server.
There are 2 OS running in the 2 network lines namely XP,and Linux.
Is it possible to access Oracle form both the OS ?...
_____________________________________
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.April 29, 2011 at 1:27 pm
Welsh Corgi (4/28/2011)A Procedure would In include DECLARE PROCEDURE MyProc
I'm sure you mean "create or replace procedure MyProc as..."
Having said that, script I shared earlier runs in sqlplus as...
_____________________________________
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.April 29, 2011 at 10:59 am
Building on Welsh's post, block on sqlplus should look like..
set serverout on
declare mydate date;
begin
select max(CreateDate) into mydate from tbl1;
-- do whateve you have to do with variable mydate --
end;
/
Please note,...
_____________________________________
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.April 28, 2011 at 2:26 pm
Welcome to the wonderful world of data modeling.
The short answer is: there is not silver bullet, it all depends on your business requirements and the way you decide to implement...
_____________________________________
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.April 26, 2011 at 4:40 pm
RonKyle (4/19/2011)
* leave them NULL (could cause issues in reports)
I don't recommend this. All dimension keys should have some value. Implement the third suggestion in the above post....
_____________________________________
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.April 26, 2011 at 1:46 pm
David Portas (4/26/2011)
Welsh Corgi (4/23/2011)
The definition of the following terms are as follows:
Data Warehouse: They use a Dimensial Data Model...
_____________________________________
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.April 26, 2011 at 1:26 pm
Most likelly a privileges issue.
Log as "sa" and re-run query, if it returns what you expect the concentrate on assigned and missing privileges.
_____________________________________
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.April 26, 2011 at 8:24 am
Well... post title appears to have no relationship with actual issue - is that correct?
Usually the devil is in the details, in this case appears to be in the filtering...
_____________________________________
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.April 24, 2011 at 3:57 pm
SethT3 (3/11/2010)
The database was an Oracle database converted to SQL Server
It appears to be the case of a half-cooked conversion - nothing more, nothing less.
_____________________________________
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.April 24, 2011 at 3:36 pm
Satnam Singh (4/24/2011)
Also what are the pre-requisites for the same, i believe seperate...
_____________________________________
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.April 24, 2011 at 1:37 pm
sherwincurt (4/21/2011)
Hello can any one tell me waht is mean by Dataware House, Data mining and OLAP?
Fully answering this question may require not least than the full content of four...
_____________________________________
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.April 23, 2011 at 5:24 pm
Welsh Corgi (4/23/2011)
As far as I know two Phase locking does not exist in SQL Server but it does exist in Oracle.
2PL is actually just a conceptual description of 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.April 23, 2011 at 5:09 pm
nirav.gandhi 50053 (4/23/2011)
Which Conditions File And FileGroup are Useful for Our database Optimizations?
It would also be nice to know what "optimizations" means in this particular scenario - assuming poster wants...
_____________________________________
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.April 23, 2011 at 4:54 pm
Deeps-965988 (4/21/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.April 23, 2011 at 6:55 am
Viewing 15 posts - 1,096 through 1,110 (of 3,060 total)