log in   faq   users   badges

Welcome to Stack Exchange Area 51!

Gary thought you'd be interested in this proposed Q&A site. If you like the idea, you can click the "Follow" button below to track the progress of this proposal.

31
followers
Follow It!
Share This

Oracle Databases

Proposed Q&A site for oracle Database Administrators and Developers
flag
1  
How is this different from serverfault that covers the same topics? – Binoj Antony Jun 17 at 5:46
1  
Overlaps with the generalised yet database-specific 'Outer Join' - area51.stackexchange.com/proposals/4260/… – James Booker Jul 15 at 16:17
2  
I believe Oracle Databases is a broad enough topic to merit a separate site. A question asked on a site that is not database specific will get several "answers" that are perfectly valid for other databases, but do not answer the question or worse do not answer it correctly for the database it is intended for. Tagging does not solve this because it cannot prevent these often unhelpful answers. Of the 34 on-topic questions for Outer Join only half could be considered applicable to Oracle and of those only two would apply only to Oracle. – Leigh Riffel Jul 21 at 13:35
show 7 more comments

31 Example Questions

newest all votes on-topic off-topic
1 great on-topic example
10 great off-topic example
0 not a good example
Why is Oracle better than hadoop?
added by Niall Litchfield Jun 20 at 15:23
link|flag
0 great on-topic example
11 great off-topic example
1 not a good example
Does anyone have copies of the certification exam(s)
added by Gary Jun 22 at 0:36
link|flag
3  
Both cheating and copyright violations should be discourgaed – Gary Jun 22 at 0:37
9 great on-topic example
0 great off-topic example
0 not a good example
How do I make my query use the index that I created for it?
added by Niall Litchfield Jun 20 at 15:20
link|flag
8 great on-topic example
0 great off-topic example
0 not a good example
Can I install Oracle on Windows without being an administrator?
added by Leigh Riffel Jun 16 at 21:41
link|flag
8 great on-topic example
0 great off-topic example
0 not a good example
In SQL Server each table should have a clustered index. What is the equivalent in Oracle and how should I create it?
added by Niall Litchfield Jun 20 at 15:21
link|flag
5 great on-topic example
0 great off-topic example
0 not a good example
Oracle keeps running out of temp space. What gives?
added by Niall Litchfield Jun 20 at 15:22
link|flag
0 great on-topic example
5 great off-topic example
0 not a good example
My metalink password keeps getting rejected?
added by Jeffrey Kemp Jun 21 at 2:35
link|flag
0 great on-topic example
5 great off-topic example
4 not a good example
URGENT!!! Why is this query slow???
added by chenshap Jun 22 at 23:45
link|flag
1  
I hope its clear that questions with no details, lots of caps and the word "URGENT" are off-topic – chenshap Jun 22 at 23:46
1  
No, but if the FAQ says 'bad' there's legitimacy in the down-votes and closure votes (and the impact on the questioner's rep score). – Gary Jun 24 at 7:02
show 3 more comments
4 great on-topic example
0 great off-topic example
0 not a good example
Is there a way to allow a proxy connection to use passed authentication in a public database link?
added by Leigh Riffel Jun 16 at 21:40
link|flag
4 great on-topic example
0 great off-topic example
0 not a good example
System will have a user for tables and a user for the application. Should views/ stored procedures be under the apps user, data user or a third user?
added by Gary Jun 22 at 0:26
link|flag
1 great on-topic example
3 great off-topic example
1 not a good example
I have some PL/SQL code in my application that has been wrapped / obfuscated. Is there any way of unwrapping it ?
added by Gary Jun 22 at 0:28
link|flag
show 7 more comments
4 great on-topic example
0 great off-topic example
0 not a good example
How can I transpose the rows in my table to columns using SQL only?
added by Rob van Wijk Jun 28 at 6:56
link|flag
4 great on-topic example
0 great off-topic example
0 not a good example
I'm getting an ORA-04091 mutating table error. How can I circumvent it?
added by Rob van Wijk Jun 28 at 6:59
link|flag
3 great on-topic example
0 great off-topic example
0 not a good example
How do I determine how much undo my query should use.
added by Niall Litchfield Jun 20 at 15:26
link|flag
3 great on-topic example
0 great off-topic example
1 not a good example
What are the security implications of granting a CREATE ANY DIRECTORY to a user. If there is any risk, does anyone have any code to safely wrap it ?
added by Gary Jun 22 at 0:27
link|flag
show 2 more comments
3 great on-topic example
0 great off-topic example
0 not a good example
Is it true that streams will be replaced by Golden-Gate?
added by chenshap Jun 22 at 23:20
link|flag
3 great on-topic example
0 great off-topic example
0 not a good example
What are the pros and cons of changing this table from a regular heap table to an index organized table?
added by Rob van Wijk Jun 28 at 6:58
link|flag
show 1 more comment
3 great on-topic example
0 great off-topic example
0 not a good example
How can I decide whether it is right to rebuild an index?
added by Tareb Jun 29 at 6:44
link|flag
2 great on-topic example
0 great off-topic example
1 not a good example
Can SQL Plan Baselines be deleted in bulk?
added by Leigh Riffel Jun 16 at 21:38
link|flag
2 great on-topic example
0 great off-topic example
0 not a good example
Continue works like Exit in a cursor FOR loop?
added by Leigh Riffel Jun 16 at 21:40
link|flag
1 great on-topic example
1 great off-topic example
0 not a good example
Running RMAN's "validate backup" takes too much resources. Is it possible to run validate on a different server?
added by chenshap Jun 22 at 23:19
link|flag
show 1 more comment
2 great on-topic example
0 great off-topic example
0 not a good example
I created a dblink from Oracle to MySQL, but when I try to use it, it fails. How do I fix this?
added by chenshap Jun 22 at 23:26
link|flag
1  
The dblink makes it on topic, but it would be good to address whether "Oracle Databases" includes Oracle Lite, Berkely DB, TimesTen (as a standalone and/or a cache) and mySQL/InnoDB. – Gary Jun 23 at 6:00
1  
I hope that "Oracle Databases" in the name mean the product called "Oracle Database" and not "Any database owned by Oracle Corporation" – chenshap Jun 23 at 17:43
show 1 more comment
1 great on-topic example
1 great off-topic example
0 not a good example
We stopped using Oracle Designer. What alternatives are there for all the modellers and design tools?
added by Rob van Wijk Jun 28 at 7:03
link|flag
1 great on-topic example
1 great off-topic example
0 not a good example
Can APEX provide a stable and robust replacement for Enterprise wide applications?
added by Sumnibot Jun 30 at 15:27
link|flag
0 great on-topic example
2 great off-topic example
0 not a good example
How to handle transactions in a stateless .NET application using ODP.NET and a connection pool?
added by Kim Berg Hansen Jul 20 at 7:13
link|flag
1  
I would say myself that even if it's a question on ODP.NET, it wouldn't belong here. – Kim Berg Hansen Jul 20 at 7:14
1 great on-topic example
0 great off-topic example
0 not a good example
What is the equivalent of `sp_spaceused` (SQL Server) in Oracle ?
added by Vincent Malgrat Jun 24 at 14:53
link|flag
1  
If you can explain what you're trying to do. – William Robertson Jun 24 at 18:14
show 2 more comments
1 great on-topic example
0 great off-topic example
0 not a good example
I am using Oracle 10.2.0.5. Should I still use pragma restrict_references in my new packaged functions?
added by Rob van Wijk Jun 28 at 6:57
link|flag
0 great on-topic example
0 great off-topic example
2 not a good example
Can a Wallet be used in SQL Developer?
added by Leigh Riffel Jun 16 at 21:37
link|flag
1  
just wondering: why is this not a good example? – Jeffrey Kemp Jun 22 at 1:05
1  
Actually, I think its a good example. Are questions about tools on topic or off-topic for this community? – chenshap Jun 22 at 23:43
1  
Given SQL Developer is installed along with 11g, I think it qualifies as 'part' of Oracle in the same way as RMAN or sqlplus (and, I suggest, Apex). Third-party tools (paid for or free) are more arguable. I've adapted my ER diagrammer question so that it can (also) be used to gauge opinion on what people want to be in.out of scope. – Gary Jun 23 at 5:48
show 3 more comments
0 great on-topic example
0 great off-topic example
0 not a good example
What does the extra cost SQL Developer Data Modeller offer to justify the expense over other tools for Entity Modelling
added by Gary Jun 22 at 0:26
link|flag
0 great on-topic example
0 great off-topic example
2 not a good example
Will SQL Developer replace Toad as a 'must have' tool for DBAs and Developers?
added by Sumnibot Jun 30 at 15:21
link|flag
show 2 more comments
1 2 next

