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 Chriss Miller 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?

    Hi all... My job has recently moved me from a salaried position to an hourly position and we are already running into issues bumping against my "schedule". I am trying to gather information to take back to my management to show that it really isn't in their best interest to have me on a...
  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

    Actually, I do have access to it, just haven't got used to using it. So many things you can do there that I get a little lost. If you can point me in the right direction that would help. I think I would still want a query eventually as some of my offshore team does not have access to...
  4. THoey

    SQL to determine locks

    SantaMufasa had a great reply to thread759-1363380. 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...
  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

    All, been trying to clean up a PC. Was getting the following error: Generic Host Process for Win32 Services has encountered a problem and needs to close. I ran Spybot, Adaware and SuperAntiSpyware and cleaned anything I found. Ran Norton's and it said it was clean. Then I ran Kaspersky's and...
  8. THoey

    Exporting LOB Tables

    Just a follow up. I was able to grant unlimited quota to that tablespace and then the import performs without an issue. Just weird that only the 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...
  9. THoey

    Exporting LOB Tables

    Thanks for following up. Unfortunately, I will be unable to let it run through just to test the import. We 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...
  10. THoey

    Exporting LOB Tables

    Maybe I am misunderstanding, but shouldn't it try to load to the default tablespace of the new schema it is being loaded into? That being asked, all of the tables in the export (82) are stored in the SMFDATA schema of the exported instance, but only these three tables fail creation when...
  11. THoey

    Exporting LOB Tables

    Yeah, that is the major issue. I am trying to figure out why the import is trying to use a tablespace besides the default. I ended up letting it run and then recreating the tables via scripts, but it was just a question I had. Luckily, right now those tables are empty. Next time we do...
  12. THoey

    Exporting LOB Tables

    To me the issue is that due to them having LOB's, they are trying to write to a different tablespace than the default that I want it to. All the other tables get created in the default tablespace fine. Below is the log: Connected to: Oracle Database 10g Enterprise Edition Release...
  13. THoey

    Exporting LOB Tables

    Are there any known issues with exporting LOB tables? I did an export from database A, schema A. Then did an import of that data into database B, schema B. The import generates warnings as it is trying to create three of the 82 tables in a particular tablespace instead of the default user...
  14. THoey

    Scripts to write scripts

    Bill, Engi and Dave, Thanks so much. As I said, this was just one example of a case where I needed to do something like this, so it was a learning process. I appreciate everone's input as it all helped to end up with the final result. Code: set define off; spool C:\test.sql; set...
  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

    Sorry Bill, I think you are missing the question. There are too many records in this table to move them over at once like you describe. So I am wanting to learn how to write a script that will go through a large table and create a set of "move and commit" scripts so that I don't blow any...
  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

    Thanks for responding. In this instance it would be run on an adhoc basis. But really, I am just wanting to learn how to do this for any adhoc instance. So, in this case, for every grouping of trunc(date) data in the table, I want to move the data, and commit it. An example would be I...
  20. THoey

    Scripts to write scripts

    I have gotten pretty good at writing SQL that generates other SQL. But try as I might, I can't figure out how to add this twist to it. I have a call history table that has a record with data for each call into our system. I need to move this data from one schema to another in. Since...

Part and Inventory Search

Back
Top