All Questions
Tagged with database-partitioning oracle12c
23 questions
0
votes
2
answers
133
views
Yearly Partitioning a Integer column which stores Date as ID
I have a table which has a DATE_ID column (Integer data type). This column basically stores dates in ID format. Input data:
DATE_ID
19961210
19991001
20051212
20090108
I need to partition this table (...
- 351
0
votes
2
answers
3k
views
Partition by range in oracle using sysdate
I want to create partitions dynamicaly that depends on sysdate, like:
create table partition_interval_demo
( id number(6)
, val varchar2(50)
, date_create date)
partition by range (...
1
vote
2
answers
3k
views
Moving data from one partition to another
I have a huge table containing about 500 million records. This table has 2 partitions, CURRENT_DATA and PREVIOUS_DATA.
When new data comes in, last PREVIOUS_DATA partition is truncated, and data from ...
- 755
0
votes
0
answers
276
views
Oracle Database Capacity Planning
Just want to know if there is a formula I can use how to estimate database storage size needed based on estimated number of records and data types of those records that will be stored.
Are there ...
1
vote
0
answers
58
views
Filter on partitioned tables - Oracle
I wrote a CTE to get a date range filters and am using these as my date filters on a partitioned table (table2) with a join. The query is running longer than expected and explain shows all partitions ...
- 11
2
votes
0
answers
455
views
How to convert a partitioned table to non partitioned table in Oracle 12c
I plan to range partition a table (Currently about 4 GB in size and growing at a rate of 2 GB per year) in oracle 12c in production expecting performance gains. However just in case it fails to meet ...
- 161
1
vote
0
answers
593
views
Oracle 12 c database::Is there any other way to drop the column with out uncompression table in oracle database?
We have table which is partitioned ( & sub partitioned), compressed and also have a huge volume of data. While dropping one column(E_POOL_ID) from a existing partitioned table with compression ...
- 11
0
votes
2
answers
5k
views
Split maxvalue partition in Oracle with new subpartition template
How can I split maxvalue partition in Oracle with new subpartition template.
Or
How can I split maxvalue partition in Oracle and add also add new subpartitions parallely
- 11
0
votes
0
answers
638
views
How to update a hash partitioned column in Oracle 12c?
I have a table that is partitioned by hash on a column.
CREATE TABLE TEST(
ACCOUNT_NUMBER VARCHAR(20)
)
PARTITION BY HASH (ACCOUNT_NUMBER)
PARTITIONS 16
Now, I want to update the account_number ...
- 79
0
votes
1
answer
320
views
When to create local and global indexes in RANGE INTERVAL partition
We are making use of Oracle 12c RANGE INTERVAL partitioning where Oracle creates the partitions automatically based on the data.
Parent tables are partitioned based on RANGE INTERVAL, child tables ...
- 37
0
votes
1
answer
718
views
Oracle Automatic LIST partition using virtual column not allowing REFERENCE partition on child table
I’ve made an attempt to create partition on test table using virtual column. This approach is working good for PARENT or standalone tables. However, I cannot create REFERENCE partition on CHILD ...
- 37
1
vote
1
answer
456
views
Oracle {LIST} Partition by Program and {RANGE} subpartition by DATE with interval
I'm trying to figure the best possible way to determine the partition strategy in Oracle 12c (12.2.0.1.0)
This post
is almost identical to my requirements. However, I want to know the best possible ...
- 37
0
votes
1
answer
192
views
How to pass all values into List Partition
as my title, I'm in trouble like this:
I have a non-partitioned table named DISTRICT, now I want to use DBMS_REDEFINITION to change non-partitioned table to partitioned table.
I create a clone table ...
1
vote
1
answer
400
views
Exchange & split partition have a issue
I am trying to exchange non partition data with partition data. I have done following steps.
Created a new table TEMP_TABLE with partition with the TEMP_TABLE_1 range as date('1-09-2019').
And I have ...
- 51
0
votes
2
answers
2k
views
Interval Partitioning In Oracle on SYSDATE
I am looking for the best way to create partitions dynamically. Like, partition 1 would hold all records dated as of today(SYSDATE), and partition 2 would hold records of yesterday's date(SYSDATE-1) ...
- 11