No question at this time
DBA Top 10
1 A. Kavsek 10900
2 M. Cadot 6200
3 P. Wisse 5000
4 B. Vroman 4500
5 T. Boles 2200
6 . Lauri 2000
7 J. Schnackenberg 1300
8 J. PĂ©ran 1100
9 R. Pattyn 700
10 T. P 500
10 G. Graham 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48425
Total active users1512
Act. users last 24h8
Act. users last hour2
Registered user hits last week172
Registered user hits last month818
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, 1473 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, 1473 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, 1473 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