Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 46
	Members: 0
	Total: 46

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Oracle describe table output

1 Replies

0 Subscribed to this topic

29 Subscribed to this forum

Sort:

Author

Messages

hussey1213

Basic Member

Posts: 16

New Poster

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

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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