c_hockland
asked on
Oracle 10g and SQL navigator schedule export
Hi,
I have installed a 10g Oracle Database. I use SQL Navigator v5.5 for several purposes. How i can create a schedule export (file) for a specific view?
I have installed a 10g Oracle Database. I use SQL Navigator v5.5 for several purposes. How i can create a schedule export (file) for a specific view?
SQL Navigator does not play a role here. You can either use OS tools to periodically invoke an OS script which uses expdp, or else use DBMS_SCHEDULER to create a job which invokes DBMS_DATAPUMP. See here for a full example on the latter: http://ergemp.blogspot.com /2008/02/s cheduling- datapump-i n-oracle-1 0g.html
ASKER
First, where can i find DBMS_SCHEDULER? and second can u give me an example of an OS script?
First: DBMS_SCHEDULER is a supplied package, it is created on every Oracle 10+ database. Click on the link to see the docs.
Second: You first need to tell me which OS you're running! For instance: in *nix systems you can use cron for scheduling, for Windows you have the scheduled tasks in the control panel. They both need to invoke expdp, click on the link to see the docs.
Please include full version numbers when asking a question, as well as a clear description of what you are trying to accomplish. I believe "create a schedule export (file) for a specific view" could be rephrased (maybe in some longer sentence?) that clarifies the exact goal.
Second: You first need to tell me which OS you're running! For instance: in *nix systems you can use cron for scheduling, for Windows you have the scheduled tasks in the control panel. They both need to invoke expdp, click on the link to see the docs.
Please include full version numbers when asking a question, as well as a clear description of what you are trying to accomplish. I believe "create a schedule export (file) for a specific view" could be rephrased (maybe in some longer sentence?) that clarifies the exact goal.
ASKER
All i want is to export view "Per'" every one hour in a delimited file on a windows 2003 server with oracle 10g.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Note: that is, assuming that when you say "a delimited file" you want to express "a comma delimited file". If you want another delimiter, change the comma after COLSEP on the first line of the SQL script
ASKER
Thanks a lot. It's working just fine.....