Check the adbldxml log file:
Message in logfile:
Retrieving information from database.
Solution:
Login to oracle:
Check the optimizer_mode
show parameter optimizer_mode
optimizer_mode will be all_rows.
Change it to rule:
alter system set optimizer_mode=rule;
run adbldxml.pl scripts
Once it prompts for display
Note: Change optimizer_mode back to all_rows;
alter system optimizer_mode=all_rows;
Now enter the diplay information. hit Enter xml file will generated.
Dislpay information can be obtained from database context file (xmlfile)
grep display contextfilename
