Restructuring Oracle tables

From: David Crossley <Rhona_Crossley_at_bc.sympatico.ca>
Date: 1996/11/29
Message-ID: <329FC2CC.21A94EA8_at_bc.sympatico.ca>#1/1

I am currently running an Oracle 7.1 database on AIX and will be migrating to Oracle 7.2.3. Before I migrate to 7.2.3, I would like to perform some housekeeping on my tables. A number of the tables have extraneous fields as well as fields that need to be resized. What is the recommended method ? Should I export the tables, drop the orginal table and reimport the data ? Is the export/import process smart enough to know which fields have been deleted ? Any suggestions would be appreciated.

David Crossley
GIS/AM Database Adminstrator
E-mail: david_crossley_at_city.vancouver.bc.ca Received on Fri Nov 29 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: N Prabhakar: "Re: Oracle 7 DBA Certification"
Previous message: Saqib Mausoof: "[Q] Nested SQL query - what am I doing wrong"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message