All Questions
Tagged with database-partitioning oracle-database
233 questions
0
votes
3
answers
59
views
Oracle Partition in For Loop Select
I need to fetch all rows in a specific partition of a table and print the values to a file.
CREATE OR REPLACE PROCEDURE
WriteRecordToFile
(
mypartition IN VARCHAR2,
myfilename IN VARCHAR2,
...
- 33
2
votes
0
answers
25
views
alter table modify option to remove partitioning completely?
Oracle allows easy redefinition of partitioning schemes with the syntax alter table XYZ modify partition by ... which simplifies the task of either converting a non-partitioned table to a partitioned ...
- 12.2k
0
votes
1
answer
36
views
Is partitioning the correct feature for periodical deletions in large tables?
If I have two tables in a (Oracle) database that keeps an history of records through time :
CREATE TABLE Records(
RecordPackId NUMBER,
RecordId NUMBER,
Data VARCHAR2(4000),
PRIMARY KEY ...
- 319
0
votes
1
answer
70
views
Has anyone been able to use values regexp_like in partitioning by list in Oracle 19c?
I am attempting to partition a table based on a varchar2 column. I would like to partition it by 1) all alpha characters, 2) all numeric characters and 3) both alpha and numeric characters.
column to ...
0
votes
3
answers
83
views
Oracle-14400 error but value entering partitioned column does map to partition
I have a problem with an insert I am attempting into an Oracle table called MACON. The table structure is below.
The issue I have is that when I attempt to insert a value into the MEASPART column, ...
- 103
1
vote
2
answers
440
views
Moving data between two partitioned tables in Oracle 19c
I am trying to move data between two partitioned tables. Below is the sample script. I am working on Oracle 19c and using 12c feature of creating table for exchange. Please suggest what is missing.
...
- 11
0
votes
1
answer
80
views
Doubts/Questions related to list partition on existing table with existing indexes in Oracle
We want to partition two existing tables (INVOICE_ITEMS and INVOICE_ITEMS_EVENTS). These two existing tables already have indexes on it (as given in the image below).
INVOICE_ITEMS (existing indexes ...
- 97
0
votes
1
answer
458
views
Oracle adding a partition by year to timestamp column
I have one Oracle table (my_table) with one timestamp column (my_column)
I´d like to add some partitions to the table by year
ALTER TABLE my_table
ADD PARTITION BY RANGE(EXTRACT(YEAR FROM my_column))
(...
- 3
2
votes
1
answer
205
views
In Oracle 18c+, Is it possible to use Table Flashback with a reference partitioned table?
From the documentation, it's not very clear to me whether flashback is supported for reference partitioned tables:
Restrictions on Flashing Back Tables
This statement is subject to the following ...
- 3,306
1
vote
2
answers
281
views
Reverse key indexes with multiple columns strategy
I'm creating a local index on partitioned table the Table is partitioned X (List partition)
The table TEST looks like this:
X
Y
Z
AB
24
63
AB
24
65
CD
24
63
CD
24
65
EF
24
63
If I create an index
...
- 35
0
votes
1
answer
83
views
How to Determine Tablespace from ROWID if data_object_id is not Unique?
If the data_object_id is not unique within a database as Tanel Poder demonstrated (albeit from 2008), then how does Oracle uniquely determine the tablespace from the ROWID in order to make use of the ...
- 550
0
votes
0
answers
494
views
Can dropping a partition automatically release space in Oracle SQL
Will the following SQL command release space automatically while dropping that partition?
Alter table abc Drop partition p1;
- 41
0
votes
1
answer
2k
views
Subpartitioned Index status is USABLE
To my knowledge, an index can be VALID, INVALID,UNUSABLE, and N/A status. For a subpartitioned index, I see the status as USABLE instead of VALID. I could not find the reason for this status in ...
1
vote
1
answer
721
views
Truncate partition doesn't throw an error when the partition range is lower than base partition oracle
I have a table partitioned based on the year and month (eg:202001).
Let's say the oldest data available is for partition 201304 and the latest available is for 202001.What I observed was when we ...
- 11
0
votes
3
answers
2k
views
Oracle-How to find partition information depending on the data in table ? ORA 14400
Trying to copy data from one environment to other.
Created partitions and sub partitions as per the source table but still getting error : Inserted partition key does not map to any partition.
Thanks ...
