APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX_ACTIVITY_LOG to ---> a table

650629Oct 31 2008 — edited Nov 4 2008

Hi,
In SQL Workshop have queried:
SELECT * FROM APEX_ACTIVITY_LOG
The APEX_ACTIVITY_LOG has all of the information I need to track usage of my application. I understand that there are reports that can be generated on the LOG but I need to automatically write this information to a table via a dblink if possible. I already have the dblink created and am inserting data into tables with my application through this dblink but I don't understand how to take the APEX_ACTIVITY_LOG data and get it into a table that is on the other side of this dblink.
Any suggestions?
Please let me know a little more step by step. I started using ORACLE and APEX about 2 months ago and while I have learned alot I sometimes need these things spelled out for dummies.
Thanks,
Kirk

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2008

Added on Oct 31 2008

#apex-discussions

8 comments

2,120 views