Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5210

	People Online:
	Visitors: 316
	Members: 0
	Total: 316

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

Oracle describe table output

1 Replies

0 Subscribed to this topic

27 Subscribed to this forum

Sort:

Author

Messages

hussey1213

Basic Member

Posts: 16

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: 3353

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