Database Ideas - Ideas

Discussion List

• 
  6

  Up Down
  Automatic subpartitioning

  Active William Robertson 68 views 0 comments 6 points Started by William Robertson Nov 10, 2019 11:02AM
• 
  0

  Up Down
  Veryuseful show command to know variables or status.

  Active Raul.Alvarenga 38 views 0 comments 0 points Started by Raul.Alvarenga Nov 1, 2019 11:14AM
• 
  1

  Up Down
  Using DBMS_ADVANCED_REWRITE and DBMS_SQL_TRANSLATOR to remove one hint from a SELECT

  Active 2878566 58 views 3 comments 1 point Most recent by mtefft Oct 30, 2019 3:45PM
• 
  14

  Up Down
  Oracle 12c Multitenant PDB - Save state of DBMS_SERVICE for PDB along with OPEN_MODE

  Active Stefan Koehler 587 views 3 comments 14 points Most recent by Franck Pachot Oct 30, 2019 10:28AM
• 
  0
  Move datafile online

  Archived 3236389 155 views 4 comments 0 points Most recent by Robeen Oct 25, 2019 12:36AM
• 
  4

  Up Down
  Bring EXP/IMP back to be up-to-date tools rather than legacy

  Active User_PT223 150 views 5 comments 4 points Most recent by William Robertson Oct 19, 2019 11:41AM
• 
  0

  Up Down
  Ability to use VARCHAR2(ORA_MAX_NAME_LEN BYTE) in a DDL instead of hard-coding a numeric literal!

  Active Sam_P 501 views 12 comments 0 points Most recent by William Robertson Oct 1, 2019 10:10AM
• 
  53

  Up Down
  Exclusive BETWEEN

  Active William Robertson 6.6K views 9 comments 53 points Most recent by Sentinel Sep 26, 2019 4:47PM
• 
  10

  Up Down
  to_char on an interval

  Active John_K 210 views 5 comments 10 points Most recent by Mike Kutz Sep 6, 2019 1:01AM
• 
  1

  Up Down
  Use filters in JSON_VALUE() and JSON_QUERY()

  Active taktang 19 views 2 comments 1 point Most recent by Beda Hammerschmidt-Oracle Sep 2, 2019 7:37AM
• 
  1

  Up Down
  EXPDP/IMPDP backup information

  Active Adityanath Dewoolkar 179 views 1 comment 1 point Most recent by Mike Kutz Aug 15, 2019 10:15AM
• 
  31

  Up Down
  DBA_USER_COMMENTS and comments on schema

  Active sysassysdba 960 views 7 comments 31 points Most recent by Justin Warwick Aug 14, 2019 11:39AM
• 
  0

  Up Down
  Allow to select Quorum Disk on Clusterware Installation OUI

  Active Raul.Alvarenga 100 views 5 comments 0 points Most recent by Raul.Alvarenga Aug 8, 2019 11:23AM
• 
  35

  Up Down
  Create user as other user

  Active sysassysdba 9K views 9 comments 35 points Most recent by Maaz Khan Aug 8, 2019 6:21AM
• 
  -8

  Up Down
  Create or Replace Table

  Active Meeuwtje 10.7K views 10 comments -8 points Most recent by tvCa Aug 8, 2019 4:18AM
• 
  0

  Up Down
  Joins to utilizes outer tables min/max values of join columns

  Active user3897193 51 views 4 comments 0 points Most recent by user3897193 Aug 6, 2019 8:05AM
• 
  23

  Up Down
  Deal with smart logic: Implement the reopt(ALWAYS) Hint like DB2

  Active Lothar Flatz 1K views 12 comments 23 points Most recent by Lothar Flatz Jul 31, 2019 9:52AM
• 
  7

  Up Down
  18c "set linesize window" should not affect pagesize

  Active User51642 Yong Huang 212 views 2 comments 7 points Most recent by User51642 Yong Huang Jul 21, 2019 10:32AM
• 
  2

  Up Down
  Merge with MATCHED BY TARGED/MATCHED BY SOURCE syntax

  Active Martin Preiss 4.5K views 4 comments 2 points Most recent by d1b538fb-0530-4128-959f-7fbe89100233 Jul 18, 2019 7:02PM
• 
  25

  Up Down
  Oracle Database Client for RPi ARM processor

  Active sysassysdba 3.8K views 10 comments 25 points Most recent by user10174131 Jul 18, 2019 3:11PM
• 
  14

  Up Down
  Allow to set negative substr length: SUBSTR(text,position,-length)

  Active Sven W. 184 views 5 comments 14 points Most recent by FatMartinR Jul 17, 2019 9:32AM
• 
  149

  Up Down
  Need a command to rename a schema

  Active Tmicheli-Oracle 13.4K views 29 comments 149 points Most recent by PS_orclNerd Jul 16, 2019 3:47PM
• 
  2

  Up Down
  INCREMENTAL refresh method for COMPLEX materialized views

  Active Rainer Stenzel 2.1K views 11 comments 2 points Most recent by Rainer Stenzel Jul 16, 2019 3:08PM
• 
  2

  Up Down
  extend UNIFIED AUDIT policy condition to accept SYSDATE

  Active berx 27 views 0 comments 2 points Started by berx Jul 15, 2019 3:56PM
• 
  9

  Up Down
  DBCA support for bigfile tablespaces

  Active Franck Pachot 246 views 5 comments 9 points Most recent by REISO Jul 9, 2019 8:07AM