I was getting the below error while working on a small program using UTL_FILE.
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
I have been banging my head on what could be the possible cause for this error. Because I created the directory and it has all the read write permissions on it.
Finally after some goggling I found the issue was because I was passing the directory names in lower case. Till now I was under the impression that Oracle would take lower case parameter as well. Well now I know that I need to pass the directory name in upper case at least while executing the UTL_FILE package.
Friday, July 16, 2010
Wednesday, July 07, 2010
DBA_TAB_MODIFICATIONS
Today I got to learn about this view in Oracle which stores all the inserts, updates and deletes done on a particular table. There are three views corresponding to it.
DBA_TAB_MODIFICATIONS
ALL_TAB_MODIFICATIONS
USER_TAB_MODIFICATIONS
All we need to in this case is to execute the below procedure to update these views with the information.
exec dbms_stats.flush_database_monitoring_info
This proc would populate the data into the views and we can easily tell the number of inserts, updates and deletes that happened on a particular table. I learned this primariy from this link. According to Martin's blog the data would not record insertes done by multiple table inserts. But would record all the other DML operations on the table.
DBA_TAB_MODIFICATIONS
ALL_TAB_MODIFICATIONS
USER_TAB_MODIFICATIONS
All we need to in this case is to execute the below procedure to update these views with the information.
exec dbms_stats.flush_database_monitoring_info
This proc would populate the data into the views and we can easily tell the number of inserts, updates and deletes that happened on a particular table. I learned this primariy from this link. According to Martin's blog the data would not record insertes done by multiple table inserts. But would record all the other DML operations on the table.
Subscribe to:
Posts (Atom)