No question at this time
DBA Top 10
1 A. Kavsek 8900
2 B. Vroman 6600
3 M. Cadot 5000
4 T. Boles 4550
5 P. Wisse 4500
6 J. Schnackenberg 3700
7 . Lauri 1300
8 G. Lambregts 800
9 T. P 700
9 R. Pattyn 700
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48392
Total active users1527
Act. users last 24h5
Act. users last hour0
Registered user hits last week277
Registered user hits last month713
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, 1407 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, 1407 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, 1407 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