Questions tagged [oracle]
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.
7,810
questions
3
votes
1
answer
2k
views
Is there a way to allow a proxy connection to use passed authentication in a public database link?
I think the answer to this is no, but I could be wrong. If nothing else it might be nice for others to be aware of this limitation of proxy connections.
- 23.9k
13
votes
2
answers
8k
views
Can Oracle be installed on Windows without being an administrator?
Can the oracle software be installed on windows without having administrator privileges?
- 23.9k
11
votes
3
answers
3k
views
Database backups in Oracle - Export the database or use other tools?
One of the "practices" that I've seen about being performed by DBA's in my organization is to treat a full database export using tools like exp / expdp as backup.
Would this be a good practice ? What ...
- 1,534
7
votes
1
answer
445
views
Oracle Support Tips & Tricks
How can My Oracle Support (Metalink) be used effectively?
What are your secret hints to this system? What saved you the most time?
- 1,356
13
votes
2
answers
30k
views
ORDER BY using custom priorities for text columns
This is a sample table:
name | cat
----------
hugo | sal
bob | mgr
mike | dev
jeff | mgr
john | dev
Both name and cat being Varchar.
cat reflects a category for these names, but I like to assign a ...
- 1,356
21
votes
14
answers
7k
views
Comfortable sqlplus interface? [closed]
I found sqlplus'interface is rather outdated. It's quite nice to have some commands or keywords at disposal, but for example no "arrow-up" key for the previous history entry is available.
What is a ...
- 1,356
27
votes
4
answers
131k
views
How to find the latest SQL statements within the database?
I like to get the latest executed statements within my database, along with performance indicators.
As such, I like to know, which SQL statements were most CPU/DISK intensive.
- 1,356
7
votes
1
answer
8k
views
How can I query names using regular expressions?
How could I search for a specific pattern in a column?
For example, I like to get all user names that start with either letter A or B.
(btw: this is tagged oracle, but it might be interesting in ...
- 1,356
5
votes
2
answers
2k
views
Oracle - Need help with RMAN Active Duplication on Windows 32 bit to a 64 bit
I need to have an Oracle 11g R1 on a Windows 32-bit duplicated to a Windows 64-bit using RMAN Active Duplication.
32-bit setup:
Windows Server 2003 R2 Standard Ed. SP2
Database - Oracle 11g ...
r3d
33
votes
7
answers
209k
views
Import a Oracle DMP file into a Fresh install of oracle
A client sent us an Oracle database we need to test against. We don't use Oracle or have any in-house Oracle expertise.
We need to setup the database so we can connect to it and debug a problem.
I ...
James