meta user
network profile
| bio | website | stackexchange.com/users/98359 |
|---|---|---|
| location | United Kingdom | |
| age | 41 | |
| visits | member for | 2 years, 3 months |
| seen | 59 mins ago | |
| stats | profile views | 61 |
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.
|
Dec 19 |
comment |
More than 4000 chars gives string literal too long error on oracle Yes, but are you trying to pass more than 4000 chars as a string as the argument to the procedure call, or are you passing in a CLOB, or something else? Can you add the call to the question? |
|
Dec 19 |
comment |
More than 4000 chars gives string literal too long error on oracle How are you passing the value to the procedure? Are you sure it's the procedure that's failing, rather than the way you're calling it? |
|
Nov 18 |
comment |
User can't stop Oracle listener (TNS-01190) Changing permissions on an Oracle-installed binary, or messing with the installation at all unless under direction from Oracle Support, isn't generally a good idea. Apart from anything else, the binary might be relinked by a patch. I was thinking more of a setuid wrapper, possibly just restricted sudo. Just out of interest, what are you changing in the listener.ora? |
|
Nov 14 |
revised |
User can't stop Oracle listener (TNS-01190) Added note about deprecation |
|
Nov 14 |
comment |
User can't stop Oracle listener (TNS-01190) @Phil - it is supported (or was, it's deprecated from 11gR2), but I originally had a comment querying why you'd want to do this, which I removed because I'd worded it unintentionally harshly. Agree that the security implications need to be given serious thought, but that's true for everything of course... |
|
Nov 12 |
answered | User can't stop Oracle listener (TNS-01190) |
|
Oct 30 |
comment |
How to set an Oracle user's default schema? Yes - e.g. with dbms_session.is_role_enabled. If applications have different roles defined, this makes it easy to change the 'default' schema for each within the same trigger, without having to maintain a separate look-up mechanism which might have to span the applications. I prefer this over synonyms, especially public ones. |
|
Oct 30 |
comment |
How to set an Oracle user's default schema? You can make the database logon trigger role-based as well; though I guess that is technically taken from a table at some level. |
|
Oct 25 |
comment |
Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage” How are you accessing it - would be helpful to see the URL you're using, but are you specifying https? |
|
Oct 17 |
comment |
Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function? Hardly definitive, but this article says 'SQL Developer has extended pldoc into DB Doc', and the pldoc documentation seems to include the elements you've already found. Seems odd though that there doesn't seem to be any reference (or credit) to pldoc, so maybe it was just inspiration rather than included; and even odder than Oracle haven't documented the functionality at all. |
|
Oct 16 |
comment |
Tablespace and userid info @Haglis - that sounds odd, I'm not aware of any clients that would present headings when there's no data. Anyway, I think you should ask about finding and extracting this function as a new question, including the reference you got from the user DDL and any queries you ran with their output. |
|
Oct 15 |
comment |
Tablespace and userid info @Haglis - select owner, object_type, object_name from dba_objects where object_type = 'FUNCTION' and lower(object_name) = 'user_function' will show if the function exists, which schema owns it, and if you're using the wrong case. |
|
Oct 15 |
comment |
Tablespace and userid info @Haglis - you should be able to see it like this, but maybe it's in a different schema (which you can specify with the third parameter to get_ddl)? Can you see it in dba_objects? Also check you're using the right case for the function name. |
|
Oct 12 |
answered | Tablespace and userid info |
|
Sep 11 |
comment |
Would existing constraints and indexes applied to an old table, apply to a new table renamed like the old one after it's dropped? Unless the column you're changing is vital to the indexes or something similar, I'd think about adding a new column, setting/updating that from the old one, and when you're happy swap them over with a couple of alter table ... rename column ... commands, and at some point drop the original (now renamed) column. Seems slightly less messy than doing it at table level. |
|
Aug 29 |
comment |
Oracle 11g .DMP viewer Do you have NLS_LANG set? How did you receive the file - it's a binary format so it it possible it's been corrupted by an ASCI FTP or similar? Does running imp with show=y give you anything? |
|
Jul 24 |
comment |
Stuck with Oracle 9i Why are you learning on 9i - why not something slightly more modern, or at least supported? |
|
Jul 20 |
answered | Is it possible to do a datapump import with a different user than did the export? |
|
Jul 20 |
revised |
Is it possible to do a datapump import with a different user than did the export? Formatting |
|
Jul 20 |
suggested | suggested edit on Is it possible to do a datapump import with a different user than did the export? |
