Re: Please Help with these ORACLE 7.1 (NT) questions

NNOOR wrote:

> I would extremely appreciate help with the following:
>
> 1. How can I get the DDL for the objects I created in the DB?
> I want to save the SQL commands for every change I made to the
> DB objects. Can't figure out to get the SQL for those.
>
> 2. We are planning a move to the v7.3 and don't know how to move
> the database over from 7.1. Any help would be appreciate.
>
> regards,
> --nasir (nnoor_at_cris.com)

1. Either use SQL (I like the stuff on the RevealNet Oracle support disks that can do this sort of thing) or use a database design tools (like Oracle Designer 2000) to reverse engineer the database. In fact, you should be driving your database design and changes through a design tool, not the other way round as you are doing at present, IMHO. :-)
2. When you get your Oracle upgrade CD you should also get the Oracle 7 Server Migration manual. It details all the steps you need to perform: Basically, installing the new binaries in place of your current 7.1 executables and then running scripts on your existing databases to upgrade the data dictionary information.

Steve Phelan. Received on Mon Apr 28 1997 - 00:00:00 CDT