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?
c_hocklandAsked:
Who is Participating?
 
AkenathonConnect With a Mentor Commented:
On a DELIMITED file? That's definitely NOT exporting. You want to schedule a WINDOWS task (nothing to do with Oracle or SQL navigator) that does this:

sqlplus -s username/password @select_from_per

Open in new window


...and then write a script per.sql with this content:

SET ECHO OFF LINESIZE 200 PAGESIZE 0 TRIMSPOOL ON TERMOUT OFF COLSEP ,

SPOOL select_from_per.txt

select * from per;

exit

Open in new window


If you have commas in your string data, instead of select * you will have to select '"' || your_string_field || '"' to enclose them in double quotes.
0
 
AkenathonCommented:
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
0
 
c_hocklandAuthor Commented:
First, where can i find DBMS_SCHEDULER? and second can u give me an example of an OS script?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
AkenathonCommented:
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.
0
 
c_hocklandAuthor Commented:
All i want is to export view "Per'" every one hour in a delimited file on a  windows 2003 server with oracle 10g.
0
 
AkenathonCommented:
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
0
 
c_hocklandAuthor Commented:
Thanks a lot. It's working just fine.....
0
All Courses

From novice to tech pro — start learning today.