SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-24-2008, 04:26 PM
| |||
| |||
 Re: SqlPlus by ftp what version of sqlplus? I know that http is supported as of 9.2, but haven't kicked the tires on ftp. Here is a link to the 10.1 docs on this subject: http://download-west.oracle.com/docs...3.htm#i2696724 -bdbafh      |
|
02-24-2008, 04:26 PM
| |||
| |||
| Re: SqlPlus by ftp daniellopez21 wrote: > How i can, execute a .sql file by ftp. > > I tried, sqlplus USER/PASS@SID > @ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql > > But, don't work. > > > Thank's ¡¡ Does this work without a login and password: ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql This may be the source of your problems as anonymous ftp must be configured for such calls to work. David Fitzjarrell |
|
02-24-2008, 04:26 PM
| |||
| |||
| Re: SqlPlus by ftp fitzjarrell@cox.net wrote: > daniellopez21 wrote: > >>How i can, execute a .sql file by ftp. >> >>I tried, sqlplus USER/PASS@SID >>@ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql >> >>But, don't work. >> >> >>Thank's ¡¡ > > > > Does this work without a login and password: > > ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql > > This may be the source of your problems as anonymous ftp must be > configured for such calls to work. > > > David Fitzjarrell > Apart from that - should it not be: host ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql, instead of: @ftp... ? -- Regards, Frank van Bortel Top-posting is one way to shut me up... |
|
02-24-2008, 04:27 PM
| |||
| |||
| Re: SqlPlus by ftp Frank van Bortel wrote: > fitzjarrell@cox.net wrote: > > daniellopez21 wrote: > > > >>How i can, execute a .sql file by ftp. > >> > >>I tried, sqlplus USER/PASS@SID > >>@ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql > >> > >>But, don't work. > >> > >> > >>Thank's ¡¡ > > > > > > > > Does this work without a login and password: > > > > ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql > > > > This may be the source of your problems as anonymous ftp must be > > configured for such calls to work. > > > > > > David Fitzjarrell > > > Apart from that - should it not be: > host ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql, > instead of: > @ftp... > ? > > -- > Regards, > Frank van Bortel > > Top-posting is one way to shut me up... According to the documentation (http://download-west.oracle.com/docs...3.htm#i2696724) his syntax is correct. Note the link shows both http and ftp using the @ shortcut to execute a script. My guess is anonymous ftp is not enabled, a username and password are not supplied, and the connection fails and thus the script is never loaded into the buffer. David Fitzjarrell |
|
02-24-2008, 04:27 PM
| |||
| |||
| Re: SqlPlus by ftp <fitzjarrell@cox.net> wrote in message news:1126817414.130355.120220@g47g2000cwa.googlegr oups.com... Frank van Bortel wrote: > fitzjarrell@cox.net wrote: > > daniellopez21 wrote: > > > >>How i can, execute a .sql file by ftp. > >> > >>I tried, sqlplus USER/PASS@SID > >>@ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql > >> > >>But, don't work. > >> > >> > >>Thank's ¡¡ > > > > > > > > Does this work without a login and password: > > > > ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql > > > > This may be the source of your problems as anonymous ftp must be > > configured for such calls to work. > > > > > > David Fitzjarrell > > > Apart from that - should it not be: > host ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql, > instead of: > @ftp... > ? > > -- > Regards, > Frank van Bortel > > Top-posting is one way to shut me up... According to the documentation (http://download-west.oracle.com/docs...3.htm#i2696724) his syntax is correct. Note the link shows both http and ftp using the @ shortcut to execute a script. My guess is anonymous ftp is not enabled, a username and password are not supplied, and the connection fails and thus the script is never loaded into the buffer. Maybe this works : @ftp://username  assword@xx.xxx.xx.xxx/mydir/mydir/myfile.sqlMatthias |
|
02-24-2008, 04:28 PM
| ||||
| ||||
| Re: SqlPlus by ftp daniellopez21 wrote: > Agggssss. i have a problem?¿? :S > > This statment work in sqlplus 9.2.0.6.0 in Solaris, but i don't work in > 9.2.0.1.0 in Windows 2000. This is one reason why you patched the server to 9.2.0.6. You should also patch the client software. David Fitzjarrell |
 |
« How to find Column name - ORA-01438: value larger than specified precision allows
|
"PRODUCT()" aggregate function »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 02:34 PM.
