根据Oracle中的CREATE TABLE语句生成升级到ALTER TABLE的脚本 [英] Generate upgrade script to ALTER TABLE based on CREATE TABLE statement in Oracle

问题描述

Oracle是否可以基于架构中的现有表以及具有该表的较新定义的CREATE TABLE语句生成一堆ALTER TABLE语句?

Is it possible in Oracle to generate a bunch of ALTER TABLE statements based on existing table in schema plus CREATE TABLE statement with newer definition of that table?

比方说，我有一个具有应用程序某些先前版本的架构.我有该应用程序最新版本的安装脚本.该脚本从头开始执行CREATE TABLE(可能还有CREATE SEQUENCE)语句来创建所有表和序列.

Let's say I have a schema with some previous version of an application. I have an installation script for newest version of the application. The script creates all tables and sequences from scratch performing CREATE TABLE (and probably CREATE SEQUENCE) statements.

我想将架构更新到应用程序的最新版本，而不会丢失任何数据(例如，不执行DROP TABLE).

I'd like to update the schema to the newest version of the application without loosing any data (e.g. without performing DROP TABLE).

是否可以使用标准Oracle 11gR2或第三方组件?

Is it possible with using of standard Oracle 11gR2 or third party components?

推荐答案

您可以尝试CORT: www.softcraftltd .co.uk/cort 免费

You can try CORT : www.softcraftltd.co.uk/cort It's free

这篇关于根据Oracle中的CREATE TABLE语句生成升级到ALTER TABLE的脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！