Alex Poole

United Kingdom

stackexchange.com/users/98359

Age: 42

I've been picking up hints, tips and information from a variety of sources over the years, but somehow have always been a taker and not a giver. I'm finally getting involved and trying to give something back to the community. Still learning far more than contributing though.

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, doing work for a large UK telecoms provider. Production support, developer, part-time (a.k.a accidental) DBA in dev/test, analyst, consultant... whatever needs doing right now, generally. Mostly Oracle (since about 1995, versions 6 to 11g), Java, WebLogic, shell scripting, HTML, CSS, a bit of C when pushed, but whatever's needed today. Work is mostly on Oracle Linux, but dragged into Windows and networking issues fairly often, and a Mac user at home.

4h
answered ORA-02248 while trying to set NLS_CALENDAR from a PL/SQL procedure
4h
comment Possible Oracle Bug with "greater than 0" in where Clause
Possibly bug 18066615? You should probably raise a service request anyway...
4h
revised Is it possible to build a Oracle Function Based Index for a TIMESTAMP column cast as DATE within a view?
Added view modification
4h
comment Is it possible to build a Oracle Function Based Index for a TIMESTAMP column cast as DATE within a view?
@ORA-55378 - updated with a tweak to the view that might make this easier for the two tiers with competing requirements.
4h
revised Is it possible to build a Oracle Function Based Index for a TIMESTAMP column cast as DATE within a view?
Added view modification
5h
revised Is it possible to build a Oracle Function Based Index for a TIMESTAMP column cast as DATE within a view?
added 349 characters in body
6h
revised Is it possible to build a Oracle Function Based Index for a TIMESTAMP column cast as DATE within a view?
Corrected Jokke's name - sorry
6h
comment Oracle NLS lang issues
What data type is the column then, and that is the national character set? Is that dump of the original column value or after you've tried to convert it? varchar2 columns won't support data outside 7-bit ASCII - though it's possible to put unsupported values in - but nvarchar2 might. But you've made it sound like this is raw data, which would be strange.
6h
answered Is it possible to build a Oracle Function Based Index for a TIMESTAMP column cast as DATE within a view?
15h
answered Generating procedure logfile and inserting date time
20h
comment PL/SQL Creating Associative Array With Employee Id as Key
Why can't you index by PLS_INTEGER, for that matter. number(6,0) would fit within the valid range; what do you gain by restricting it further?.
23h
comment flyway init oracle insufficient privileges
The double-quotes are valid but might be affecting what you're doing. Is the actual value of MY_SCHEMA uppercase; or was the quoted value mixed or lower case perhaps? If mixed-case identifiers are quoted they have to exactly match all the time; so you should probably make all the values that are being automatically quoted uppercase in your script to avoid future pain.
1d
comment ORA-00936: missing expression bad SQL grammar
It does. So you would need to put each value from the list in one by one, separated by commas, in a loop; or preferably change the procedure to take a nested table argument and pass in an ARRAY based on that SQL type.
1d
answered Oracle Apex - Duplicated VM and now not working
1d
comment Oracle Apex - Duplicated VM and now not working
You can't reload the listener if it isn't running. Did you do lsnrctl start after changing the address in the listener.ora?
1d
comment Oracle Apex - Duplicated VM and now not working
So... your listener isn't running? Looks like you haven't updated the listener.ora and it's still trying to bind to the prod servers IP address, not your VM's IP address?
1d
revised SQL DUMP missing information in a column
Expanded a bit
1d
comment SQL DUMP missing information in a column
Hmm, are you sure it was done like that, not with the new much-faster mechanism?
1d
answered SQL DUMP missing information in a column
1d
comment SQL DUMP missing information in a column
Was the column, with its default value and not-null constraint, added on database A when the table was partially filled? Looks like a fast-column-add scenario...
1 2 3 4 5