Prev
Next
Forums S3 Systems Administration

Oracle describe table output

Sort:
You are not authorized to post a reply.
Author
Messages
hussey1213
Basic Member
Posts: 16
Basic Member
4/21/2011 9:16 PM
    I need to find the Oracle describe table output for the below tables:
    APPLICANT
    EMSTATUS
    ICITEMGTIN
    PASCRTY
    POPIVUF
    POVAGRMTLN
    POVENDLOC
    REQHEADER
    RQLOC
    We have missing columns between our Production and Development environments and we need to manually add them. Any help would be appreciated.
    John Henley
    Senior Member
    Posts: 3348
    Senior Member
    4/21/2011 10:20 PM
      Use verify10ora to compare your dictionary against actual database. The use bldora10ddl (**WITHOUT the -U option ***) to generate SQL. Use that SQL to create alter table commands to add missing columns. Then use bldora10ddl -URI to recreate indexes. =
      Thanks for using the LawsonGuru.com forums!
      John
      You are not authorized to post a reply.