No question at this time
DBA Top 10
1 M. Cadot 11200
2 A. Kavsek 6000
2 B. Vroman 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. PĂ©ran 2000
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48559
Total active users1398
Act. users last 24h3
Act. users last hour0
Registered user hits last week55
Registered user hits last month810
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, 1904 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, 1904 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, 1904 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