User atokpas - Database Administrators Stack Exchange

32 votes

Why is my PostgreSQL ORDER BY case-insensitive?

answered Mar 7, 2016 at 7:35

14 votes

Accepted

Composite indexes: Most selective column first?

answered Jan 24, 2017 at 6:00

12 votes

Accepted

understanding ORA-01792 maximum number of columns in a table or view is 1000

answered Feb 8, 2016 at 16:28

8 votes

Dump Oracle database into a textual SQL script

answered Mar 9, 2016 at 16:04

8 votes

Accepted

ARCHIVELOG in Oracle 12c multitenant PDB

answered Feb 28, 2017 at 11:19

8 votes

Accepted

Best way to get current year minus 5 years

answered Nov 18, 2017 at 1:10

7 votes

Accepted

Oracle - ORA-01654: unable to extend index in tablespace

answered Aug 24, 2015 at 16:34

7 votes

Accepted

For accessing Oracle 12c RAC database by JDBC to ensure high availability, should I use TAF or FCF?

answered Nov 2, 2016 at 5:26

6 votes

Accepted

Why am I getting PLS-00103 when I try to create a table in a PL/SQL procedure?

answered Oct 13, 2016 at 15:59

6 votes

Accepted

ORA-02270: no matching unique or primary key for this column-list

answered Feb 27, 2016 at 18:23

6 votes

Oracle 11gR2: ORA-01102: cannot mount database in EXCLUSIVE mode

answered Mar 12, 2016 at 6:33

6 votes

Duration unit in SQL Server trace file

answered Mar 2, 2017 at 1:41

6 votes

Accepted

Oracle Materialized View Error Log Table?

answered Apr 27, 2017 at 4:04

6 votes

Accepted

How to unmount oracle database?

answered Apr 27, 2017 at 8:49

5 votes

oracle 11g Grant on dbms_lock not persisting

answered May 2, 2017 at 9:13

5 votes

Accepted

Oracle 12c: installing expdp and impdp on Linux

answered Oct 4, 2016 at 11:11

5 votes

Accepted

What's the default password for SYSTEM in Amazon Oracle RDS?

answered Oct 5, 2016 at 5:29

5 votes

Accepted

Oracle Data Pump, pause a job

answered Oct 11, 2016 at 2:44

5 votes

Accepted

ORA-00959: tablespace does not exist but I can see it in select

answered Jan 3, 2017 at 8:35

5 votes

Accepted

In Oracle shared server mode, what is a virtual circuit?

answered Jan 6, 2017 at 7:53

4 votes

Accepted

Sequence number shows a lower value after dump file import

answered Jan 21, 2017 at 12:21

4 votes

Accepted

Why does ORACLE cache recovery create uncommited blocks during instance recovery?

answered Jan 4, 2017 at 0:23

4 votes

Accepted

Oracle DB Security Issue: Anyone can login using SQL*PLUS, with any username, and any wrong passphrase

answered Nov 15, 2016 at 6:06

4 votes

Database sessions

answered Sep 27, 2016 at 5:27

4 votes

Accepted

Need help with this policy function: Shows compilation errors

answered Apr 13, 2016 at 3:21

4 votes

missing files, installing Oracle DB 12c on Oracle Linux 7.2

answered Apr 16, 2016 at 16:06

4 votes

PL/SQL Can't grant privileges while logged as system

answered Apr 20, 2016 at 1:26

4 votes

Accepted

Select multiple columns from subquery - Connect by

answered May 3, 2016 at 11:29

4 votes

Accepted

Oracle SQL 12c How to correctly use compound foreign keys in compound primary keys?

answered May 7, 2016 at 1:27

4 votes

Accepted

How to reformat Oracle SQL quadratic-equation solver script?

answered Feb 24, 2016 at 16:09

Stack Exchange Network

262 Answers

Why is my PostgreSQL ORDER BY case-insensitive?

Composite indexes: Most selective column first?

understanding ORA-01792 maximum number of columns in a table or view is 1000

Dump Oracle database into a textual SQL script

ARCHIVELOG in Oracle 12c multitenant PDB

Best way to get current year minus 5 years

Oracle - ORA-01654: unable to extend index in tablespace

For accessing Oracle 12c RAC database by JDBC to ensure high availability, should I use TAF or FCF?

Why am I getting PLS-00103 when I try to create a table in a PL/SQL procedure?

ORA-02270: no matching unique or primary key for this column-list

Oracle 11gR2: ORA-01102: cannot mount database in EXCLUSIVE mode

Duration unit in SQL Server trace file

Oracle Materialized View Error Log Table?

How to unmount oracle database?

oracle 11g Grant on dbms_lock not persisting

Oracle 12c: installing expdp and impdp on Linux

What's the default password for SYSTEM in Amazon Oracle RDS?

Oracle Data Pump, pause a job

ORA-00959: tablespace does not exist but I can see it in select

In Oracle shared server mode, what is a virtual circuit?

Sequence number shows a lower value after dump file import

Why does ORACLE cache recovery create uncommited blocks during instance recovery?

Oracle DB Security Issue: Anyone can login using SQL*PLUS, with any username, and any wrong passphrase

Database sessions

Need help with this policy function: Shows compilation errors

missing files, installing Oracle DB 12c on Oracle Linux 7.2

PL/SQL Can't grant privileges while logged as system

Select multiple columns from subquery - Connect by

Oracle SQL 12c How to correctly use compound foreign keys in compound primary keys?

How to reformat Oracle SQL quadratic-equation solver script?