From: "jawa" <Jim.Wadas@motorola.com>
Subject: Table Reorg Tools
Date: 2000/08/08
Message-ID: <8mpbfq$co$1@spsnews.sps.mot.com>#1/1
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: usenet@spsnews.sps.mot.com
X-Trace: spsnews.sps.mot.com 965751098 408 137.162.39.94 (8 Aug 2000 16:11:38 GMT)
Organization: Motorola SPS
X-MSMail-Priority: Normal
NNTP-Posting-Date: 8 Aug 2000 16:11:38 GMT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools


Can anyone share a comprehensive script that reorgs a table, one that
identifies the referential constraints for recreation/recompilation after
the import?  I need a "meat & potatoes" SQL script (...don't have TS*Reorg
or OEM).  Thanks in advance.

--
Jim Wadas
Information Technology Solutions and Services (ITSS)
Motorola Systems Solutions Group (SSG)
Scottsdale, AZ  85257
phone (480) 441-8196
Jim.Wadas@motorola.com