Database Administration (MOSC)

MOSC Banner

oracle table partitioning

in Database Administration (MOSC)
We have list of tables with one parent and 30+ Childs and we are looking for options to partition tables to mainly the huge delete operations .
One of the options we see is exchange partition as parent table has column for case status (OPEN,CLOSE) but doesn't reflect same column in child instead the id column is referenced all across . We cannot have the status column added to rest of tables also. Due to column number going exceeding 1000 limit.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center