Search results for query: *

Another possibility is outlined in Tom Kyte's book, expert one-on-one Oracle, in the chapter on Optimizer Plan Stability. Namely the section entitled, To See the Indexes Used (pg 515), where he describes using stored outlines to grab the names of the indexes being used I know you posed to the...

Whoops, wasn't paying attention to the example results. Sorry!

<select statement 1> INTERSECT <select statement 2>, is one possibility. Take a look at the Oracle SQL Reference Manual for more info.

Here's a quick and dirty way. I'm sure it could be done in a slicker fashion... FAIL=`grep -c FA test` if [ $FAIL -ne 0 ]; then FAILURES=`awk '/FA/ {print $1}' test` for job in `echo $FAILURES`; do SUBJECT=&quot;$SUBJECT $job&quot; done echo whatever | mailx -s &quot;The Following...

After an event is processed, it goes to the event repository. The main table is called tec_t_evt_rep. The schema is described in the TEC 3.6 Release Notes, and the 3.7 Reference Manual. I am a little confused as to exactly what you want to do though. You say you want to Select * from <table>...

Well, to source the environment from a bash shell, you'd want to do something along the lines of (the &quot;.&quot; instructs the shell to read and execute commands from filename and return): . <filename> e.g. . /winnt/system32/drivers/etc/Tivoli/setup_env.sh

I don't necessarily think this is a similar problem, but you'll need to follow the instructions under &quot;Changing the IP Address of a TME 10 Server&quot; found in, for example, the Framework 3.6 Planning and Installation guide (pg 13-34). Basically, you want to start the oserv on the...

Well, I'm under the impression that you have to create the filesystem with this option. So, to convert, you'd back up the existing filesystem and create a new one. But, maybe you want to ask aix support.

What are you going to write it in? You could do it in Java, and use JDBC. You may want to look at the JDBC Developer's Guide and Reference (for the 9i version, http://tahiti.oracle.com/pls/db901/db901.docindex?remark=homepage#index-JDB). You could use Perl as well, with a database interface...

It would appear that the uid, tivoli, is not mapped to a Tivoli administrator (which root is). Read about Tivoli administrators (you associate OS uids w/Tivoli administrators), check out the wgetadmin/wcrtadmin/wsetadmin commands. This info is in the Framework documentation (available for free...

To enable a filesystem for large files, you need to specify the option &quot;bf=true&quot; when you create it with the crfs or mkfs commands (or use the jfs smit menus).

Glad you found your problem. Usually, it would either be the oserv is down, or the o_dispatch environment variable wasn't set (which was your case).

You didn't post what you're trying to do. Is the &quot;oserv&quot; process running?

How about something like: use Time::Local; sub getSecs { my ($rawtime1, $rawtime2) = @_; my ($rawyr1, $rawyr2, $rawmon1, $rawmon2, $rawday1, $rawday2, $rawhr1, $rawhr2, $rawmin1, $rawmin2, $rawsec1, $rawsec2, $epoch1, $epoch2); ($rawcal1, $rawclock1) = split(/ /, $rawtime1)...

All, Try the following when you want to remove any extra Tivoli endpoint services: wadminep good_ep spawn_process &quot;path_to_lcfd/lcfd.exe&quot; -r lcfd-1 Be sure you don't kill the service for the good endpoint. This works... I used it yesterday. later.

Get the SQL*Plus User's Guide from http://tahiti.oracle.com/pls/tahiti/tahiti.docindex and read about Formatting Query Results (like setting linesize and formatting columns with the COLUMN command)

Go to http://technet.oracle.com, click on the membership icon along the top of the page, and create a free account. There you will find installation guides for each platform (along with other documentation). http://technet.oracle.com/docs/products/oracle8i/content.html

You can read about the default initialization files in the Solaris 8 System Administration Guide, Volume 1. http://docs.sun.com/?q=local.cshrc&p=/doc/805-7228/6j6q7ueol&a=view

Are you using the Spreadsheet::WriteExcel module? If so, have you tried reading the documentation for it? http://search.cpan.org/doc/JMCNAMARA/Spreadsheet-WriteExcel-0.37/WriteExcel.pm The example shows how to accomplish the task.

It would be helpful if you could post simplified test cases (perhaps cut and paste from sqlplus) showing your working and non-working queries. Have a look at the following link to see some valuable advice on date comparisons...