Search results for query: *

Hi, I guess this might come down to more of a unix command then perl question. I want to write a script that will delete any file with similar name for the particular month. The files under the directory are name such as below: -rw-r----- 1 oracle dba 20353024 Jul 3 23:00...

I have found out that when I change the permission for the file to 644, then the * will be gone. If I do 777, then there will be * in the end of file for example: -rwxrwxrwx 1 appdb31 dba 8236 Sep 29 13:08 NewOverLoadGraph.jpg*

Thanks Chris for the quick reply. I have tried this and it is still not working though.

Well, this question is rather about unix permission then scripting. I couldn't find an appropriate place to post. Anyway, I have a question regarding unix permission. I have a file. While the owner of the file issued chmod 777 to the file. Supposedly other users should be able to write and...

I have about hundreds of files under the directory /u01/stat/oradata/arch named from 1_1_880795724.dbf to 1_177_880795724.dbf I want to rename all these files to stat_1_1_880795724.arc etc. How can I achieve this in a single command? I wrote a perl script, but it is not working even for just...

I tried man top and the system says no manual entry for top. I am not an OS person. I am trying to understand the TOP output load averages: 0.25, 0.25, 0.25; up 249+00:47:10 16:04:26 173...

Thank you very much Feherke. It worked like charm.

Ok. I fixed the message problem. I moved #!/usr/bin/perl to the first line above all my comments. The scripts executed without any message. But the directory didn't get created. Maybe it is because my script is residing at a separate directory than those files are actually are? Let me move my...

Hi feherke: When I try to execute the script that you provided, I got the following message: ./move_trace_rtest.perl[10]: use: not found ./move_trace_rtest.perl[11]: @today: not found ./move_trace_rtest.perl[12]: =: not found ./move_trace_rtest.perl[13]: syntax error at line 13 : `('...

Hi Feherke: Thanks for your reply. The copy command that you used in your script, does it work the same as unix mv command? The reason I am asking is that I want to move the files to a new folder. Not just copy the files to the folder and leave the original alone. Another thing, if the date...

The purpose of my script is to go through a directory of all the files. Look at the creation date for those files. Say for example, if a file is created in 2008, I will create a 2008 folder under the directory and move the file into the new 2008 folder and loop through the whole directory with...

When I issued mysql -u root -p I got the following error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I checked the system, it's because the mysql serice is not running on the server. Our mysql admin left the company and I am taking over...

I forgot to add one thing is that I am copying the database within the same server, not from one server to the other. I just want to make a copy and not to delete the original commerce database. Thanks.

I am fairly new to mysql. It took me a while just to login to the database. Anyway, long story short. My mysql version is 4.0.18. I have a database in mysql called commerce. I need to make an exact copy of this database (with all the tables, etc) and call the new database commerce2. How can I...

Hi Feherke: I found the server that I have trouble to get any of the mysql command to work is the client part. However, when I try to login to the server part. I am still having trouble. mysql -u root -p ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) How should I...

One of our dba has left the company. He used to be responsible for the mysql database. I don't have much experience with mysql. I did get to login to the server. However, when I issued mysql -u=root -p, the messages -bash: mysql: command not found returned. I issued ps -ef|more, it returned...

We did the sterling integrator 5.0 mapping test. After putting info for login dashboard server, and click the test button. It pops up a message says failed to resolve ip address. But if I use the same ip and port number and put it in internet explore address bar, it will bring up the page for me...

Right now, I have several servers with the same database name on different servers. But now I need to consolidate those databases onto one server. Obviously, I cannot have on server with five or six databases with the same name. How will I approach the migration differently? Right now I start...

Thanks. That does the trick. Once I know what the error is, I know exactly what I need to fix. Learn something new everyday.

Well, the error is not specific. SQL> @crt_trg_ttiitm001.sql Warning: Trigger created with compilation errors. I am not sure where can I look for the error.