oracle truncate partition support

Daniel Luksetich

oracle truncate partition support
Anyone know if the oracle alter table truncate partition is supported in db2 luw 9.7?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Gunning

Re: oracle truncate partition support
(in response to Daniel Luksetich)
Truncate for table is supported. ,use detach for a partition.
------Original Message------
From: Daniel Luksetich
Sender: IDUG DB2-L
To: [login to unmask email]
ReplyTo: IDUG DB2-L
Sent: Dec 23, 2010 3:35 PM
Subject: [DB2-L] oracle truncate partition support

Anyone know if the oracle alter table truncate partition is supported in db2 luw 9.7?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv


Sent via BlackBerry by AT&T

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Daniel Luksetich

Re: oracle truncate partition support
(in response to Philip Gunning)
Phil,
I don't understand your answer. I know I can attach and detach partitions,
but can I actually issue the Oracle statement (alter table truncate
partition) and have it complete successfully? Or, do I need to change the
statement such that it detaches instead?
Thanks,
Dan

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Phil Gunning
Sent: Thursday, December 23, 2010 5:25 PM
To: [login to unmask email]
Subject: [SPAM] Re: oracle truncate partition support

Truncate for table is supported. ,use detach for a partition.
------Original Message------
From: Daniel Luksetich
Sender: IDUG DB2-L
To: [login to unmask email]
ReplyTo: IDUG DB2-L
Sent: Dec 23, 2010 3:35 PM
Subject: [DB2-L] oracle truncate partition support

Anyone know if the oracle alter table truncate partition is supported in db2
luw 9.7?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv


Sent via BlackBerry by AT&T

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.872 / Virus Database: 271.1.1/3332 - Release Date: 12/23/10
01:34:00

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Gunning

Re: oracle truncate partition support
(in response to Daniel Luksetich)
Truncate works on table level I believe, not partition level. Phil
Sent via BlackBerry by AT&T

-----Original Message-----
From: Daniel Luksetich <[login to unmask email]>
Sender: IDUG DB2-L <[login to unmask email]>
Date: Thu, 23 Dec 2010 17:57:57
To: <[login to unmask email]>
Reply-To: IDUG DB2-L <[login to unmask email]>
Subject: Re: [DB2-L] oracle truncate partition support

Phil,
I don't understand your answer. I know I can attach and detach partitions,
but can I actually issue the Oracle statement (alter table truncate
partition) and have it complete successfully? Or, do I need to change the
statement such that it detaches instead?
Thanks,
Dan

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Phil Gunning
Sent: Thursday, December 23, 2010 5:25 PM
To: [login to unmask email]
Subject: [SPAM] Re: oracle truncate partition support

Truncate for table is supported. ,use detach for a partition.
------Original Message------
From: Daniel Luksetich
Sender: IDUG DB2-L
To: [login to unmask email]
ReplyTo: IDUG DB2-L
Sent: Dec 23, 2010 3:35 PM
Subject: [DB2-L] oracle truncate partition support

Anyone know if the oracle alter table truncate partition is supported in db2
luw 9.7?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv


Sent via BlackBerry by AT&T

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.872 / Virus Database: 271.1.1/3332 - Release Date: 12/23/10
01:34:00

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Maja Markotic

Re: oracle truncate partition support
(in response to Philip Gunning)
Hi Dan,

I'm merely quoting the manual:

"With DB2 Version 9.7 Fix Pack 1 and later releases, when detaching a data partition from a partitioned table using the ALTER TABLE statement with the DETACH PARTITION clause, the source partitioned table remains online, and queries running against the table continue to run. The data partition being detached is converted into a stand-alone table in the following two phase process:
1. The ALTER TABLE...DETACH PARTITION operation logically detaches the data partition from the partitioned table.
2. An asynchronous partition detach task converts the logically detached partition into a stand-alone table."

"Once a data partition is detached into a separate table, the table can be handled in several ways. You can drop the separate table (whereby, the data from the data partition is destroyed); archive it or otherwise use it as a separate table; attach it to another partitioned table such as a history table; or you can manipulate, cleanse, transform and reattach to the original or some other partitioned table."

HTH, Maja

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Daniel Luksetich
Sent: Thursday, December 23, 2010 9:35 PM
To: [login to unmask email]
Subject: [DB2-L] oracle truncate partition support

Anyone know if the oracle alter table truncate partition is supported in db2 luw 9.7?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Disclaimer:
Ova elektronička poruka je povjerljiva i može sadržavati povlaštene informacije. Ako niste naznačeni primatelj, niste ovlašteni čitati, printati, pohraniti, obrađivati ili priopćavati ovu poruku. Ako ste ovu poruku primili greškom, molimo Vas da o tome odmah obavijestite pošiljatelja i izbrišete ovu poruku, njene privitke i kopije. Zagrebačka banka d.d. ne preuzima nikakvu odgovornost s obzirom na bilo koju moguću netočnost bilo kojeg podatka koji je sadržan u ovoj poruci ako takav podatak nije povezan s registriranim predmetom poslovanja Zagrebačke banke d.d. Stajališta izražena u ovoj poruci ne odražavaju nužno službena stajališta Zagrebačke banke d.d. Hvala!
This e-mail is confidential and may also contain privileged information. If you are not the intended recipient, you are not authorised to read, print, save, process or disclose this message. If you have received this message by mistake, please inform the sender immediately and delete this e-mail, its attachments and any copies. Zagrebacka banka d.d. does not take any responsibility with regards to any possible inaccuracy of any data contained in this e-mail if such data do not relate to the registered operations of Zagrebacka banka d.d. The opinions expressed in this e-mail do not necessarily reflect the official positions of Zagrebacka banka d.d. Thank you!

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv