> 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.
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.