Relocate table to a different tablespace in SAP

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Fri, 4 Nov 2005 11:23:00 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C9B33@irv2kexch01.tx.bg.corp>

Hi,

Below is what I see when I used sapdba to move a table.

CREATE        TABLE "SAPR3"."CKMI1#" ...TABLESPACE  "PSAPBTA3D"... AS
SELECT * FROM "SAPR3"."CKMI1";
DROP          TABLE "SAPR3"."CKMI1"  if successfully created;
RENAME                      "CKMI1#" TO "CKMI1";

Question#1: What is "if successfully created" in the second sql statement?
Question#2: Is this same as "alter table move tablespace ..."?

Thanks,

Roger

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 04 2005 - 11:25:49 CST