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!

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

  • Users: hoinz
  • Order by date
  1. hoinz

    cannot access shared folder

    Just a guess: In order to access /home/user1/whattosharefolder, user2 will first need permission to access /home/user1. chmod ugo +x /home/user1 hope this helps
  2. hoinz

    Count up several variables ...

    As feherke pointed out, this looks like one of those questions that shouldn't be tackled with a brute force attack. A little bit of common sense and elementary mathematics should suffice, I think. SPOILER WARNING! If you insist on finding a solution with the help of a computer program, stop...
  3. hoinz

    Sending HTML formatted message into Outlook 2010

    As far as I know mailx can't send in html format. Is it an option to send the file as an attachment (-a option of mailx) ? For that rename it from *.log to *.html. Or try sendmail instead. regards
  4. hoinz

    Redundant blank line generated

    Actually you have got two redundant blank lines.[wink] The other one is at the very end. That's a feature of sqlplus output: Whenever an ouput line is split across several lines, the next line will be left blank for better readablity. If this behaviour is undesired, you may switch it off with...
  5. hoinz

    Limiting results from query, unique but not?

    PS: Sorry; MINUS is not yet available. I had another database in mind .... :-(
  6. hoinz

    Limiting results from query, unique but not?

    Perhaps this is what you are looking for: SELECT number FROM daTable MINUS SELECT number-1 FROM daTable
  7. hoinz

    Problem with rman delete backup

    Could be a problem with operating system file permissions. Check whether the OS user who is running rman actually has permission to delete. regards
  8. hoinz

    sort by specified field(s) doesn't work as expected !!!

    Not sure about Solaris; on HP-UX 11.23 I see this:
  9. hoinz

    Procedure question

    Have a look at Prepared Statements http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html
  10. hoinz

    Relationship of CDCLS, CDHDR and CDPOS

    Afaik cluster tables may be converted to transparent tables and vice versa. Therefore only you will be able to answer the question whether tables CDPOS and CDHDR are pooled in your system. Call Transaction SE11, enter CDPOS or CDHDR, and click display. You will see either Cluster table or...
  11. hoinz

    Solving Query

    Hello Cassidy, a lot of mathematicians already spent hours or years about your problem. they call it the subset sum problem, a special case of the notorious knapsack problem. Not going to discourage you; but maybe you will get a few ideas from there...
  12. hoinz

    Formatting script output into columns

    pipe to paste command perhaps?
  13. hoinz

    Read from /dev/ttyS0 via shell script

    glad it helped, thanks! [smile]
  14. hoinz

    Read from /dev/ttyS0 via shell script

    Hello, I had similar problems a long time ago on some flavour of Unix. Problem was that all kind of initialising like stty only helped as long as the execution of stty command ran, that is, new settings were gone immediately. What helped finally was this: Create some process that will run on...
  15. hoinz

    WorkspaceMan & constraints of versioned tables

    A striking difference: alter table RIVERS_LTS disable constraint INDX_10_RIVER_FK; ORA-02431: cannot disable constraint (INDX_10_RIVERS_FK) with or without S ? a typo ?
  16. hoinz

    Using nice with sqlplus

    Hello, I never tried it myself. I agree with your assumptiom that any process called by another should inherit its parent's priority. If you see that sqlplus still affects the application significantly: Did you verify that 'nice -19' did work, e.g. with 'ps -el'? (not sure about the correct...
  17. hoinz

    sqlplus dos not work with <SID>adm

    In this case you better had asked in SAP forum, but anyway: Most probably permissions (owner and s-bit) of your brbackup and brconnect programs are not set properly. Owner should be ora<sid>, and permissions like rwsrwxr-x. Have a look at SAP note 113747, btw. hope this helps
  18. hoinz

    sqlplus dos not work with &lt;SID&gt;adm

    It seems you are working with an ERP system from SAP. Simple answer in this case: sqlplus is not supposed to work with user <sid>adm. Try user ora<sid> instead.
  19. hoinz

    How i can backup Oracle DB with Legato 7.4 sp3?

    Hello, regarding MAXDB, formerly known as SAP DB: I suppose you are an SAP customer. In this case you may start with their online documentation, e.g. SAP notes 822240 (FAQ: MAXDB and external backup tools) and 338903 (Backint for MAXDB). SAP note 767598 will tell you where you may find more...
  20. hoinz

    An index on a constantly changing table?

    You seem to believe that an index has to be unique. This is not true. Just omit 'UNIQUE' keyword when creating. And a non-unique index may speed up a query as well. hope this helps

Part and Inventory Search

Back
Top