Alex Poole

Derbyshire, United Kingdom

stackexchange.com/users/98359

Age: 44

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, working on switch activation software for a large UK telecoms provider.

Among other things I'm a support analyst, developer, part-time (a.k.a accidental) DBA in dev/test, requirements analyst, technical 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 and Pro*C when pushed, but whatever's needed today. Work is mostly on Oracle Linux now, but dragged into Windows and networking issues fairly often, and a Mac user at home (since about 1986).

I am, of course, #SOreadytohelp

21m
comment Querying oracle database patch history
Why have you deleted and re-asked this question? You haven't addressed the comments on the last one; as far as I can remember, why you think the comments column you have now is wrong, which circumstances you see a difference in, the raw view data when that happens. I also think I asked if you saw a problem on the base release and/or a DB that hadn't had a PSU apply since the last upgrade?
35m
comment Listener supports no service
Is your database actually running - can you connect locally through SQL*Plus? If so what is your local_listener initialisation parameter set to? And what IP address does hedge-pc resolve to?
8h
comment Can select using dblink, cannot insert using dblink
@I_am_Batman - I've OK'd your edit to match your question edit, but your names seemed pretty obscure already. It might be helpful for someone else seeing the same issue to see that it might be possible to rewrite a query to avoid the error, even if the specifis of your query are not relevant.
8h
reviewed Approve suggested edit on Can select using dblink, cannot insert using dblink
1d
revised Is it possible to define my own exit codes in an Oracle Stored Procedure?
added 303 characters in body
1d
answered Is it possible to define my own exit codes in an Oracle Stored Procedure?
1d
comment Is it possible to define my own exit codes in an Oracle Stored Procedure?
What are you doing with exit_code - is that a local variable, or an OUT parameter?
2d
comment Aggregating several columns in oracle sql
@DanielPaczuskiBak - the unpivot clause is using the month and year, as in the date '2016-01-01' value. That means the month value it's grouping on is that same date, including the year. If your data spans a year you'd current see two rows for 'JAN' (or some months anyway). So I think all you need to do is change the first line to select to_char(month, 'MON YYYY', ... or however you want to display the year and month together.
2d
answered Trying to load timezone data using sql loader
2d
revised ORA-00932 inconsistent datatypes from collect call
added 208 characters in body; edited tags
2d
revised ORA-00932 inconsistent datatypes from collect call
added 753 characters in body
2d
answered ORA-00932 inconsistent datatypes from collect call
2d
answered Possible to add multiple columns together and Alias in PL/SQL?
2d
comment Dump import stops and no error message
You can read more about redo logs if you're interested.
2d
comment Dump import stops and no error message
There are few things they could look at, they will probably have a preference about the best way to prevent the problem in your environment. They will recognise the error and know what it means. Or they may tell you to just be patient if it's clearing itself after a while, of course, in which case the feedback dots might be useful.
2d
answered Dump import stops and no error message
2d
comment Huge Data Base in oracle
If it's just appearing to do nothing - no error but doesn't return - maybe you have uncommitted changes in another session? Otherwise you'll need to provide a lot more information to get any useful help.
2d
comment What are the advantages of using precision for NUMBER data format in ORACLE?
@a_horse_with_no_name - not sure what you mean; an unconstrained number can hold decimals? (Or with default precision and scale if you prefer, but then in those terms you can't have a number without both).
2d
comment What are the advantages of using precision for NUMBER data format in ORACLE?
I think you're approaching this from the wrong angle. You should use the appropriate data type (including constraints, which is what the scale and provision provide) for the data you will store.
2d
comment Error in oracle sql devloper Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
Your listener isn't running then. Have you done lsnrctl start? And is your database up?
1 2 3 4 5