Run the smartgroup SQL script manually. That should help. Post the *.out file here.
Sorry for the strange question as I am new to using Oracle DB's.
How do I execute the sql script?
I don't think that's the problem here. The smart group sql doesn't come into play unless you are
using the new reporting tool (BSARA) and I don't think you're there yet.
I'd open a ticket w/ support on this.
After opening a ticket, it was found that I needed to change an option in one of the xml scripts to allow the SmartGroupQuery to continue in the event of an error.
There was 1 out of 272 Smart Groups that was having a problem.
Database has now completed its migration.