Alex Poole

Derbyshire, United Kingdom

stackexchange.com/users/98359

Age: 43

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

12h
comment Return table from function in Oracle
No, I wouldn't create a function at all for this in Oracle; bonesist noted the same.
12h
comment Oracle instant client : ORA-28759: failure to open file
I haven't used this for a while; shouldn't the sqlnet.ora path include the wallet directory?
13h
comment Oracle instant client : ORA-28759: failure to open file
Right, so is your wallet directory there, and accessible, and contains wallet files?
13h
comment Oracle instant client : ORA-28759: failure to open file
Do you have a libneq11.so.1 that you can symlink to the same name without the .1? Not sure that is actually the problem here. The trace says "Wallet open failed with 28759", and references a file or directory a few lines before; does that exist? Maybe add your sqlnet.ora to the question, and if you have wallet files, check the permissions.
1d
comment Using ojdbc5.jar for Oracle 12c server
It isn't supported. Will it work? Maybe, you'd have to try it. Will it work reliably? Probably not. Why not use a later version?
1d
comment Install sql loader linux
It's sort of possible to add SQL*Loader to Instant Client, apparently - I haven't tried and am not advocating that. But you'd need the full client anyway; you can get that from the database installer, so you might as well just use that. Before you do, have you considered using external tables instead?
1d
comment Adding sql loader into 12g Instant-Client already installed
Why have you asked this again? If you don't get an answer you should improve your existing question, not ask a new one.
1d
comment What is the difference?
Could the data just have changed between the select and the delete? Is this reproducible?
1d
comment Create or replace a dump file failed in Oracle
Is the h1 handle valid and attached? Do you have read and write privs on the directory object? Presumably line 12 is the add_file call. Maybe seeing the whole exception stack (rather than catching it and turning the top of the stack into your own exception) would reveal something else. Or using dbms_datapump.get_status. (Example from OraFAQ)
1d
revised one query for many similar tables
added 306 characters in body
1d
comment one query for many similar tables
You'd probably need to build up a string that does a union/union all of all those tables, and then maybe open a ref cursor using that? Otherwise you have to select all those individual tables into something; which could be a collection or GTT I guess. Depends how the OP needs to use the result perhaps.
1d
answered one query for many similar tables
1d
revised Need help understanding why COUNT DISTINCT is returning an odd result
Added Fiddles and more explanation
1d
revised Need help understanding why COUNT DISTINCT is returning an odd result
added 183 characters in body
1d
revised Need help understanding why COUNT DISTINCT is returning an odd result
added 183 characters in body
1d
answered Need help understanding why COUNT DISTINCT is returning an odd result
1d
comment Oracle pl/sql forall: how to count actual number of inserted lines with tablespace full (1654) error
You actually have a variable called num which has value 10; you aren't using myarr.count and SQL%BULK_ROWCOUNT.count?
1d
comment ORACLE : Create table - Missing right parenthesis
@Majestic - user_objects doesn't have owner; you can get that from all_objects, but it is clearly yours. Do you just need to refresh the explorer view to see it? It still sounds like the table was created the first time and the error was from something else - even an earlier attempt with a typo you corrected; maybe you have feedback off and that confused you. We can't see what you see, unfortunately.
1d
comment Using DECODE on a parameter in WHERE clause will shortcircuit using the index?
Your interpretation is correct. The architect needs to justify what they are saying. If they are really claiming that using any function anywhere in the where clause prevents an index being used, you could point out that sysdate is a function, for example. Although Oracle treats it as a special case sometimes. (Not relevant, but your decode could be replaced with NVL(param_3, column_3); or you could use (parm_3 IS NULL OR column_3 = param_3) or similar).
1d
comment ORACLE : Create table - Missing right parenthesis
Then what else is in the script/worksheet - are you sure the error is coming from this statement?
1 2 3 4 5