Question
What is the maximum number of partitions you ever had in a partitioned table?
Less than 100
Between 100 and 500
Between 500 and 1000
Between 1000 and 2000
More than 2000
I never used partitioning
No idea or not applicable
Answer and see the results
Download PLATO
The free tool for auditing and tuning your database
Version 52 now available
Jul 12, 2010
The DBA-Village forum
Forum as RSS
as RSS feed
DBA Top 10
1 M. Cadot 146300
2 F. Pachot 130200
3 B. Vroman 77200
4 A. Kavsek 62650
5 P. Wisse 52900
6 T. Boles 52350
7 Z. Hudec 41600
8 A. Chavan 25700
9 A. Deledda 23200
10 V. Swamy 17625
About
Site Statistics
Ever registered41903
Total active users26384
Act. users last 24h318
Act. users last hour15
Hits last week5251
Hits last month21266
Go up

auto update ftp script
Next thread: remote export
Prev thread: ORA-01940: cannot drop a user that is currently connected

Message Score Author Date
Hi, i want to write a script which auto updat...... vanishri N Dec 28, 2004
Hi, in the script what ever action you want to ...... gouri sankar Dec 28, 2004
The request is not very clear. Do you have problem...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Zoran Hudec Dec 28, 2004
Do you think your question is in any way related t...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts SUBROTO MUKHERJEE Dec 29, 2004
Mr. Zoran Hudec, requarding you hudge and vast tec...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts SUBROTO MUKHERJEE Dec 29, 2004
SUBROTO, what is your point? Are you on the right...... Zoran Hudec Jan 04, 2005

Follow up by mail Click here


Subject: auto update ftp script
Author: vanishri N, Singapore
Date: Dec 28, 2004, 2080 days ago
Os info: HP-UX
Message: Hi,
i want to write a script which auto update files using ftp from centralized server to different servers of corresponding directories.i am successfull writing script which does ftp to diffrent servers but unable to identify directories.here directory structure is not same to all servers..pls can anyone has script or can help for me in writing script.

thanks
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: auto update ftp script
Author: gouri sankar, India
Date: Dec 28, 2004, 2080 days ago
Message: Hi,

in the script what ever action you want to do in a particular directory, you need to go that directory which can done by "cd" command.

You can also use absolute path name for file for doing the job.

Gouri
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: auto update ftp script
Author: Zoran Hudec, Australia
Date: Dec 28, 2004, 2079 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: The request is not very clear. Do you have problems identifying the current directory on a server?
You can do this:
host_dir=`rsh $host pwd`
Or you need something else?

Do you want to specify target directory for each host?

#specify host
host=host2

#define target cd for each host where it's different than the default
cd_default=/usr/local/bin
eval cd_${host}=$cd_default
cd_host1=/apps/whatever
cd_host2=/apps/somethingelse
cd_host3=/usr/bin

eval cd=cd_${host}

$cd will contain the target directory for the specified host.

ftp -n <<EOF
user username password
cd $cd
prompt off
put file1
mput something
bye
EOF

note: I didn't test this, but I am sure with some fiddling you'd get it right.

Or you're after something else?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: auto update ftp script
Author: SUBROTO MUKHERJEE, India
Date: Dec 29, 2004, 2078 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Do you think your question is in any way related to oracle!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: auto update ftp script
Author: SUBROTO MUKHERJEE, India
Date: Dec 29, 2004, 2078 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Mr. Zoran Hudec, requarding you hudge and vast technical response related to the the ftp support, what i can finally conclude that register to a new forum with immediate effect that has nothing to do with oracle dba
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: auto update ftp script
Author: Zoran Hudec, Australia
Date: Jan 04, 2005, 2073 days ago
Message: SUBROTO,
what is your point? Are you on the right forum?
Here we help each other with all the tasks we encounter while doing the DBA work. That involves ftp, http, scp, snmp, tcp/ip , windows, linux, sun/os hp-ux and many other things.
As long as there is somebody willing to answer, there is no harm in asking. I don't consider this question out of line with all the rest. I only wish it was a bit clearer. Even that is not an issue, as long as the person asking it understands the answer and it helps the through the problems encountered.

Your comments on other hand are negative and discouraging.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here