Viewing 15 posts - 811 through 825 (of 2,064 total)
Almost certain, AL32UTF8 is an unicode characterset. All char/varchar2/... columns can now store unicode characters. You can consider them nchar/nvarchar... by now.
WE8ISO8859P1 is non-unicode.
Because not all characters from AL32UTF8 can...
August 14, 2012 at 10:00 pm
Unlikely that the move to 64-bit triggers cannot convert between non-unicode to unicode.
Did you change the nls_characterset of your oracle database whilst migrating from 9 to 11?
The oracle client on...
August 14, 2012 at 4:50 pm
Have a search on fetch on this forum. The oracle default fetchsize is around 200.
August 13, 2012 at 11:44 am
What do you get if you use the Oracle OLEDB drivers for oracle?
August 12, 2012 at 11:36 pm
Glad you sniffed it out.
August 9, 2012 at 1:57 pm
Check if you have still remains of oracle software (check registry local machine\software\oracle). If I'm not mistaken the .1 points at home1.
Install 64-bit first (full administrator) and then 32-bit in...
August 9, 2012 at 1:38 pm
August 9, 2012 at 12:47 pm
Smallint can be used to store 0 or 1, but isn't supported in Oracle (has number datatype).
August 8, 2012 at 8:59 am
You'll have to specify nogrowth for the datafile like (no autoextend clause)
Like
CREATE TEMPORARY TABLESPACE temp TEMPFILE 'd:\temp\tempfile1.dbf' SIZE 4096M ;
It pays to read the oracle concepts
August 4, 2012 at 3:41 am
Also check the power saving mode of the vm host(s). For reliable performance: high performance mode instead of balanced power saving
July 31, 2012 at 9:32 am
MSDAORA is an old driver for Oracle.
Try OracleOleDB or the Attunity drivers
July 6, 2012 at 11:57 am
Viewing 15 posts - 811 through 825 (of 2,064 total)