python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to automate partition drop and alter table activity in oracle sql developer
I need a procedure that will help me to drop partition older than 3 months (current month + last 3 older months). And then I need to create the new partition in sequence.
for example if current partit...
Deepika Sheldar
Votes: 0
Answers: 2
Insert into foreign table partition doesn't work
I have some table in mariadb.
I need to create foreign table partition for that table
CREATE TABLE IF NOT EXISTS users (
id serial NOT NULL,
name varchar(30)
) partition by range(id);
CREATE ...
vantaqada
Votes: 0
Answers: 1
Slow cascade delete on rows referenced from a partitioned table
I have the following two tables:
CREATE TABLE events (
id bigserial not null
constraint birth_events _pkey
primary key
)
CREATE TABLE birth_events (
simulation_id...
olivierr91
Votes: 0
Answers: 1
How to partition an existing 120 TB table in bigquery?
I have a 120 TB table which unfortunately was not partitioned on creation. The jobs that use it filter it by a date column called sales_date and are taking hours to complete. I am trying to find the ...
Abhirami Baskaran
Votes: 0
Answers: 1