All Questions
13 questions
0
votes
2
answers
5k
views
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 ...
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
2
answers
2k
views
Oracle query creating multiple sessions
I am running a select statement, its acquiring 200+ sessions. I am unable to get root cause why it is giving too many connection.
Sample statement:
Select name from tablename where colname=xyz;
...
2
votes
1
answer
402
views
How to change a table to partition table with DBMS_REDEFINITION but no primary key in current table
How to convert a non-partition table (no primary key) to partitioned table? Someone says I can use rowid, but I can not find any sample from Oracle doc.
My oracle is 12C release 1, it did not contain ...
- 121
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
2
votes
1
answer
5k
views
How to create partitioned table based on one Integer column (each value = 1 partition) in Oracle 12c?
There is a non-partitioned table in Oracle 12c, call it 't1' with 10M records that has 3 columns (a,b,c).
Column 'a' has 100 distinct integer values.
How to create a second table 't2' that has all ...
- 13.2k
4
votes
3
answers
36k
views
Can I partition an already existing table in oracle?
I have a table in my oradb, whitch already has a lot of rows.
I want to partition this table by month by not recreating it. So I don't want to lose the data from the table.
I want this partition ...
- 6,686
2
votes
5
answers
13k
views
Oracle : Drop multiple partitions
A table TMP has 5 partitions, namely P_1, P_2,....P_5.
I need to drop some partitions of TMP; the partitions to drop are derived by another query.
Ex:
ALTER TABLE TMP DROP PARTITIONS (SELECT ... ...
- 327
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, ...
