Why doesn't the SB View Details/Script tab not use the TEXT_VC column of DBA_VIEWS to retrieve a view's SQL definition? Is it because it is sometimes truncated? Since the Script tab draws from TEXT, those views whose TEXT is null have an empty create statement in the Script.
Would it be possible to use TEXT_VC instead? Maybe with some is null condition on TEXT.
Cheers,
Russ
Hi Russ,
Yeah, that's why I don't use TEXT_VC.
I never noticed that on the views that don't have source in the TEXT column DO have source in TEXT_VC. The only such ones I have noticed are SYS-owned views, while connected to a pluggable, but you can get them from the container. As far as I know, these are the only ones that are missing the source.
I'll make a note to fall back on TEXT_VC when TEXT is empty, as long as TEXT_LENGTH is less than 4000.
-John
That would be great!
Yeah, it is only those you said as far as I know.
Is the describe window Script tab the same code so that changing one changes both?
Cheers,
Russ
Yes, once I make the change it will fix it in SB-RHS-Script, Export DDL, Describe windows, generate schema script and compare schemas.
Wonderful! Thank you so much for your speedy response.
Cheers,
Russ