Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 326
	Members: 0
	Total: 326

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
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 Send Private Message

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

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