All Questions
14 questions
0
votes
1
answer
318
views
ORACLE - When splitting a partition, can I meanwhile still read data in it?
Statements
let say I have a schema partitioned by range of date (but no subpartitions)
let say I have partition P1 in this schema containing a lot of rows
at some point, let say I want to split it
as ...
- 89
0
votes
1
answer
270
views
Added Daily Partition before the insert
i have the following table
CREATE TABLE "ICTPART_DAILY_SUMMARY"
(
"EVENT_START_DATE" DATE
"ACCOUNTING_METHOD" CHAR(1),
......etc
)
...
- 11
0
votes
1
answer
701
views
Adding a Partition FOR 30 DAYS
I have the following table :
CREATE TABLE "ICTPART_DAILY_SUMMARY"
(
"EVENT_START_DATE" DATE
"ACCOUNTING_METHOD" CHAR(1),
......etc
)
PARTITION ...
- 11
6
votes
1
answer
1k
views
Initial extent size when converting to partitioned table
Working in an Oracle 19c database on Linux x86/64 trying to convert non-partitioned table to partitioned table.
Since Oracle12, alter table modify partition has been available to convert non-...
- 63
0
votes
1
answer
583
views
Oracle - How the rows are handled in partitioned table, if the respective interval is already dropped?
I have a existing table which is partitioned based on range partitioning
Schema :
create table History(
hid number(19,0),
type varchar2(255 char),
lastupdated timestamp (6) not null enable,
name ...
- 239
0
votes
1
answer
528
views
Non Distributed Data _ Spring Batch Partitioner
Just take a case where I am reading data from a Database with conditions (millions of rows), doing some business on data and then updating it.
I am using a Column Range Partitioner ( Id column ) ...
- 43
2
votes
1
answer
1k
views
MySQL partitioning based on the first letter of varchar field
I have a very similar problem asked in Partitioning table based on first letter of a varchar field for Postgres, however, I want to do this in mysql 5.7.
Is it possible to partition a table in MySQL ...
0
votes
0
answers
104
views
What is the limit of the value list in MySQL's PARTITION BY LIST?
When partitioning by list
CREATE TABLE my_table (...)
PARTITION BY LIST(my_column)
( PARTITION p0 VALUES IN (xxx),
...
);
what is the limit of xxx?
- 704
4
votes
2
answers
17k
views
SQL Error: ORA-14006: invalid partition name
I am trying to partition an existing table in Oracle 12C R1 using below SQL statement.
ALTER TABLE TABLE_NAME MODIFY
PARTITION BY RANGE (DATE_COLUMN_NAME)
INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(
...
- 2,348
1
vote
2
answers
230
views
Automation of mysql partitioning
I have searched lot about automation of mysql partitioning.
But unfortunately nothing matches to problem.
I want delete an older partitions which are not needed but at the same time add new upcoming ...
- 159
0
votes
1
answer
208
views
Query a Partitioned MySQL DB With <= And >= In Where Clause
I have a MySQL table (rangeTest) that has over 10 million rows of data that I need to query constantly in a web app and therefore needs to be very fast. Each row covers an Integer range as described ...
- 277
0
votes
1
answer
8k
views
mysql partitioning by date
I'm trying create a partition in mysql on a date column MV_DATE is of type DATE
Here's the query -
ALTER TABLE table_name PARTITION BY RANGE (TO_DAYS(MV_DATE))(PARTITION p0 VALUES LESS THAN (...
- 1,823
0
votes
0
answers
535
views
Partitioning using dynamic values from table - Oracle 11gR2
I want to create a table with partitioning that automatically adds a partition via a column name.
E.g. Phone numbers (should only take distinct values) and as new numbers are added to the column, ...
6
votes
3
answers
34k
views
Find Partition Schema Definitions in SQL Server Database
I have access to a database and I need to know the Partition Scheme definitions in the database. i.e. I need to know the partition scheme name, which Partition function is it using, what file groups ...
- 171