Thanks Mag0007 for the help... I have tried both the
mailx user@hostname and
mailx user but the mail kept to be in the deferred state.
After a lot of searching in may places I decided to check the permission of the whole /usr file system of a working server and of the one which is not working...
People,
I have a question regarding AIX 4.3.3, we have sendmail that relays email to our email system, thus it allows us to send administrative emails with output from crons etc.
One of our systems is behaving a bit strange as it is not sending mails locally and when view the mail queue via...
People,
I need to determine the details of a release for example what 9.40.UC3x2 means.
I know that in oracle 8.1.7.4.0 means
8---> Major database release number
1---> Database maintenance release number
7---> Application server release number
4---> Component specific release number
0--->...
When a table stores LOB's together table data does it hinder performance. On some other database recommand that BLOB/CLOB are saved inside a separate tablespace specifying the correct blobpage/page size. Does is same apply for oracle 8i.
People,
I managed to find a method:
If an index such as that of primary key is created named
ALTER INDEX <idx_name> TO CLUSTER;
This causes table to be reorganized by the index and automatically defragements the table.
Afterwards ALTER INDEX <idx_name> TO NOT CLUSTER;
Otherwise create an...
Thanks, for the suggestions the table has 5.4 million rows.
I wish to avoid unloading and reloading again the tables. As there circa fifteen tables which are quite large, and I do not have too much free filesystem space.
I am running ids 9.30.uc2 on a linux machine, on one of other production servers. During maintaince job we noticed that there are a few tables that have over 110 extents.
Is there there a way to defragment the table without going through an export and an import ?
Any suggestions welcome.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.