Log in or register to propose your own example question!

This proposal is in:

Definition

The topic and audience are still being decided. It needs:

  • 29 followers
  • 5 on-topic questions
  • 5 off-topic questions

to move to the next phase.

proposed by

Leigh Riffel
2,127●8●56

2 months ago

viewed

365 times

latest activity

1 month ago

recent followers

added Jul 21 at 19:50
Vlado
51●2
added Jul 21 at 16:09
Tony Andrews
23k●1●14●47
added Jul 20 at 6:49
Kim Berg Hansen
61●3
added Jul 8 at 10:52
efitskie
51●1
added Jul 6 at 21:08
user8455
51●1
added Jul 5 at 19:45
APC
23k●4●9●45
added Jul 2 at 14:13
ggponti
214●1●14
added Jul 2 at 13:00
Tommi
826●1●8
added Jun 30 at 21:52
thursdaysgeek
2,921●1●8●64
added Jun 30 at 15:18
Sumnibot
57●2
added Jun 29 at 6:55
Tareb
66●2
added Jun 25 at 21:29
The MYYN
18k●1●11●64
added Jun 24 at 20:48
Lior Sion
51●1
added Jun 24 at 14:19
user6059
51●1
added Jun 24 at 12:47
Vincent Malgrat
13k●1●6●27
added Jun 24 at 6:09
Hewy
51●1
added Jun 22 at 23:05
chenshap
221●10
added Jun 21 at 18:18
William Robertson
52●2
added Jun 21 at 4:41
John Seaman
51●1
added Jun 21 at 2:31
Jeffrey Kemp
6,082●4●27
added Jun 20 at 18:53
Randolf Geist
51●1
added Jun 20 at 18:26
Tony
51●1
added Jun 20 at 16:09
user4092
51●1
added Jun 20 at 15:27
Niall Litchfield
331●5
added Jun 20 at 11:11
Rob van Wijk
3,136●2●14
added Jun 18 at 14:10
user3553
51●1
added Jun 18 at 13:37
user3541
51●1
added Jun 18 at 9:57
Timur Akhmadeev
52●1
added Jun 18 at 6:02
Gary
12k●8●50
added Jun 17 at 8:01
Nick Pierpoint
3,784●1●13●64
added Jun 16 at 21:36
Leigh Riffel
2,127●8●56
feed icon proposal feed
faq | blog | legal | contact us | feedback always welcome
site design and logo © 2010 stack overflow internet services, inc.; user contributed content licensed under cc-wiki with attribution required