No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

Copying a partitioned table and all of its global/local indexes
Next thread: objects with no tablespace
Prev thread: Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux

Message Score Author Date
Hi, Is there a quick way to copy a partitioned ...... BenBart BartBen Sep 08, 2015, 06:00
Hi BB, I would use CTAS with APPEND PARALLEL hi...... Philip Wisse Sep 08, 2015, 09:20
Hi BB, These hint may not be combinable. https...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Sep 08, 2015, 09:29

Follow up by mail Click here

Subject: Copying a partitioned table and all of its global/local indexes
Author: BenBart BartBen, Philippines
Date: Sep 08, 2015, 06:00, 2825 days ago
Os info: Solaris
Oracle info: Oracle8 :(
Message: Hi,

Is there a quick way to copy a partitioned table and all of its global/local indexes?

I need to test doing exchanging partition, drop/restore partition and transportable export/import of the tablespaces used by a partitioned table.

I want to copy an existing partition table and indexes that is on the same database.

Currently generating the DDL using Toad :-) and then doing INSERT into.

Thanks in advance for any reply/feedback.



Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Copying a partitioned table and all of its global/local indexes
Author: Philip Wisse, Netherlands
Date: Sep 08, 2015, 09:20, 2825 days ago
Message: Hi BB,

I would use CTAS with APPEND PARALLEL hint.
http://docs.oracle.com/cd/A84870_01/doc/server.816/a76992/hints.htm#19039

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Copying a partitioned table and all of its global/local indexes
Author: Philip Wisse, Netherlands
Date: Sep 08, 2015, 09:29, 2825 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi BB,

These hint may not be combinable.
https://ksadba.wordpress.com/2011/01/04/insert-append-vs-ctas-%E2%80%9Ccreate-table-as-select%E2%80%9D-to-copy-data/

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here