meta user
network profile
| bio | website | stackexchange.com/users/98359 |
|---|---|---|
| location | United Kingdom | |
| age | 41 | |
| visits | member for | 2 years, 4 months |
| seen | yesterday | |
| 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.
|
Mar 22 |
comment |
Import Oracle full dump file to fresh Oracle installation Users and tablespaces don't have to be created first with a full export/import, unless you need to change something (as the OP does apparently, as the file paths have changed). |
|
Mar 22 |
comment |
Import Oracle full dump file to fresh Oracle installation The docs say users should be included, as you'd expect, so something doesn't sound right. Can you post the actual export command you used? (Although I'm not 100% sure the user creation would be in the indexfile, now I think about it; long time since I've had to think about it...) |
|
Mar 22 |
comment |
Import Oracle full dump file to fresh Oracle installation Which database user did you run the export as, and which database user are you running the import as? If you create an indexfile from the dump file, can you see statements to create the users and tablespaces? |
|
Mar 13 |
revised |
oracle 11g seems to die every 2 days, how can i debug what's happening? Updated beaded on alert log messages |
|
Mar 12 |
awarded | Enthusiast |
|
Mar 5 |
revised |
ORA-01034: ORACLE not available Corrected misinformation |
|
Mar 5 |
answered | What is this database dump format? |
|
Mar 5 |
answered | Oracle “Import from Export Files” screen refusing both SYSADMIN and Normal users |
|
Mar 4 |
revised |
ORA-01034: ORACLE not available edited body |
|
Mar 4 |
revised |
ORA-01034: ORACLE not available Added crsctl reference |
|
Mar 4 |
comment |
ORA-01034: ORACLE not available @tech_learner - hmm, haven't used it for a long time (and it's deprecated in 11gR2), but I thought the home argument was optional. Well, as long as you got there... |
|
Mar 4 |
answered | ORA-01034: ORACLE not available |
|
Mar 3 |
answered | oracle - does this have the potential to cause a lock? |
|
Mar 2 |
comment |
Temporary replication of data between continental datacenters The whole database, or a subset of tables? Is the replication one-way, so the remote site is read-only, or two_way? Have you looked at the options here? |
|
Feb 29 |
answered | oracle 11g seems to die every 2 days, how can i debug what's happening? |
|
Feb 27 |
answered | How to set up tns listeners for Multiple Oracle Installations on One machine |
|
Feb 23 |
answered | export data from oracle 10g |
|
Feb 21 |
awarded | Organizer |
|
Feb 21 |
revised |
Virtual Oracle server for education? Removed sql-server tag, fixed typos |
|
Feb 21 |
suggested | suggested edit on Virtual Oracle server for education? |
