Alex Poole

United Kingdom

stackexchange.com/users/98359

Age: 43

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.

Mar
21
answered Oracle : Error at line 28: PLS-00103: Encountered the symbol “end-of-file”
Mar
20
comment ExtractValue from Oracle CLOB returning null
@IanCarpenter - I didn't have time to get it working; I was having trouble with the namespaces. I had intended to say to it was deprecated, and use an XMLQuery and/or XMLTable version, but forgot to add that. (Did you mean to link back to this answer?)
Mar
20
awarded Reviewer
Mar
20
comment Why does using "where rownum = 1" not select the first ordered row?
Where are you putting that extra line? Inside or outside the CTE?
Mar
20
reviewed Leave Open SQL Oracle: how to sort patient transfer data
Mar
20
comment Using Oracle IMP gives the error IMP-00058
If you aren't connecting as SINV (i.e. <schema> is something else) then you're doing at least a fromuser/touser import, I think, so that privilege is still needed. Seeing the full command you're using, and one that's previously worked, might help. I'm rusty on legacy imp, life is easier with impdp *8-)
Mar
20
reviewed Close SQL - cannot compile body of <package> without its specification
Mar
20
reviewed Close How to restore 11gR2 fullbackup to 12c database in rman
Mar
20
reviewed Close odbc - oci8 installation on pre existing apache-php installation
Mar
20
reviewed Close SQL self join and count
Mar
20
reviewed Close rman script with parameters
Mar
20
reviewed Close I want to install php oci8 extension on my MAC, but there is an error when I enter my instant client paht
Mar
20
reviewed Leave Open oracle does not display output - anonymous block completed
Mar
20
reviewed Leave Open Query throwing error; "column ambiguously defined"
Mar
20
reviewed Leave Open Oracle DBD Error from Perl script
Mar
20
comment Using Oracle IMP gives the error IMP-00058
Sorry, I missed that was was prompting for username; so that user can't even connect properly. Can you connect to that user/pass@tns with SQL*Plus? Are you trying to connect as a privileged user maybe?
Mar
20
comment Using Oracle IMP gives the error IMP-00058
You were successful before connecting as the same user? Is this a full dump (which needs imp_full_database) while previous ones were schema/table dumps, perhaps?
Mar
20
answered ExtractValue from Oracle CLOB returning null
Mar
20
answered Increase SQL loop time?
Mar
20
comment Increase SQL loop time?
Shouldn't you be setting v_start before the loop?
1 2 3 4 5