Questions tagged [dbms-redefinition]
The dbms-redefinition tag has no usage guidance.
9 questions
0
votes
1
answer
798
views
Oracle dbms_redefinition fails with ora-01749, why?
I ran this as a part of redefining a table
DECLARE
l_num_ers PLS_INTEGER;
BEGIN
DBMS_REDEFINITION.copy_table_dependents(
uname => 'myuser',
orig_table => 'mytable'...
- 235
2
votes
3
answers
6k
views
Feasibility of Partitioning existing tables with huge data in Oracle
We have a set of 24 tables that take up about 1tb+ data which is why DBA suggested to use partitioning to better handle usage.
The only issue being the partitioning of the existing tables is ...
- 121
2
votes
1
answer
2k
views
DBMS_REDEFINITION with WHERE clause
I wanted to know if DBMA_REDEFINITON package allows a WHERE clause to filter contents before migration.
I have a partitioned table and wants to copy data and constraint to another table using ...
- 265
1
vote
1
answer
1k
views
Package DBMS_REDEFINITION missing from Oracle 11g?
I'm trying to partition an existing table in Oracle and the research I've done seems to say that using the DBMS_REDEFINITION package seems to be the best way to do this.
The problem is I doesn't seem ...
- 115
0
votes
2
answers
1k
views
DBMS_REDEFINITION don't copy data?
Is there an option to use Oracles online table redefinition feature but only copy a subset of the data from the source table?
I mean - the source table has 2M records and I want to only copy those ...
- 103
0
votes
0
answers
735
views
TEMP Tablespace Exceeded when DBMS_REDIFINITION
Oracle Environment.
Table size is 500Gb. Free space left on hard drive - 300Gb. TEMP Tablespace is currently 20GB
Task: do the DBMS_Redefinition for the table (partition by month) and optimize ...
- 133
1
vote
2
answers
16k
views
Moving a table to a different tablespace in Oracle using Online Redefinition Vs Alter table move tablespace
I have a table with 1 Billion records with size 300GB to move to different tablespace.
My question here is - What is the advantage of using DBMS_REDEFINITION (Online redefinition) package
over Alter ...
- 21
2
votes
1
answer
745
views
Redefining a table with a user-defined type using DBMS_REDEFINITION
The application which we developed has one schema, USER1, which has tables, types, packages etc.
I have to move some of the user-defined types to a different schema, The reason for doing this is to ...
- 21
5
votes
2
answers
4k
views
Why is SQL*Plus' desc table not showing not null constraints after using dbms_redefinition
I have the following table that I want to redefine:
create table tq84_redefinition (
id number primary key,
ts1 timestamp not null,
ts2 timestamp
);
Please note the not null constraint on the ...
- 3,763