Search results for query: *

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

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.

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

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

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

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?

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

Has anyone got a user guide for the utility tk_prof Thanks in advance Paul Tried Metalink but no joy. Site is not working properly.

Dear All, I have some data in a column e.g G457435732 H475894374 123456465 S405843280 876546123 And I am trying to select only the data that starts with a letter. I tried:- select * from <table> where column like '{A-Z}%' But without success. How do you select only rows that start with only one...

I am trying to eject a tape after a Oracle failed install. But using pfs_umount /cdrom is returning this message:- umount: /cdrom: Block device required Has anyone got a idea how I might unmount the disk in the cd drive?

How do I find out how much memory I have and how many memory ram boards I have in the Unix box? Many thanks in advance Paul

Does anyone know what this code means. I could not recover some files from tape using frecover -x -X -g <fgraph file location> Is there a list of error codes anywhere? Hp docs are a nightmare to look through!!! Cheers Paul

How do I find out weather my operating system is 32 or 64 bit? Many thanks in advance Paul

Dear All, Is there anyway of finding out if anyone has tried to login in over telnet but failed. My main aim is to find out if anyone is trying to hack my Hp-UX 11 box. Any ideas welcome Many thanks in advance Paul

Dear All, I am trying to add a volume group to a system I have cloned. However I have used the command:- #pvcreate -f /dev/rdsk/c2t0d0 The error message tells me that the physical volume has already been recorded in the &quot;/etc/lvmtab&quot; file. Any idea's? I've tried to modify this file...

Dear All, I am trying to restore a backup from tape and the TERM type is set to vt100. This needs to be changed to hp. I know I have to us GSP but what command in GSP do I need to use to change the TERM from vt100 to hp? Many thanks in advance

Dear All, I have a problem with /var. It seems to be growing and I can not pin-point where. Is there a hp-ux command that would allow me to look at the /var logical volume and pick out the ten last amended files? Or the ten largest files in this logical volume? Many thanks for your help in...

How would you add an ; to the end of the line in vi. I am looking for a command that adds ; to the end of every line recursively Many thanks in advance Paul C