Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DrSeussFreak

  1. DrSeussFreak

    Can Oracle8 client connect to 10g database?

    Oracle 8 client can NOT connect Oracle 10. Just go download the oracle 10 client (or oracle 11 if you want) from http://www.oracle.com/technology/software/index.html
  2. DrSeussFreak

    Help with 10g's Scheduler

    There is a job called 'GATHER_STATS_JOB' that can be found by running select job_name from dba_scheduler_jobs where owner = 'SYS' order by 1 I was wondering if anyone knows how to edit sys owned jobs/packages so I can have it skip a tablespace when it runs.
  3. DrSeussFreak

    ORA-01994 - And MetaLink is wrong

    I appreciate the response anyways :)
  4. DrSeussFreak

    ORA-01994 - And MetaLink is wrong

    nevermind, we recently upgraded from oracle 10.1 to 10.2 and since we made a new oracle home, I had to copy the oracle pw file from the old home to the new home.
  5. DrSeussFreak

    ORA-01994 - And MetaLink is wrong

    I am running a grant and look below for all the details Meta-Link says but when I look at the parameter, I get Any ideas?
  6. DrSeussFreak

    PL/SQL block in JavaScript

    How do I put a PL/SQL block into JavaScript. Using JavaScript, I need that when a link is clicked, the following PL/SQL block is executed. declare begin execute immediate 'ALTER SYSTEM SET ENCRYPTION WALLET CLOSE'; commit; end;
  7. DrSeussFreak

    Help with a query

    if/when it returns a tablespace name, we either alter the existing datafile, or add a new one
  8. DrSeussFreak

    Help with a query

    We have other scripts that look for non-autoextensible files. This script was specifically meant for autoextensible files. For the non-autoextensible files, I have a script written that looks for how many extents are left, and when there are 4 or less it lets me know. I will share this script...
  9. DrSeussFreak

    Help with a query

    SantaMufasa, I bow to your knowledge. With 1 small change your code is the perfect solution to my problem select tablespace_name||' '|| sum(bytes)||' '|| sum(maxbytes) "Tablespace Approaching Full" from dba_data_files where autoextensible = 'YES' having sum(maxbytes)-sum(bytes)...
  10. DrSeussFreak

    Help with a query

    that looks great, but every day I am going to have this report run, how could I make it just return the ones that need attention?
  11. DrSeussFreak

    Help with a query

    Basically, I need the script to tell me when all the files in tablespaces that are autoextensible are full, and a new file needs to be added.
  12. DrSeussFreak

    Help with a query

    Ok, What I would like is for the script to see that yes, this file is at it;s capacity, BUT there is a second file that is not at it's capacity (or a 3rd) and so the tablespace can still actually continue to grow.
  13. DrSeussFreak

    ORA-24350: OCI call not allowed

    From Oracle Meta-Link
  14. DrSeussFreak

    Help with a query

    Mufasa, As always your scripts are amazing. This particular script seems to pull A LOT more data than we actually want to see. Could you possible vie wmy original code SELECT FILE_NAME||' '||BYTES||' '||MAXBYTES FROM DBA_DATA_FILES WHERE autoextensible = 'YES' AND maxbytes-bytes < 2097152...
  15. DrSeussFreak

    Help with a query

    I have also tried joining the table to itself, but I have no idea where to go with that SELECT a.FILE_NAME, a.BYTES, a.MAXBYTES FROM DBA_DATA_FILES a, dba_data_files b WHERE a.FILE_NAME = b.FILE_NAME AND a.autoextensible = 'YES' AND a.maxbytes-a.bytes < 2097152 order by bytes;
See more

Part and Inventory Search

Back
Top