Re: Sql Script to rebuild table
From: Suman Guha <xxx_at_xxx.xxx>
Date: 1995/12/19
Message-ID: <DJuLyH.G3D_at_txnews.amd.com>#1/1
Date: 1995/12/19
Message-ID: <DJuLyH.G3D_at_txnews.amd.com>#1/1
Use the exp utility to get a dmp file. (You need not export the data
You can extract the SQL statements for creating the table, indexes, constraints, triggers, grants from the dmp file and run it from sqlplus to rebuild your schema objects.
The statements are not very well formatted. But they work.
Regards,
Suman.
dsscott_at_neosoft.com (Douglas Scott) wrote:
>Does anyone know where I can get a Sql*Plus script that will rebuild a
>table including constraints, indexes and grants? In my environment we
>often change tables (i.e. add/remove/modify fields) especially when
>developing new systems.
>
>Douglas Scott
>dss_at_neosoft.com
Received on Tue Dec 19 1995 - 00:00:00 CET