Oracle describe table output

 1 Replies
 0 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
hussey1213
Basic Member
Posts: 16
Basic Member
New Poster
New Poster
Congrats on posting!
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
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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