I'm a novice with Oracle, I just just started as a result of being thown in a position of supporting Oracle databases with no knowledge. I need to learn how to create a scheduled job that takes a nightly export of a database and saves it to a specified location.
I need to take daily exports for the days of the week.
sorry but I would really appreciate step by step instructions considering my lack of knowledge.
also if you know of good loinks where I could find additional information to assist.
Please provide step by step instructions for:
Creating the oracle job
Scheduling the job to export
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…