This content has been marked as final. Show 4 replies
What do you want to achieve? You need to be little more clear. Once all the objects are created ,you can query DBA_OBJECTS and check if these objects are there or not. If all the objects you want are there, it means your sql scripts ran successfully. OR you can do *"set spool on"* and run your script. You will be able to see the queries and their output.
This might help too
This is useful. This would require some processing to pick up the object being created/changed from the sql being run.
Is there a way to track the sql (in whole) in the db and know its status from any of the view/tables.
Came across V$SQL, V$SQLAREA, but i thought it contains those queries that are present on the shared sql area.
Looking for some table/view that can hold all the sql that are run on the database for last n days.
DBA_HIST_SQLSTAT will give you some information. Check the link in my previous reply.