Search results for query: *

Genius! Many thanks.

How can I use VI to find a "/"? For example, I have a script which moves a lot of files to another directory. The directory structure in the script is wrong so I want to search for "$HOME/stnd_by/one" and replace it with just "$HOME/one" if I do: :%s/stnd_by//g I end up with "$HOME//one" on...

Mutley, many thanks, Excactly what I needed. Thanks.

I want to be able to show the details of all tables, ie, the table name, the colums and their lengths. Something similar to "desc" in Oracle. I need to do this to all the tables in my MS Sql database and to get a list of the data output. I.E: Table1 name of table 1 column1 length column2 length...

Hi, How can I view the physical disk layout in linux? Not a df -k to show the partitions, but how many disk and of what size are present on the machine. A bit like windows when you go to computer manager and look up disk manager. Thanks.

I am haveing trouble with our virus software. Basiclly the software creates a user account which is then used to access the repository server to get updates for user workstations. This account keeps locking out which is stopping the updates from taking place on a number of computers. I...

Many thanks, will play around with your code to see whats what and how it all ties together.

Im trying to create a linked server in MSSQL query analyser to connect the MS SQL database running on Windows 2000 to an Oracle 9i system running on Linux. I have managed to get Oracle to talk to MS SQL but now need it working the other way around so that I can select data from MS SQL. The...

Thank you so much, you have made me see the wood for the trees! The MS SQL database I am working on has table names named so confusingly it is very difficult to decipher what is what. Take the code: "iScalaDB"."dbo"."_GL030106_CC" "_GL030103_CC" There is a table called "_GL030103_CC" in the...

...ON "_GL030103_CC"."Acc Dim"="_GL060103"."Client Contact Num" WHERE not "_GL060103"."Account" in (N'80000000',N'70500000',N'46110001') /* Take out Stats, Income and Old accounts */ and "_GL060103"."Client Contact Num" <> N'100000' /*Ignore NASS Accounts */ and "_GL060103"."Emission...

...ON "_GL030103_CC"."Acc Dim"="_GL060103"."Client Contact Num" WHERE not "_GL060103"."Account" in (N'80000000',N'70500000',N'46110001') /* Take out Stats, Income and Old accounts */ and "_GL060103"."Client Contact Num" <> N'100000' /*Ignore NASS Accounts */ and "_GL060103"."Emission...

...Oracle server: create database link tg4msql connect to "sa" identified by "password" using 'tg4msql'; I then tried a: select * from all_catalog@tg4msql; and get: Ora-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NEWTORK/NCR message...

Oh and thanks for all the replies.

Found it! Found that I had LD_ASSUME_KERNEL=2.4.19 set in my users profile, but this wasn't being exported with the script for some reason. All working now as expected!

Yep, the user is oracle9 which is in only the DBA group and is the one I login aswell as the one who runs the cron script. Ive just tried the script in cron and it failed with same errors. Im gonig to strip out all the ENV variables and just have ORACLE_HOME, ORACLE_SID and ORACLE_HOME and...

Well Im a litte confused now. It must be some env setting Im missing. I thought I would try the above suggestion and up until now have been running the script on the server itself, but whilst at my PC I thought I would login via Absolute Telnet and run the script so I could copy and paste the...

Sorry, I should really put all the info down shouldn't I! I have tried both, selecting the name from v$database and it returns the same error oracle not avaialable. I tried the EOF way as well but again, the same thing happened. Here is the full script the sqlplus -s command is commented out...

Sorry yes forgot to mention, all the env settings are set correctly. I even echo'ed ORACLE_SID and ORACLE_HOME to a file to make sure they have been set and all is as expected.

Thanks for the reply, but its not that. Still gives same error.

Can anyone shed some light on this problem. Firstly, we have a cron job which transfers all our redo logs from a primary database server to a standby database server. Both running Oracl9i on Red Hat Linux Ent 4. I'm trying to write a script to do a recover on the standby databse some time...