Skip to content
  • Oracle
  • About
  • Oracle
Search
Close

– nice theory…

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

Category: Function-based index

ORA-00904 when inserting over a db-link

February 27, 2017February 21, 2017 NiceTheoryVidarLeave a comment

There seems to be a bug related to expression based (function based) indexes when the optimizer creates a plan for inserts over a database link. The symptom is ORA-00904: … : invalid identifier.

Read More »

Categories

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

Tags

  • Oracle (22)
  • PL/SQL (12)
  • Optimization (9)
  • SmartDB (9)
  • 12c (6)

Year

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