No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48504
Total active users1428
Act. users last 24h1
Act. users last hour0
Registered user hits last week57
Registered user hits last month580
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, 1727 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, 1727 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, 1727 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