meta user
network profile
| bio | website | stackexchange.com/users/98359 |
|---|---|---|
| location | United Kingdom | |
| age | 41 | |
| visits | member for | 2 years, 4 months |
| seen | 1 hour 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.
|
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? |
|
Jul 20 |
comment |
Is it possible to do a datapump import with a different user than did the export? Does the DUMP_DIR exist? Is it writable by the user you're running the impdp as? Does the log file already exist, and can you specify a different one on the command line? |
|
Jul 13 |
comment |
steps for creating a domain in web logic server 10.3.5 What has Forms got to do with WebLogic Server? |
|
Jul 13 |
comment |
steps for creating a domain in web logic server 10.3.5 Thses are questions only you can answer based on you requirements. If there was a single answer it wouldn't need configuration. The documentation should help you understand what the options mean, and hopefully guide you to what's appropriate for your needs. |
|
Jun 21 |
comment |
log 1 sequence# not archived, no available destinations Are you removing archived log files once they have been backed up (possibly multiple times)? If not then you'll eventually run out of space however much you allocate. |
|
Jun 20 |
comment |
Encoding problems with sqlplus, Linux Are the table columns defined as varchar2 or nvarchar2, and if the latter, what's your national character set (NLS_NCHAR_CHARACTERSET in nls_database_parameters)? |
|
Jun 20 |
comment |
In Oracle how do you move a Schema to a different Tablespace? Having seperate tablespaces for tables and indexes isn't really considered neccessary for performance, though it can still be done for admin reasons. See this old SO thread, or various AskTom articles. |
|
Jun 19 |
comment |
Oracle: How to create a not null column in a view Based on the SO thread, that isn't quite the issue; he has a cast column in the view, and the metadata doesn't show that it is not null. He knows it can't be null but he needs entity framework to know, apparently based on metadata. |
|
Jun 19 |
awarded | Citizen Patrol |
|
Jun 10 |
comment |
ARCHIVELOG mode This answer might help, and will point you to related docs. |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
|
May 21 |
awarded | Fanatic |
|
May 9 |
answered | Truncate parent table in Oracle when child table is empty |
|
May 2 |
comment |
SQL*Plus, @, and relative paths Same behaviour under Linux, FWIW. (And an ampersand is &, not @; which doesn't seem to have a real name). Seems to be bug, since it's inconsistent. Only thing that comes to mind is to set a variable it the top level script with the full path and do everything based on that, but that's not very convenient unless the directory structure below that is fixed. |
|
Apr 22 |
comment |
Listener failed to start 'No message file' often indicates that your ORACLE_HOME isn't set correctly - either not at all, or pointing to a different installation than the binary you're running from your PATH. Can you check and post the Oracle-related environment? |
|
Mar 29 |
answered | How do I recreate a deleted logfile on an Oracle database? |
|
Mar 29 |
answered | How do oracle date time work? |
|
Mar 26 |
answered | export SQL statements from Oracle 11g database via command line |
