Search results for query: *

...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...

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...

...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...

...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...

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...

...-- 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...

...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...

...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...

...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...

...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...

...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...

...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...

...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') ||...

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')...

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...

...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') ||...

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...

...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...

...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...