Skip to content
  • Oracle
  • About
  • Oracle
Search
Close

– nice theory…

– Good and not so good ideas on software development and Oracle databases in particular

Tag: Partitioning

Statistics gathering parameters for partitioned tables

May 20, 2023May 22, 2023 NiceTheoryVidarLeave a comment

When partitioned tables get a bit large, these parameters may be suitable to set.

Read More »

DataGrip cutting DDL short, case 2

May 19, 2023May 22, 2023 NiceTheoryVidarLeave a comment

My preferred tool for writing PL/SQL code has been DataGrip from JetBrains for the last few years. Working on a case with reference partitioned tables, I came over some strange errors. At first I thought Oracle had a lot of bugs in the partitioning syntax, but it turned out to be DataGrip messing with my DDL!

Read More »

Where the partitions have no name

September 20, 2018September 20, 2018 NiceTheoryVidarLeave a comment

Working on a routine for dropping old partitions from a log table, I realized that I don’t have to know the name of the partition I want to drop. I can just specify a value for the partition key and Oracle resolves the partition for me. Here’s how.

Read More »

Categories

  • Oracle (34)
  • Optimization (13)
  • PL/SQL (13)
  • Coding practice (9)
  • Built-in functionality (7)

Tags

  • Oracle (21)
  • PL/SQL (11)
  • SmartDB (9)
  • Optimization (8)
  • 12c (6)

Year

  • 2023 (5)
  • 2022 (2)
  • 2021 (1)
  • 2020 (1)
  • 2019 (3)
Blog at WordPress.com.
Back to top
  • Follow Following
    • - nice theory...
    • Already have a WordPress.com account? Log in now.
    • - nice theory...
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar