Re: Q on V7 migration

Quite a number of people have recommended the use of 'imp INDEXFILE=???'. While this method will help in extracting the Table and Index DDL BUT BE AWARE it does not provide DDL for
-sequence numbers
-permissions
-synonyms
-DBA DDLs like TS creation,public synonyms

A much better approach is to run imp with SHOW=Y and you will get ALL DDLs displayed to your screen. Now the tricky part. You need to format the output.

There is a shell script that will allow you to do the which was written by David Bath and I modified it. Now before all of you start to ask for this file please do rush for it. I will send it ONLY if you desperately need it else you can either get it from the Oracle FTP site in Germany or I might include it in the IOUG 1994 Utility or even present it at the IOUW94. I will upload it to the FTP site sometime in the next few days.

For those that know 'ex' or 'sed' well enough, you can write your own utility to extract these information.

ta
tony

--

 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  _        /_ __ /       |Colonial Mutual Invest Mgmt,Aust (ACN004021809)
 /(_)/ )(_/ \_/(///(/_)/_(   |EMAIL: TJambu_at_cmutual.com.au
 \_______/                   |PHONE: +61-3-2831639       FAX: +61-3-2831090