CODEWITHSUNDEEP
oracle-databaseindexingconstraints
Joe
Joe

Reputation: 1305

Enabling Oracle Constraint on Multiple Tables

For my business app using Oracle 11.2.0 as the backend, we're going to have a series of tables Foo{0}, where {0} is a date, and there will be one table for each month end (long story on why this is required, but those are my marching orders). Each table will have a primary key constraint and an index, using the same columns for all tables. Instead of defining a constraint and index for all tables, is it possible to create one of each and apply those to all tables? Thanks for any help.

Upvotes: 1

Views: 312

Answers (2)

WW.
WW.

Reputation: 24301

There is not a good reason to create those 12 tables in Oracle 11.2.

I suggest:

  • Create one table. partitioned into 12
  • Create a single single primary key constraint with associated global index
  • Create views over this table for Foo1, Foo2 ... Foo12 if required for compatability with existing code

Upvotes: 1

Justin Cave
Justin Cave

Reputation: 231711

No. If you want 12 separate tables you would need to define 12 separate primary key constraints (and 12 separate indexes if you don't want Oracle to automatically create the index when you create the constraint).

Upvotes: 2

Related Questions