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 strongm 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: *

  1. slaing

    Help with SQL Query Sum(Case When

    2nd guess : Brackets ?? You seem to be opening 5 but closing 6 Steve
  2. slaing

    Upgrading from Access to Oracle

    Brian - Oracle XE is compatible with other Oracle 10 databases. We regularly move data between XE and Std Edition using import and export (and the new data pump import and export too). XE will install on hardware that exceeds its limits - it simply won't utilise 2nd processors, or more than...
  3. slaing

    Copy data from tables present in diff. schema

    Hi, Using a Database Link may be the way to do this. The first part is creating a database link and getting it to work Step1 : make sure that server2 has a tnsnames entry pointing at server1 called (eg) server1tns Step2 : Log on to ORA2 as schema2 and create the link by issuing : CREATE...
  4. slaing

    REDO files messed up, need help

    Aspijker - The timestamps next to the messages at the start of your original post are (roughly) a day apart. Oracle is moving on to the next log file each time the current one fills up (or when you force it with ALTER SYSTEM SWITCH LOGFILE). These messages are perfectly normal and show that...
  5. slaing

    REDO files messed up, need help

    First of all , if your logfiles are only switching once a day , why do you think you need larger ones ? If they were switching every 10 minutes then I could see a case for making them larger. Next, based on your SELECT from V$LOGFILE what you currently have is : 4 groups with 1 member in each...
  6. slaing

    run batch file from windows to do sql jobs

    Another thought ! If the objective is just to avoid having passwords stored where they might be seen, you could use OS Authentication in Oracle and avoid the situation completely. Briefly (in case you haven't come across these) - If your windows (of unix) username is sameer, you create a...
  7. slaing

    run batch file from windows to do sql jobs

    Sameer - Here's a very simple suggestion - if it's not the sort of thing you're looking for then please post a few more specific questions. As you've mentioned 'window' and 'batch' then I'll assume for now you're using a DOS script file. You can pass command line parameters to DOS scripts...
  8. slaing

    PHP Cart & Paypal?

    Here's the sample code I used to try out jpadie's suggestion (just insert your own paypal email address). Note that paypal expects the unit price in amount_x, not the line total <html> <head> <title>Paypal test</title> </head> <body onLoad=basket.submit()> <form...
  9. slaing

    PHP Cart &amp; Paypal?

    That looks like the correct way of doing it , jpadie. From a quick test, it also seems to overwrite the paypal cart rather than adding to it, which was one of my earlier concerns. Steve
  10. slaing

    PHP Cart &amp; Paypal?

    Apologies, William - that was me thinking javascript and PHP at the same time. If you have the cart contents in a database then PHP could read the cart from the DB as your checkout screen opens and store it in (say) javascript arrays. Your screen's onLoad() event could then call a javascript...
  11. slaing

    PHP Cart &amp; Paypal?

    For the 'loop' point - I guess you must be holding the cart contents somewhere local like your database. The Paypal cart opens in its own browser window, so when someone clicks 'Checkout' you can loop round the list of stuff in your cart and add it to the PayPal cart. Here's some (very) rough...
  12. slaing

    New to SQL, performance issues with query.

    Jim- Thanks for pointing out the Skip Scan feature - not one I'd come across (our legacy apps require us to set the optimizer back to 8.1.7 so I guess that's why I don't see them in execution plans). I agree that FTS isn't necessarily a bad thing, but in this case they're happening on...
  13. slaing

    PHP Cart &amp; Paypal?

    Paypal has it's own cart that you can use instead of your own for this sort of thing. However, since you already have your own cart (which I guess you're happy with) you could have a loop which copies from your cart to their cart when they go to checkout. The calls to it are something like...
  14. slaing

    Anybody have issues using RDP into server 2003??

    Same as dudenjersey , I get the message you posted above, but when I click Yes is connects. That's connecting to the original SBS2003 (not R2), and with Vista Business edition (build 6000), Windows firewall running 'out-the-box' Couple of things come to mind - 1) Vista tries to log on with...
  15. slaing

    New to SQL, performance issues with query.

    TABLE_ACCESS_FULL means that it's reading all rows in a table rather than using an index. What are the indexes on SURVEY_RESULTS and SURVEY_CUSTOM ? Can your DBA confirm that all indexex on those tables are valid ?
  16. slaing

    New to SQL, performance issues with query.

    Ha! Thanks, carp - I should have read the text more carefully rather than just staring at the code ! As QUESTION.QUES_VER_CONTENT isn't indexed then my 2nd point isn't really significant. Also, in (1) I should have said 'up to date statistics' Steve
  17. slaing

    New to SQL, performance issues with query.

    Hi, A few things spring to mind - 1) Have you analyzed these table so that the Oracle optimizer has got some statistics to work with ? The following statement will do that for a table SQL>ANALYZE TABLE table_name COMPUTE STATISTICS; 2) Modifying a column in the WHERE clause will stop...
  18. slaing

    What patch do i use?

    I'll say 'should be OK' in answer to that. I use the same 32-bit Windows install kits and upgrades on Win 2000 (Pro + Server), Win 2003 Server, and XP SP2 without any problems. If anyone has found XP specific kits, hopefully they will let us know. Steve
  19. slaing

    What patch do i use?

    On Metalink, go to the 'Patches & Updates' Tab and search for RDBMS patch sets for your OS. The 9.2.0.8 patch set is about 245 Mb and is cumulative (ie it can be applied directly to 9.2.0.1) As Ken suggests, the patches you've listed look like individual bug fixes which can be applied after...
  20. slaing

    Removing a db

    Dave - Any particular resaon why you're not advocating using DBCA to do most of the work in deleting an instance ?? I've not had any bad experiences with it ,although IIRC there might be a few minor files to delete manually afterwards. I'd also suggest taking a full export of the DB as well...

Part and Inventory Search

Back
Top