|
Re: Partitoning taking long time [message #683212 is a reply to message #683211] |
Tue, 15 December 2020 09:33 |
Solomon Yakobson
Messages: 3286 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
When you are partitioning existing n0n-partitioned table Oracle creates temporary segments for each partition populates them with data from original table, switches metadata and drops original segments, so you have to have al the minimus as much free space as the size of original table.
SY.
|
|
|
|
Re: Partitoning taking long time [message #683224 is a reply to message #683213] |
Wed, 16 December 2020 08:52 |
Solomon Yakobson
Messages: 3286 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Indexes will be marked unusable, not stale. And it this is normal since data moved physically. You must rebuild indexes after that unless you use indexing clause in ALTER TABLE ... PARTITION...; And obviously partitioning will take long(er) time on a larg(er) table - Oracle has to sort table data on a partitioning column(s) to determine what data goes to what partition and copy data there. In addition this is online partitioning so Oracle has to keep track of all data changes since partitioning started.
SY.
[Updated on: Wed, 16 December 2020 09:38] Report message to a moderator
|
|
|
|
Re: Partitoning taking long time [message #683289 is a reply to message #683288] |
Thu, 24 December 2020 13:04 |
Solomon Yakobson
Messages: 3286 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
You could try exporting table, dropping it and creating partitioned table without any indexes and constraints. Then import using data only. Create indexes and constraints after import.
SY.
|
|
|