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

    sendmail daemon is not working

    syslogd output the following info: Jul 31 23:01:31 QC_P550_719 mail:crit sendmail[2122140]: My unqualified host name (QC_P550_719) unknown; sleeping for retry Jul 31 23:02:00 QC_P550_719 mail:alert sendmail[2453880]: unable to qualify my own domain name (QC_P550_719) -- using short name Jul 31...
  2. signalsys

    sendmail daemon is not working

    lssrc -s sendmail" shows it is inoperative, then i use "startsrc -s sendmail" and its' status turns to active. But about 1 minutes later it turns to inoperative again. What cause the problem? Thx in advance
  3. signalsys

    What is the difference between $@ and $* ?

    Thx in advance
  4. signalsys

    what's the meaning of TIME=${@:-5}

    what's the meaning of TIME=${@:-5}
  5. signalsys

    rsh runs Ok, but rcp command always fails

    Thanks for your guidance
  6. signalsys

    rsh runs Ok, but rcp command always fails

    rsh runs OK, but the rcp command below fails P670_2-doma%rcp -rp acce.cfg P670_7:/tmp/ who: 0551-012 The process is not attached to a terminal Thx in advance
  7. signalsys

    How can i refuse a user ftp to my server ?

    Two users A and B i allow A to ftp to my server , But B not. What can i do ? Thx in advance
  8. signalsys

    How to monitor Parallel DDL's execution?

    We can monitor Parallel DML's execution throught v$pq_slave. What about parallel DDL's execution, such as create index statement ?
  9. signalsys

    weird cron problem

    Hi,p5wizard and khalidaaa Thanks for your helps
  10. signalsys

    weird cron problem

    I once had place the following entry in crontab, I only want it to be automatically executed on August 14th 10:23 am. 23 10 14 8 1 date >> dat.out But after a week, On August 21th also Monday it was run again. it seem that cron neglect the month and day in cron. Why could this happen ? A...
  11. signalsys

    A column is needed in MV,What if i don't include this column in MV log

    I have created the following MV log and MV(empno was the only primary key in empbak). create materialized view log on empbak with primary key including new values; create materialized view mv_empbak build immediate refresh fast on commit as select empno,ename from empbak; Note that when...
  12. signalsys

    How to match the output exactly?

    Thanks for your help
  13. signalsys

    How to match the output exactly?

    I have the following devices in my system: hdiskpower10 hdiskpower100 hdiskpower101 Now i only want to get the information about hdiskpower10,so i use "lspv | grep hdiskpower10",but it outputs information about all the 3 devices: hdiskpower10 vg1 hdiskpower100 vg32 hdiskpower101 vg32 What can...
  14. signalsys

    How to compare two string variables?

    two string variables: var1="0123' var2='01BD' What syntax should i use to compare the two variables and output the bigger one? Thanks in advance.
  15. signalsys

    PINS in v$librarycache

    PINS : The number of times a PIN was requested for objects of this namespace PINHITS : The number of times all of the metadata pieces of the library object were found in memory RELOADS : Any PIN of an object that is not the first PIN performed since the object handle was created, and which...
  16. signalsys

    Any distinction between star and star_transformation ?

    What's the difference between "star" and "star_transformation" used as hints ?
  17. signalsys

    How to prevent the sort operation from happening in sort merge join ?

    Hi, I tried creating an index and add a not null constraint on deptno but lead to the same result.
  18. signalsys

    How to prevent the sort operation from happening in sort merge join ?

    SQL>explain plan for select emp.deptno,dept.deptno from emp,dept; Please look at the execution plan for the above statement,there is a sort of table emp before it is merged to table dept SELECT STATEMENT, GOAL = CHOOSE 12 70 280 MERGE JOIN CARTESIAN 12 70 280 TABLE ACCESS FULL SCOTT DEPT 2 5...
  19. signalsys

    Order by clause in an union set operation

    If i use an alias in the order by clause, error appears: SQL>select 'sing' as mydream, 3 a_dummy from dual union (select 'I''d like to teach',1 from dual union select 'the world to',2 from dual) order by a_dummy; ERROR at line 3: ORA-00904: "A_DUMMY": invalid identifier When i use a position...
  20. signalsys

    Sorts can be avoided by creating index with asc or desc attribute?

    I have the following tests with tables in scott's schemas: SQL> set autotrace trace SQL> select * from emp order by ename; 14 rows selected. Elapsed: 00:00:01.26 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=5...

Part and Inventory Search

Back
Top