Viewing 15 posts - 751 through 765 (of 3,060 total)
Long shot? Try this syntax on your openquery...
select * from Openquery([MyOracleDatabase],'select DateCol, to_number(to_char(Col1)) "COL1",to_number(to_char(Col2)) "COL2" from myOracleTable)'
Above mentioned syntax works fine when issuing the select statement directly to 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.November 16, 2011 at 2:59 pm
TheSQLGuru (11/9/2011)
PaulB-TheOneAndOnly (11/8/2011)
TheSQLGuru (10/3/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.November 16, 2011 at 1:56 pm
Michael.Gagne (11/10/2011)
TableA
DateCol...
_____________________________________
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.November 16, 2011 at 1:49 pm
1- Confirm issue is related to the process or loading the flat files into the database.
2- Focus on the 3AM-5AM timeslot which appears to be the ETL window - everything...
_____________________________________
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.November 16, 2011 at 1:30 pm
logicinside22 (11/16/2011)
Transaction Log Backup - every 15 min or 30 min.
Differential backup -Every night
FUll backup - once in a week .
system backup - once in week or...
_____________________________________
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.November 16, 2011 at 1:20 pm
loki1049 (11/16/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.November 16, 2011 at 12:56 pm
shubham.saxena67 (11/15/2011)
I have found a tool names "SQL SERVER MIGRATION ASSITENCE FOR ORACLE" that completely resolved my problem.
Once again I'm in agreement with Lowell - SSMA is a fantastic tool...
_____________________________________
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.November 16, 2011 at 12:18 pm
geetha@in (11/15/2011)
I shall be thankful if anyone tel me how to migrate the data from 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.November 16, 2011 at 12:15 pm
RuanK (11/14/2011)
We've got a tablespace OZFX that's relatively full. If I try to extend specific datafiles I get the following...
_____________________________________
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.November 16, 2011 at 11:23 am
Any reason not to run the traditional query syntax on SQL Server side?
What happens if you do 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.November 16, 2011 at 11:19 am
shubham.saxena67 (11/12/2011)
I want to convert stored procedure that containg Loops ,Table valuedfunctions,Scalar Function written in Oracle to SQL Procedure and functions
Is there any tool ?
I'm in agreement with...
_____________________________________
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.November 14, 2011 at 5:54 am
GSquared (11/10/2011)
PaulB-TheOneAndOnly (11/9/2011)
GSquared (11/9/2011)
Restricted Session and Single-User aren't the same thing.mmmhh... are we still talking about Oracle here?
Sort of.
Good! because as far as I remember we only 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.November 11, 2011 at 11:21 am
drcrelao (11/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.November 9, 2011 at 12:57 pm
GSquared (11/9/2011)
Restricted Session and Single-User aren't the same thing.
mmmhh... are we still talking about Oracle here?
_____________________________________
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.November 9, 2011 at 12:43 pm
Nice one.
I would probably...
1- Parse the text string picking up every single word.
2- Assign a sequence number to every single word - I think a temp table would do it...
_____________________________________
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.November 8, 2011 at 3:11 pm
Viewing 15 posts - 751 through 765 (of 3,060 total)