Link to home
Start Free TrialLog in
Avatar of c_hockland
c_hocklandFlag for Greece

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?
Avatar of Akenathon
Akenathon
Flag of Uruguay image

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/scheduling-datapump-in-oracle-10g.html
Avatar of c_hockland

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.
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
Avatar of Akenathon
Akenathon
Flag of Uruguay image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Thanks a lot. It's working just fine.....