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!

Search results for query: *

  • Users: THoey
  • Order by date
  1. THoey

    Is DBA a Salary or Hourly position?

    ...chain to try to convince them that this is not in the best interest of the company. So please, as many responses as I can get please... Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum...
  2. THoey

    SQL to determine locks

    Did a search in help and found the locks tab in the Session Browser. Thanks again Dave. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to...
  3. THoey

    SQL to determine locks

    ...able to be online as much, it looks like that was revoked. But I really appreciate everything you and other members of this site provide. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum...
  4. THoey

    SQL to determine locks

    ...I am needing to take it a little further and see the query that is actually causing the lock. Is there a way to do that? Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a...
  5. THoey

    THoey

    My name is Terry Hoey and I am an Oracle DBA for AT&T in San Antonio, TX. My contact information: Terry Hoey 9551 Bare Back Trl San Antonio, TX 78250 thoey1963@sbcglobal.net
  6. THoey

    Kaspersky found a virus

    Thanks. All clean now. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This...
  7. THoey

    Kaspersky found a virus

    ...-- End of file - 6695 bytes AVG Log: Virus found Win32/Heur C:\Documents and Settings\Terry\Local Settings\Temp\uolmgnz9.exe Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a...
  8. THoey

    Exporting LOB Tables

    ...tables with CLOB fields try to write to a specific tablespace and the rest write to the default tablespace for the schema. Thanks again. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum...
  9. THoey

    Exporting LOB Tables

    ...finished our deployment to that server on Friday and it is in use now. I'yy try to do it when we have our next deployment. Thanks again. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum...
  10. THoey

    Exporting LOB Tables

    ...three tables fail creation when imported. Thanks for hanging in there Tharg. I am just trying to get my hands around this concept. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has...
  11. THoey

    Exporting LOB Tables

    ...exist on that DB, so I can grant the schema permissions and then try to move it to the appropriate tablespace, but that seems unnecessary. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum...
  12. THoey

    Exporting LOB Tables

    ...IMP-00003: ORACLE error 1950 encountered ORA-01950: no privileges on tablespace 'SMFDATA' Import terminated successfully with warnings. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has...
  13. THoey

    Exporting LOB Tables

    ...The only difference I can see in the tables that generated the warning were new tables with fields of LOB type. Suggestions or comments? Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum...
  14. THoey

    Scripts to write scripts

    ...by 1; v_str varchar2(10000); begin dbms_output.enable(1000000); for crec in cr1 loop v_str := 'insert into test2 '; v_str := v_str || ' select * from test' ; v_str := v_str || ' where trunc(call_date) = to_date('''; v_str := v_str || to_char(crec.call_date,'dd-mon-yyyy') ||...
  15. THoey

    Scripts to write scripts

    Okay, we are getting close. The below result snippet is just the end of what was generated: insert into test2 select * from test where trunc(call_date) = to_date('25-jun-2007','dd-mon-yyyy') insert into test2 select * from test where trunc(call_date) = to_date('25-jun-2007','dd-mon-yyyy')...
  16. THoey

    Scripts to write scripts

    Duh... I guess it might help to know what the errors are. With the above script, I get the following error: spool off; * ERROR at line 15: ORA-06550: line 15, column 1: PLS-00103: Encountered the symbol "SPOOL" If I comment out the SPOOL commands, the procedure runs, but I get no output...
  17. THoey

    Scripts to write scripts

    ...by 1; v_str varchar2(10000); begin dbms_output.enable(1000000); for crec in cr1 loop v_str := 'insert into test2 '; v_str := v_str || ' select * from test' ; v_str := v_str || ' where trunc(call_date) = to_date('''; v_str := v_str || to_char(crec.call_date,'dd-mon-yyyy') ||...
  18. THoey

    Scripts to write scripts

    Sorry for the late response. Thanks Engi. I will give this a try and post a response if it does what I am looking for. Terry ************************** * General Disclaimer - Please read * ************************** Please make sure your post is in the CORRECT forum, has a descriptive...
  19. THoey

    Scripts to write scripts

    ...in a table, I would run this script and it would create a set of scripts like the following: insert into easl_prod_history.call_history select * from easl_prod.call_history where trunc(call_date) = '01-JAN-07'; commit; insert into easl_prod_history.call_history select * from...
  20. THoey

    Scripts to write scripts

    ...to populate the DISTINCT TRUNC dates of the data. The basic query for one day would be: insert into easl_prod_history.call_history select * from easl_prod.call_history where trunc(call_date) = '09-APR-07'; commit; Any Suggestions? Terry ************************** * General...

Part and Inventory Search

Back
Top