Search results for query: *

Thanks Ken good idea, like it.

how can I get yesterday's date with the date command? So if today is Thursday how would I get the output Wed? Many thanks in advance Paul

found a solution on kbase. This solution is for an internal tape drive on dl380, which is what I've got. Go to http://kbase.redhat.com and search for tape cciss and click on the first result. Title starts:- My HP server shipped with a tape drive connected... This article solved the issue.

No other tape drives and no /dev/st0.

Dear All, I've just built my first 5 Linux boxes with AS4 update 2. After the first it was plain sailing. However the hardware is a Compact/HP dl380 with a HP DAT72 tape drive. Any idea what the device address is? or whether there are additional drivers I need to install to see it.

Good thinking guys, thanks cgainey and kenC. I had 2800 of the things to do so was going a little mad with the last bit of text. sry. did a copy of passwd too, thought about the importance of it. but thanks again kenC Cheers Paul

use ,.. in the second field of the /etc/passwd file makes a new user change their passwd at first login. I'm great!!!

Hi All, Can someone tell me how to set a default passwd when I create a newuser using the useradd command. Don't think there is an option with useradd and passwd command doesn't seem to help too mucj. Using hp-ux 11iv1 Cheers in advance Paul

Dear All, i am trying to select from a partition called PART1:- Select * from config (PART1) where config_value='Y'; But keep getting error ora-00933. I have copied the syntax from the book and it doesn't work. Any ideas? 2 partitions are setup on the table for the config_value column less...

Answering my own question here!!! Okay, what I did was nearly right, but the command to roll forward is:- -recover database using backup controlfile until cancel; -AUTO -alter database open resetlogs; This recover command will look in the archive directory and apply all archive logs...

Dear All, I have been trying to roll a db forward using *.arc logs. So far I have created a db with archiving and taken a cold backup. I then added tables with data to create *.arc files. I then stopped the db and replaced it with the orginal cold backup files. Started the db in mount only mode...

Thanks for your reply but the csv file is included in my first post and it doesn't have any nulls:- csv file "00359429","0001","0001" "00359429","0002","0001"

Has anyone got a user guide for sqlldr, having problems!!! Or Anyone help with this install, I have a copy of the ctl file,the csv used and the loadlog results. Can't seem to get the right datatype. The table's 3 columns are all datatype number(38). ctl file LOAD DATA INFILE gaamaa_test.csv...

Dear All, I have tried to migrate from 8.1.6.0.0 Enterprise Edition to 8.1.7.0.0 Standard Edition using odma and it seems to have worked. Has anyone got an 8.1.7.0.0 standard edition db and if so what does the results of this produce:- Select * from v$version; 8.1.6.0.0 EE gave me :- Oracle8i...

So all I've got to do is install the standard edition software for 8.1.7 and do a normal migration with odma utility? Many thanks in advance Paul

Can you migrate from 8.1.6 Enterprise Edition to 8.1.7 Standard Edition Or to the same release. Basically can you go from enterprise to a standard edition? Many thanks in advance?

True, could do this as well. Thanks Paul

It's just that all the tables in the db except 3 are in the same schema. Just wanted them all in the same schema. Thanks anyway Paul

Dear All, Can anyone tell me how to move a table from one schema to another. Can't seems to find the command anywhere. Many thanks in advance Paul

Many thanks for this, I think I was trying too many words in Google, because tk_prof user guide returns hardly any results. Thanks again. Paul