All Questions
Tagged with database-partitioning ddl
15 questions
0
votes
0
answers
532
views
How can I partition a table with 100 million rows into 365 subtables (partition by date)?
I have a table with about 100 million rows in PostgreSQL. Each row contains a date column. I want to partition the table into 365 child tables (partition by day).
My idea is
CREATE TABLE mytable (
...
0
votes
1
answer
5k
views
"ORA-14400: inserted partition key doesn't map to any partition" even thought a range interval N is set up on the table
I have an Oracle DB with version 19c (19.0.0.0.0). And I get the error "SQL Error [14400][72000]: ORA-14400: inserted partition key doesn't map to any partition" even thought a range ...
- 359
1
vote
3
answers
6k
views
automatic partition naming for range partitioning
I have a table like this
CREATE TABLE data_audit(
id_col NUMBER(*,0) NOT NULL ENABLE,
col_2 VARCHAR2(10) NOT NULL ENABLE,
col_3 NUMBER(*,0) NOT NULL ENABLE,
col_4 ...
- 1,475
2
votes
1
answer
771
views
MySQL Stored Procedure fails with ERROR 1064 (42000)
I have written a MySQL stored procedure that will add a new partition to an existing table:
DELIMITER //
DROP PROCEDURE IF EXISTS cr_par //
CREATE PROCEDURE cr_par (
IN p_table VARCHAR(256),
...
- 23
1
vote
1
answer
814
views
Partition in postgresql
everyone!
Im new in postgresql and try to partition the existing table.
So I want something like
alter table t1 partition by range (c_date);
but get a syntax error at or near partition.
Also I tried ...
- 147
4
votes
1
answer
2k
views
PostgreSQL partitioned table and partitions in different schemas
I'm planning to partition a huge table in postgresql. I'm using pgsql-13.
I'm evaluating the possibility to create the master table in schema "public" and the partitions in a new different ...
- 80
0
votes
1
answer
1k
views
Why does it say ORA-14006: invalid partition name?
I used this code on Oracle PL/SQL on version 13
ALTER TABLE instrument_balance_hist MODIFY PARTITION BY RANGE( instrument_id ) INTERVAL (100)(
partition p1 VALUE LESS THAN (100),
partition p2 VALUE ...
0
votes
1
answer
2k
views
Postgres table partition by list limit
I wonder if there is a limit for partition table by list where each subpartition table contains only one element.
For example, I have this partition table:
CREATE TABLE whatever (
city_id ...
- 2,945
1
vote
0
answers
609
views
SQL Error: ORA-14006: invalid partition name when moving partition
I want to move the partition to another tablespace but when I run the following script I get the error ORA-14006.
Does anyone know how to solve this problem?
ALTER TABLE tbl_name MOVE PARTITION '...
- 99
2
votes
1
answer
2k
views
Alternative to VALUES LESS THAN in interval partitioing creation query
As we know that Interval partitioning is an extension of Range partitioning and it takes much of its syntax from
range partitioning.
From various sources on the net, I assume that interval ...
- 969
1
vote
2
answers
5k
views
Partitioning on a number column as Date Range in Oracle
I am trying to create a partitioned table as follows -
CREATE TABLE test1 (
id NUMBER(18,0),
text VARCHAR2(1024)
)
partition BY RANGE
( TO_DATE(substr(id,1,8),'yyyymmdd')
) ...
- 887
2
votes
1
answer
1k
views
Can we change the interval for a partition?
I have a table partitioned by range with an interval. Then I have a partition with this configuration:
PARTITION "SYS_P657531" VALUES LESS THAN (18100000000)
There is an alter command in order to ...
- 1,385
2
votes
1
answer
879
views
Multi-level partition in Greeplum
I want to make a multilevel partition table in Greeplum with first level partition on year and second on every 7 days. When I hardcode it works fine.Following is the code :
DROP TABLE if exists pd....
- 53
0
votes
1
answer
1k
views
Why do I get an ORA-00922 when trying to create a partitioned table in Oracle?
I'm trying to create partitioned on oracle table but getting ORA-00922 error.
Error starting at line : 1 in command -
CREATE TABLE "RATE_REQUEST_BKP_PARIATIONED"
(
"RATE_REQUEST_ID" ...
1
vote
0
answers
361
views
How do I create a partitioned table without initial partitions?
Say, I have the following DDL:
create table partition_test_table
(
id number(38,0) not null,
value varchar(255),
country_code varchar(2) not null,
creation_date date not null,
...
- 2,743