Question

How do i create timers for an Oracle Database

Rating8.6Very Good

I have a query that gathers hundreds of thousands of rows in a database that has many users. I am trying to set my query to run on non-peak hours. I do not have the ability to write PL/SQL, is there a way i could do this with straight SQL? If not, what are some other methods i could look into. Please and thank you!

  1. can't connect to oracl server
    dear experts, i use oracle's sql developer tool for my queries recently it started to give me this error: ora-27101: shared memory realm does not exist i google'd it and came to a conclusion that my oracle database is not started [or loaded?] the tnslistener and names seem fine... however, the database isn't …
  2. Need Help Converting T-SQL CASE statemnt to …
    I am working in SQL Server 2005 and am LINKED to an ORACLE database using the standard code: Select * from openquery(dbname,' select * from whatever xxxxxxxxxxxx ') The below listed t-sql query statement works great for the output needed when I am working internal to SQL Server 2005. My goal is to use t…
  3. Oracle SQL query
    I am trying write a sql with sale_date vs date_paid form. (Please see Excel file attached). The attached excel tell us when the product was bought and when the payment was made. For ex: If the products were bought in sep2010 the payment could be made on sep2010 itself or made later than sep2010 (maybe oct2010, nov2010..…
  4. Problem creating Linked Server from SQL Server …
    Hi, OS: Windows XP I have SQL Server 2005 Standard installed as the default instance and I also installed SQL Server 2008 Express. Trying to create a linked server for both 2005/2008 to Oracle 10g on another Windows Server using tnsnames. SQL Server 2008 Express successfully creates it however when trying to create the linked …
  5. Query MS SQL and Oracle DB to provide a report
    With records in an Oracle database where the unique identifier is RFA# and records in a Microsoft SQL Server 2005 database with the same unique identifier what's the easiest way to query both tables to provide a report. Let's say Otable has RFA#, FName, LName, City and MStable has RFA#, LastName, FirstName, EmployerName …

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
Troubleshooting
Tags
Oracle SQL Database
Participating Experts
1
Solution Grade
A

Replies

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. sdstuber

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert