Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 30234

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

1 vote
0 answers
59 views

is there a DB client which supports oracle editions?

We are using a clever feature or oracle 11gr2 called edition-based redefinitions. This means each stored proc and view looks different depending on the edition you set in the session. …
mdarwin's user avatar
  • 135
1 vote
0 answers
1k views

Oracle - can't drop an editioning view

I have an Oracle 11gr2 DB, and I have created an editioning view called TEST which I'd now like to drop. …
mdarwin's user avatar
  • 135
0 votes
1 answer
840 views

oracle XE on windows XP stopped working

I know this will be greeted with derision, but yes I'm running Oracle XE on Windows XP. Long story involving office policies and VMs. … the log and found this: Fatal NI connect error 12638, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.2.0 - Production Oracle
mdarwin's user avatar
  • 135
1 vote

oracle XE on windows XP stopped working

I ran the 'repair oracle installation' option from the setup.exe file which I used to install oracle in the first place. So far, I've not had a recurrence and this seems to have fixed the problem. …
mdarwin's user avatar
  • 135
0 votes
1 answer
2k views

how do I work out why my stored procedure won't compile?

I have a stored procedure whose sql file is nearly 6000 lines in length. It's part of a series of DB build scripts which are used in lots of environments to build a standard DB setup. When I attempt …
mdarwin's user avatar
  • 135